Insert, delete, and update files from CL

• Shalom Carmel
• Published: 21 Nov 2002

This is the way I manipulate file contents from CLP. This command can be used to run any SQL executable command.

  
/*CMD EXECSQL          */
EXECSQL:   CMD PROMPT('Execute SQL from CLP ')                    
                                                                           
PARM KWD(STMT) TYPE(*CHAR) LEN(4000) MIN(1) +           
CASE(*MIXED) PROMPT('SQL command')
/* end of CMD EXECSQL     */

/* RPG program EXECSQL    */
/* member must be of type SQLRPGLE  */

Dsqlin            s           4000                                 
C     *ENTRY        PLIST                                          
C                   PARM                    SQLIN                  
C/EXEC SQL prepare run from :sqlin                                 
C/END-EXEC                                                         
C/EXEC SQL execute run                                             
C/END-EXEC                                                         
C                   SETON                                        LR
  
  

==================================
MORE INFORMATION ON THIS TOPIC
==================================

The Best Web Links: tips, tutorials and more.

Ask your programming questions--or help out your peers by answering them--in our live discussion forums.

Ask the Experts yourself: Our application development gurus are waiting to answer your programming questions.