Free Program Runsqlstm In Cl Program Examples

STRSQL is a powerful and useful interactive tool (in the right hands) but it can be cumbersome to retrieve previous SQL statements, modify them and then run them again all the while hoping there are no typos. If you find yourself frequently entering the same SQL commands why not save them to a text file and automate the process? I like to save the SQL statements in a source file named qtxtsrc. Goldspot And The Elephant Is Dancing Rar here. Once saved the SQL can be executed from a CL containing the RUNSQLSTM command. In this example two inventory file field definitions were reversed during an upgrade and the data had to be swapped (mapped correctly) during the process. This can be accomplished with one SQL statement.

When I’m running the following SQL statement in my CL program, I get an error “Function check. SQL9010 unmonitored by @SQLCLP” (@sqlclp is the name of my CL.

Note that there is no need for messy work fields that might otherwise be used when coding the same solution in RPG. Create the text type source member. Contents of the source member sqlfswap (saved as a text file).