Re: Editting sql run statements

I've usually tried it in STRSQL first and then pasted into the member to
be run.  

There may be some way iSeries Navigator can do this but I haven't
learned that yet.

hth, 

Dave Boettcher

>>> rob@xxxxxxxxx 11/21/2005 3:38:27 PM >>>
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 Berendt