hi,all!
i am new to db2,and i run into this problem:
i wrote a very simple script named test.db2:
create table table1(filed1 integer)@
create table table2(filed1 integer)@


and i run it in the clp(in linux):
su db2inst1
db2 connect to test1(the db i want to operate)
db2 -td@ -vf test.db2

but unfortunatly,the output is:
create table table2(filed1 integer)
DB21034E The command was processed as an SQL statement bacause
it was not a valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token"create table table1(filed1 integer)@"was found following"BEGIN-OF-STATEMENT".Expected tokens may include:""<space>".
SQLSTATE=42601

the strange thing is that when i only write one statement in the script,for instance,"create table table1(filed1 integer)@",than,everything is ok!
why?
i will appreciate every help!
thanks!

Strange ....
Do you want to try leaving a space between ) and @ ? Try again

Cheers
Sathyaram

hi,Sathyaram!
it's so nice of u to give me advice.
and i try what u suggest to me,but the result is the same. : (
anyway,thank u very much!

Hi,

1. Create file test.db2 and put sqls in this file delimered with ;
Sample:
create table table1(filed1 integer);
create table table2(filed1 integer);

2. Run test.db2
db2 -tvf test.db2

Hope this helps,
Grofaty

Hi,

I have tested your way zswparamount.
If works fine for me, with no problems.

Grofaty

hi,every one!
Thanks very much!
yes, it works now!
and i knew why now!because i wrote the script in the OS of windows 2000 ,and copy it to the linux.so .....