Hi Dave, I got it, thanks.
From: Dave Birdsall [mailto:[email protected]] Sent: Wednesday, November 22, 2017 12:56 AM To: [email protected] 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:[email protected]] Sent: Monday, November 20, 2017 6:07 PM To: [email protected]<mailto:[email protected]> 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:[email protected]] Sent: Tuesday, November 21, 2017 12:33 AM To: [email protected]<mailto:[email protected]> 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:[email protected]] Sent: Monday, November 20, 2017 1:08 AM To: [email protected]<mailto:[email protected]> Subject: on cursor Hi all, Is cursor supported in Trafodion? If so, where can I find the documents on this? Thanks, Wenjun Zhu
