Problem solve Get help with specific problems with your technologies, process and projects.

Insert, delete, and update files from CL

Manipulate file contents from CLP.

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.


Dig Deeper on iSeries CL programming

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close