Skip to main content
Tweeted twitter.com/StackDBAs/status/1603087447142850563
edited tags
Link
mustaccio
  • 26.9k
  • 24
  • 58
  • 74
Source Link
lakshman
  • 273
  • 2
  • 5
  • 14

what is the formal statement terminator with db2 sql

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?