You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@trafodion.apache.org by "Zhu, Wen-Jun" <we...@esgyn.cn> on 2017/11/20 09:07:37 UTC
on cursor
Hi all,
Is cursor supported in Trafodion? If so, where can I find the documents on this?
Thanks,
Wenjun Zhu
RE: on cursor
Posted by "Zhu, Wen-Jun" <we...@esgyn.cn>.
Hi Dave,
I got it, thanks.
From: Dave Birdsall [mailto:dave.birdsall@esgyn.com]
Sent: Wednesday, November 22, 2017 12:56 AM
To: user@trafodion.incubator.apache.org
Subject: RE: on cursor
Hi Wen-Jun,
Unfortunately I am not an ODBC (or JDBC) expert, but my understanding is that Trafodion implements the ODBC standard, and that standard supports cursors.
As for cursor expressions, I'm guessing you had in mind something like Oracle's cursor expression support (as described here: https://docs.oracle.com/cd/B28359_01/server.111/b28286/expressions006.htm#SQLRF52057). Trafodion does not support that to my knowledge.
Dave
From: Zhu, Wen-Jun [mailto:wenjun.zhu@esgyn.cn]
Sent: Monday, November 20, 2017 6:07 PM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: RE: on cursor
Hi Dave,
I looked up the word cursor in the document Trafodion SQL Reference Manual, and found little thing on it,
except that it is listed as a reserved SQL identifiers.
l As you mention JDBC, I referred JDBC Type 4 Programmer’s Reference Guide, and find it is supported,
l Also the cursor can be used in SJP, as Stored Procedures in Java (SPJs) Guide states,
l I didn’t find ODBC reference, but I guess it is supported too,
l cursor expression is not supported, right?
Then I guess I know how much cursor is supported in Trafodion.
Thank you very much.
From: Dave Birdsall [mailto:dave.birdsall@esgyn.com]
Sent: Tuesday, November 21, 2017 12:33 AM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: RE: on cursor
Hi Wenjun,
Can you say a little more? Are you asking this question from a JDBC context? ODBC?
Dave
From: Zhu, Wen-Jun [mailto:wenjun.zhu@esgyn.cn]
Sent: Monday, November 20, 2017 1:08 AM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: on cursor
Hi all,
Is cursor supported in Trafodion? If so, where can I find the documents on this?
Thanks,
Wenjun Zhu
RE: on cursor
Posted by Dave Birdsall <da...@esgyn.com>.
Hi Wen-Jun,
Unfortunately I am not an ODBC (or JDBC) expert, but my understanding is that Trafodion implements the ODBC standard, and that standard supports cursors.
As for cursor expressions, I'm guessing you had in mind something like Oracle's cursor expression support (as described here: https://docs.oracle.com/cd/B28359_01/server.111/b28286/expressions006.htm#SQLRF52057). Trafodion does not support that to my knowledge.
Dave
From: Zhu, Wen-Jun [mailto:wenjun.zhu@esgyn.cn]
Sent: Monday, November 20, 2017 6:07 PM
To: user@trafodion.incubator.apache.org
Subject: RE: on cursor
Hi Dave,
I looked up the word cursor in the document Trafodion SQL Reference Manual, and found little thing on it,
except that it is listed as a reserved SQL identifiers.
l As you mention JDBC, I referred JDBC Type 4 Programmer’s Reference Guide, and find it is supported,
l Also the cursor can be used in SJP, as Stored Procedures in Java (SPJs) Guide states,
l I didn’t find ODBC reference, but I guess it is supported too,
l cursor expression is not supported, right?
Then I guess I know how much cursor is supported in Trafodion.
Thank you very much.
From: Dave Birdsall [mailto:dave.birdsall@esgyn.com]
Sent: Tuesday, November 21, 2017 12:33 AM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: RE: on cursor
Hi Wenjun,
Can you say a little more? Are you asking this question from a JDBC context? ODBC?
Dave
From: Zhu, Wen-Jun [mailto:wenjun.zhu@esgyn.cn]
Sent: Monday, November 20, 2017 1:08 AM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: on cursor
Hi all,
Is cursor supported in Trafodion? If so, where can I find the documents on this?
Thanks,
Wenjun Zhu
RE: on cursor
Posted by "Zhu, Wen-Jun" <we...@esgyn.cn>.
Hi Dave,
I looked up the word cursor in the document Trafodion SQL Reference Manual, and found little thing on it,
except that it is listed as a reserved SQL identifiers.
l As you mention JDBC, I referred JDBC Type 4 Programmer’s Reference Guide, and find it is supported,
l Also the cursor can be used in SJP, as Stored Procedures in Java (SPJs) Guide states,
l I didn’t find ODBC reference, but I guess it is supported too,
l cursor expression is not supported, right?
Then I guess I know how much cursor is supported in Trafodion.
Thank you very much.
From: Dave Birdsall [mailto:dave.birdsall@esgyn.com]
Sent: Tuesday, November 21, 2017 12:33 AM
To: user@trafodion.incubator.apache.org
Subject: RE: on cursor
Hi Wenjun,
Can you say a little more? Are you asking this question from a JDBC context? ODBC?
Dave
From: Zhu, Wen-Jun [mailto:wenjun.zhu@esgyn.cn]
Sent: Monday, November 20, 2017 1:08 AM
To: user@trafodion.incubator.apache.org
Subject: on cursor
Hi all,
Is cursor supported in Trafodion? If so, where can I find the documents on this?
Thanks,
Wenjun Zhu
RE: on cursor
Posted by Dave Birdsall <da...@esgyn.com>.
Hi Wenjun,
Can you say a little more? Are you asking this question from a JDBC context? ODBC?
Dave
From: Zhu, Wen-Jun [mailto:wenjun.zhu@esgyn.cn]
Sent: Monday, November 20, 2017 1:08 AM
To: user@trafodion.incubator.apache.org
Subject: on cursor
Hi all,
Is cursor supported in Trafodion? If so, where can I find the documents on this?
Thanks,
Wenjun Zhu