I have added
/ character as statement terminator all in my db2 statements. I can run sql file in data studio client without any issue. But when I run the sql file in db2 command prompt by issuing
db2 -tsvf db2.sql command I got
DB21007E End of file reached while reading the command.
error. I could resolve this issue by changing statement terminator character from
My question is should I keep statement terminator character as
;? If I keep
/, is there any way to run sql file from command line also?