Setting the SQL terminator character in a SPUFI input data set
In the SPUFI input data set, you can override the SQL terminator character that is specified on the CURRENT SPUFI DEFAULTS panel. The default SQL terminator is a semicolon (;).
About this task
Overriding the default SQL termination character is useful if you need to use a different SQL terminator character for one particular SQL statement.
To set the SQL terminator character in a SPUFI
input data set, specify the text --#SET TERMINATOR character before
that SQL statement to which you want this character to apply. This
text specifies that SPUFI is to interpret character as
a statement terminator. You can specify any single-byte character except the
characters that are listed in Table 1. Choose a character
for the SQL terminator that is not used within the statement. The
terminator that you specify overrides a terminator that you specified
in option 1 of the CURRENT SPUFI DEFAULTS panel or in a previous --#SET
TERMINATOR statement.
| Name | Character | Hexadecimal representation |
|---|---|---|
| blank | X'40' | |
| comma | , | X'5E' |
| double quote | " | X'7F' |
| left parenthesis | ( | X'4D' |
| right parenthesis | ) | X'5D' |
| single quote | ' | X'7D' |
| underscore | _ | X'6D' |
Use a character other than a semicolon if you plan
to execute a statement that contains embedded semicolons. For example,
suppose that you choose the character # as the statement terminator.
In this case, a CREATE TRIGGER statement with embedded semicolons
looks like this:
CREATE TRIGGER NEW_HIRE
AFTER INSERT ON EMP
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
UPDATE COMPANY_STATS SET NBEMP = NBEMP + 1;
END#Parent topic: Executing SQL by using SPUFI