Re: Editting sql run statements

Hi Rob,

If your SQL statements are imbedded in ILE RPG or COBOL, you can syntax
check these SQL statements through RSE.
Open your source in RSE, select your SQL statement, right click on it and
choose syntax check selection. If you are connected to the iSeries, your
SQL statements will be syntax checked.  You can also syntax check the
entire source file if you have a few SQL statements that all require syntax
checking.
There is also an option in the preferences, that will turn the SQL syntax
checking ON while editing. However, SQL syntax checking is performed on the
iSeries and it may be a bit slow depending on your connection.

Regards,
Nazmin Haji



                                                                           
             rob@xxxxxxxxx                                                 
             Sent by:                                                      
             wdsci-l-bounces@m                                          To 
             idrange.com               wdsci-l@xxxxxxxxxxxx                
                                                                        cc 
                                                                           
             11/21/2005 04:38                                      Subject 
             PM                        [WDSCI-L] Editting sql run          
                                       statements                          
                                                                           
             Please respond to                                             
                 Websphere                                                 
                Development                                                
             Studio Client for                                             
                  iSeries                                                  
                                                                           
                                                                           




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
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
This is the Websphere Development Studio Client for iSeries  (WDSCI-L)
mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.