Skip to Content
avatar image
Former Member

SQL Statement Debug

Dear sirs,

I am writing a script for automating a job for changing several scripts (each script consists of one or more sql statement/s).

For this job I am using string functions (substr, locate, right....etc.), so that I read the original script and then do changes on it, and I am not sure whether at the end my job will create correct changes (from syntax point of view, i.e. will generate free of syntax error scripts).

The question is: is there any statement/command in dbisql that enables me to to read a string consisting of sql command/s and check the syntax (something similar to BUILD or COMPILE).

I know that the READ statement can read a script file but it will also execute it, but I don't want the scripts to be executed.

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 10, 2017 at 08:55 AM

    Use DBISQL (or the older dbisqlc program) with option "-x" in order to scan scripts without executing them.

    Add comment
    10|10000 characters needed characters exceeded