db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-3755) ij's help text lacks the optional [HOLD | NOHOLD] syntax for GET CURSOR
Date Thu, 03 Jul 2008 15:10:45 GMT
ij's help text lacks the optional [HOLD | NOHOLD] syntax for GET CURSOR
-----------------------------------------------------------------------

                 Key: DERBY-3755
                 URL: https://issues.apache.org/jira/browse/DERBY-3755
             Project: Derby
          Issue Type: Bug
          Components: Tools
            Reporter: Dag H. Wanvik
            Priority: Minor
             Fix For: 10.5.0.0


ij's help command shows the syntax of GET CURSOR as:

GET [SCROLL INSENSITIVE] CURSOR name AS 'SQL-J query';
                               -- gets a cursor (JDBC result set) on the query
                               -- SCROLL cursors are only available 
                               -- in JDBC 2.0 and higher. 
                               -- (Cursor scroll type is ignored in JDBC 1.X.) 

One can actually also specify holdability, so the syntax show read:

GET [SCROLL INSENSITIVE] [HOLD | NOHOLD] CURSOR name AS 'SQL-J query';

and the comment should also state that HOLD is the default.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message