1.1

Description
Fetches the next row from the named cursor created with the get scroll insensitive cursor on page 434. It displays
a banner and the values of the row.
Example
sqlf(PEERCLIENT)> get scroll insensitive with nohold cursor
scrollCursor as 'select * from firsttable order by id';
sqlf(PEERCLIENT)> absolute 3 scrollCursor;
ID |NAME
------------------------
30 |THIRTY
sqlf(PEERCLIENT)> first scrollCursor;
ID |NAME
------------------------
10 |TEN
sqlf(PEERCLIENT)> next scrollCursor;
ID |NAME
------------------------
20 |TWENTY
prepare
Creates a java.sql.PreparedStatement using the value of the String, accessible in sqlf by the Identifier given
to it.
Syntax
PREPARE
Identifier
AS
String
Description
Creates a java.sql.PreparedStatement using the value of the String, accessible in sqlf by the Identifier given
to it. If a prepared statement with that name already exists in sqlf, an error is returned and the previous prepared
statement remains. Use the remove on page 442 command to remove the previous statement first. If errors occur,
no prepared statement is created.
Any SQL statements allowed in the underlying connection's prepared statement can be prepared with this
command.
Example
sqlf(PEERCLIENT)> prepare listAirlines as 'SELECT * FROM
airlines';
sqlf(PEERCLIENT)> execute listAirlines;
439
sqlf Interactive Commands