Running SQL commands from CL (or elsewhere)

So much of...

Except that CL can't write data to a source file (directly).  You'd

have 
to call an HLL or QShell to write the records, and if you're going to
do 
that, you may as well use the HLL or QShell to execute the SQL commands

directly rather than writing it to a source file  <<<

Call the SQL from REXX (best way) using something like:
                                                               
   INSERT_STMT = 'INSERT INTO HTEUSR/PRNCELS   VALUES(?,?)'    
                                                               
 ADDRESS '*EXECSQL'                                            
      EXECSQL 'SET OPTION COMMIT = *NONE'                      
      EXECSQL,                                                 
               'PREPARE S1 FROM :INSERT_STMT'                  
      EXECSQL 'EXECUTE S1 USING :fname1, :exten'               

 OR write to files via REXX and you don't have to mess with any CL,
QShell, HLL, etc. 

Just a workable and simple alternative.

Take care,

Dave