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.
Add comment