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.
This was first published in November 2002