Re: How to retrieve SQL results into CL pgm

Try this:
        https://www.mcpressonline.com/programming/sql/using-dynamic-sql-in-cl-part-2retrieving-a-data-value  ;

On Friday, June 3, 2022, 05:31:43 PM EDT, Steve McKay <samckay1@xxxxxxxxx> wrote:

How can I run an SQL statement and retrieve the results into a CL pgm?

For example, I want to SELECT COUNT(*) FROM QSYS2.ASP_INFO: but I want to
run it using RUNSQL in a CL program and get the COUNT into a variable in
the CL program.

Something like this:
DCL &COUNT *DEC LEN(1)
RUNSQL SQL( SELECT COUNT(*) FROM QSYS2.ASP_INFO)
and get the SQL statement result in the CL &COUNT field.

Ultimately, I want to do different things depending on whether there is 1
ASP or more than 1 ASP so I'm really after the count of ASPs on the
system.  If there is a better way to do this within CL, I'm open to
suggestions.

Thanks,

Steve McKay
(205) 585-8424
samckay1@xxxxxxxxx