RE: Editting sql run statements

wdsci-l-request@xxxxxxxxxxxx wrote:

>   3. Editting sql run statements (rob@dekko)
>
>How do I get syntax checking for SQL statements?  I will be using a member 
>in a source file to do RUNSQLSTM against.  Be cool if I could hit F4 on 
>one of the lines and get prompting.
>CREATE TABLE ROB/TEST1
>  (MYDATE DATE , 
>   MYNBR INT NOT NULL,
>PRIMARY KEY (MYNBR))  ;
>LABEL ON TABLE ROB/TEST1 IS 'Sample file';
>...

Rob:

I have no clear idea how easily it could be done within WDSC. In case someone 
wants to try, I put a simple *CMD and CPP to syntax-check an SQL statement into:

  http://code.midrange.com/index.php?id=a12058144a

It's set for 512-byte max length strings, but the source can be changed. If 
nothing else, it's an example of a start on the problem.

Tom Liotta