Click on the link at the bottom of this post to the IBM website for a list of what statements are supported. You cannot execute all SQL statements using the RUNSQL command. While I do not see the RUNSQL command replacing my use of SQLRPGLE, I do see it eliminating most of my use of QMQRYs. I always considered it too much work and either used a SQLRPGLE, RPGLE with embedded SQL, or a QMQRY, Query Management Query. The way I knew to run build a SQL statement in CL program was to write it to a source member that could then be used by the RUNSQLSTM command. To use this command I need to have the SQL statement in a source member. Prior to IBM i 7.1 I would have to use the RUNSQLSTM command. This allows me to run SQL statements within the CL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |