More Than One SQL Statement 2

[Skittle]

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'.

 

[mikrom]

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.

 

[Mercury2]

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.

 

[Skittle]

OK, thanks chaps.



Dazed and confused.

Remember.. 'Depression is just anger without enthusiasum'.