How do I execute a bunch of sql statements from the command centre?
@ is my statement terminator
I was doing the following
CREATE TABLE test1 (
CREATE TABLE test2 (
and the error I got was
SQL0104N An unexpected token "test1" was found following
CREATE TABLE". Expected tokens may include: "<space>
A syntax error in the SQL statement was detected at the specified
token following the text "<text>". The "<text>" field indicates
the 20 characters of the SQL statement that preceded the token
that is not valid.
As an aid to the programmer, a partial list of valid tokens is
provided in the SQLERRM field of the SQLCA as "<token-list>".
This list assumes the statement is correct to that point.
The statement cannot be processed.
Examine and correct the statement in the area of the specified