Error when executing RUNSQLSTM from CL program
I am trying to use the RUNSQLSTM command. I get the error message "statement not allowed"Not really trying anything fancy.In CL program RUNSQLSTM SRCFILE(jwe/QCLSRC) SRCMBR(SQL1) + COMMIT(*NONE) In SQL1 I haveSELECT mstid, ...
View Answer
| May 6 2008 3:32 PM GMT
| asked by
Tcwalls
AS/400, SQL, RUNSQLSTM
RUNSQLSTM
am executing a RUNSQLSTM out of a CL program that run a source SQL statement in a source file of a library. Everytime the statement is executed I get a output spool file of the SQL parmeters and execution results. How can I prevent this?
View Answer
| Mar 6 2008 7:41 PM GMT
| asked by
Abbey
RUNSQLSTM, CL, SQL
Changing Table with RUNSQLSTM
I have a table that I need to increase in size. It was created using QDDLSRC and the RUNSQLSTM command. This table has a DDM file connected to it. Is the a CHANGE TABLE or REPLACE TABLE statement that I could replace the CREATE TABLE statement with so I can rerun the RUNSQLSTM and leave the DDM...
Answer Question
| Dec 13 2007 5:54 PM GMT
| asked by
Las Vegas Lopez
SQL, DDM, RUNSQLSTM
