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
Use DBISQL (or the older dbisqlc program) with option "-x" in order to scan scripts without executing them.
Thanks for the reply, is it however possible to stay in the same session of DBISQL (which must already be started w/o -X)?
I am writing a script which goes through stored scripts of mobilink, and do particular changes in each of those scripts.
I need to execute my script in DBISQL (w/o -X).
So, is it possible to scan the newly changed mobilink scripts within the same session of DBISQL?
The only solution which I have now is to export all the newly changed scripts into txt files and then let a batch file go through those txt files and read them with DBISQL -X.
Please let me know if there is any other suggestions, so that I eliminate the need for the batch file.
Thanks in advance
Not that I'm aware of. There are some functions like "SQLDIALECT" that will parse SQL statements (but possibly not whole batches) but I don't know whether they do enough checking for you.
As usually, I'd recommend to ask that in the separate SAP SQL Anywhere Forum because your chances are way higher to get in contact with SQL Anywhere staff members there.