Filter
Top Products
ISQL and Tools
3-12 FairCom Corporation
<SQL statement>
ROLLBACK WORK ;
An SQL statement starting immediately after a COMMIT WORK or ROLLBACK WORK
statement starts a new transaction.
3.7 ISQL REFERENCE
This section provides reference material for statements specific to ISQL.
This section does not include descriptions of standard SQL statements or statements specific to
embedded SQL. For details on the syntax and semantics of those other SQL statements, see the
c-treeSQL Reference Manual.
3.7.1 @ (Execute)
Syntax
@filename
Description
Executes the SQL statements stored in the specified SQL script file. The statements specified
in the file are not added to the history buffer.
Arguments
filename
The name of the script file.
Notes
The GET, START, and @ (execute) statements are similar in that they all read SQL script files.
Both GET and START read an SQL script file and append the first statement in it to the history
buffer. However, the START statement also executes the script statement and accepts argu-
ments that it substitutes for parameter references in the script statement. The @ (execute) state-
ment, on the other hand, executes all the statements in an SQL script file but does not add any
of the statements to the history buffer. The @ statement does not support argument substitu-
tion.
Example
The following example shows a simple ISQL script file.
Example 3-7: Sample ISQL script
connect to demodb;
set echo on ;
create table stores (item_no integer, item_name char(20));