Join Bytes! wrote:
[color=blue]
> Normally I use the semicolon for statement delimiters in plain SQL
> scripts (for DDL, simple DML etc.).
>
> But inside SQL/PL I tend to use % or @ as statement delimiters. But
> other people prefer other delimiters.
>
> I know that I can use the CLP option "-td" to specify the delimiter on
> the command line, when invoking the script. But this requires me to
> look inside the scripts to find the delimiter before I run the script.
>
> It would be nice for the script itself to be able to declare its own
> delimiter inside itself, thereby allowing calling scripts to not-care
> about which delimiter(s) are used inside of any particular script, and
> if the script did not make any such declaration then some default (like
> semicolon etc) would apply. Something like "SET STATEMENT_DELIMITER %".[/color]
In the DB2 doc I just find this:
Statement Termination Character Option (-t):
The -t option tells the command line processor to use a semicolon (;) as
the statement termination character, and disables the backslash (\) line
continuation character.
Note:
This option *cannot* be changed from within the interactive mode.
http://publib.boulder.ibm.com/infoc...re/r0010410.htm
--
Knut Stolze
Information Integration Development
IBM Germany / University of Jena
