3

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 / to ;. My question is should I keep statement terminator character as / or ;? If I keep /, is there any way to run sql file from command line also?

6

You would need to use the -td<statement terminator> syntax. So you would need to format the above as follows:

db2 -td/ -svf db2.sql

This would tell DB2 that your statement terminator is the / character, otherwise, yes the default is the semicolon ;.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.