More Than One SQL Statement More Than One SQL Statement Skittle (ISP) (OP) 3 Jun 09 10:18 Is there a way of coding more than one SQL statement to run in a file from CRTQMQRY/STRQMQRY commands?I'm looking to code multiple INSERT and DELETE statements for different files in the same QQMQRYSRC file. Dazed and confused.Remember.. 'Depression is just anger without enthusiasum'. RE: More Than One SQL Statement mikrom (Programmer) 3 Jun 09 15:10 IMHO it's not possible. In QM-Query you can have only one SQL-statement, i.e. for multiple SQL-statements you need to create multiple QM-Queries.But you can code more than one SQL statements in a source member (by default it should be placed in a Source Physical File named QSQLSRC) and then run that SQL-member using RUNSQLSTMT.I personally prefer to code rather embedded SQL in REXX/400. It enables better error treatment and using of additional logic. RE: More Than One SQL Statement Mercury2 (TechnicalUser) 4 Jun 09 06:25 If RUNSQLSTM, 1/ use semi-colon as separator at the end of each sql stm.2/ you can NOT pass any parameters to the procedure : each stm must be hard-coded.3/ the source file can have any name i.e.QSQLSRC is not mandatory.4/ if parameters used, you'd be better off creating a HLL program. RE: More Than One SQL Statement Skittle (ISP) (OP) 4 Jun 09 11:15 OK, thanks chaps. Dazed and confused.Remember.. 'Depression is just anger without enthusiasum'.