MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » July 2014

RE: compiling CLP with RUNSQL statement to previous release V6R1



fixed

IBM's RUNSQL command came out with certain PTF's.
It exists in QSYS
DSPCMD RUNSQL
Command . . . . . . . : RUNSQL Library . . . . . . . : QSYS

Program to process command . . . . . . : QSQSCHEM
Library . . . . . . . . . . . . . . : QSYS

There's two major issues with it, and the third party products that came
out.
The first being the parameter names have changed. This is the #1 killer
with imbedded versions of RUNSQL. The first parameter in the IBM version
is SQL. The first parameter in other versions may be REQUEST or some such
thing.
The second major issue is that the IBM one will not let you do a simple
SELECT.
RUNSQL SQL('select * from routines/dskdtl')
SQL statement not allowed.

Another issue is that the IBM version defaults to running under some sort
of commitment control so you often have to
RUNSQL SQL(...) COMMIT(*NONE)
If you're not journalling, or you do not want to forget to 'commit' your
changes.


Rob Berendt





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact