Skip to main content
Question

DBD requires semicolon atg end of file?

  • May 10, 2019
  • 1 reply
  • 5 views

Bryan_H
Forum|alt.badge.img+2

Hi, have a customer using 9.2.0-6 who found a curious issue running DBD. They tried running DBD from admintools using a single query in a file. It didn't work. Checking all logs, we found DBD found 0 queries in the file, though the file worked with vsql -f . Eventually we found we had to terminate the query with a semicolon to get DBD to accept it.

Is this expected? I understand DBD uses semicolon to delimit queries, but I would not expect a delimiter to be required at EOF. Does this need a JIRA?

1 reply

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • June 20, 2019

Yes. A semi-colon is required after each SQL statement, even if there is only one :)