how to write more than one sql statement under EXEC SQL in SQLRPGLE.
Hi, Can anyone please help me to write more than one SQL statements under single EXEC SQL and END EXEC as below.
Since i have 10 sql statements and wanted to include all those 10 statements under single block of EXEC SQL and END EXEC by using any seperator like below.
C/EXEC SQL
C+Insert into A values('A','B');
C+Insert into B values('C', 'D');
|
|
| (indication of many sql statements)
C/END EXEC
Software/Hardware used:
Since i have 10 sql statements and wanted to include all those 10 statements under single block of EXEC SQL and END EXEC by using any seperator like below.
C/EXEC SQL
C+Insert into A values('A','B');
C+Insert into B values('C', 'D');
|
|
| (indication of many sql statements)
C/END EXEC
Software/Hardware used:
ASKED:
March 26, 2012 7:52 PM
UPDATED:
March 26, 2012 8:27 PM
Other Answers:
Latest Answer Wiki Contributors:
To see other answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
