1.1.1

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 454 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;
A&|AIRLINE_FULL |BASIC_RATE
|DISTANCE_DISCOUNT |BUSINESS_LEVEL_FACTOR
|FIRSTCLASS_LEVEL_FACT&|ECONOMY_SE&|BUSINESS_S&|FIRSTCLASS&
-----------------------------------------------------------------------------------------------------------------------------------------------------------
NA|New Airline |0.2 |0.07
|0.6 |1.7
|20 |10 |5
US|Union Standard Airlines |0.19 |0.05
|0.4 |1.6
|20 |10 |5
AA|Amazonian Airways |0.18 |0.03
|0.5 |1.5
|20 |10 |5
3 rows selected
previous
Moves the cursor to the row previous to the current one, then fetches the row.
Syntax
PREVIOUS
Identifier
Description
After the cursor is created with the get scroll insensitive cursor on page 446 command, Moves the cursor to the
row previous to the current one, then fetches the row. 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
vFabric SQLFire User's Guide452
vFabric SQLFire Reference