[DERBY-3755] ij's help text lacks the optional [HOLD | NOHOLD] syntax for GET CURSOR

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 10.5.1.1
• Component/s: Tools
• Assignee: Dag H. Wanvik
• Reporter: Dag H. Wanvik
• Created: 03/Jul/08 15:09
• Updated: 04/May/09 18:22
• Resolved: 14/Jul/08 12:31

Description

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.

Issue Links

• relates to: DERBY-3756 Tools Guide topic for GET CURSOR command needs fixing