1.1.1

Example
sqlf(PEERCLIENT)> create table firsttable (id int primary
key,
> name varchar(12));
0 rows inserted/updated/deleted
sqlf(PEERCLIENT)> insert into firsttable values
> (10,'TEN'),(20,'TWENTY'),(30,'THIRTY');
3 rows inserted/updated/deleted
sqlf(PEERCLIENT)> select * from firsttable;
ID |NAME
------------------------
20 |TWENTY
30 |THIRTY
10 |TEN
3 rows selected
sqlf(PEERCLIENT)> create table newtable (newid int primary
key,
> newname varchar(12));
0 rows inserted/updated/deleted
sqlf(PEERCLIENT)> prepare listFirstTable as 'select * from
firsttable';
sqlf(PEERCLIENT)> autocommit off;
sqlf(PEERCLIENT)> execute 'insert into newtable(newid,
newname)
> values(?,?)' using listFirstTable;
1 row inserted/updated/deleted
1 row inserted/updated/deleted
1 row inserted/updated/deleted
sqlf(PEERCLIENT)> commit;
sqlf(PEERCLIENT)> select * from newtable;
NEWID |NEWNAME
------------------------
20 |TWENTY
30 |THIRTY
10 |TEN
3 rows selected
exit
Completes the sqlf application and halts processing.
Syntax
EXIT
Description
Causes the sqlf application to complete and processing to halt. Issuing this command from within a file started
with the run on page 456 command or on the command line causes the outermost input loop to halt.
sqlf exits when the Exit command is entered or if given a command file on the Java invocation line, when the
end of the command file is reached.
445
sqlf Interactive Commands