Re: Bit Testing in CL Program?

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 12/20/2016
10:14:39 AM:

SELECT SYSTEM_TABLE_SCHEMA, SYSTEM_TABLE_NAME,
SYSTEM_TABLE_MEMBER
FROM qsys2.syspartitionstat
WHERE SYSTEM_TABLE_SCHEMA='ROB' and
SYSTEM_TABLE_NAME='QPGMSRC'

If names longer than 10 characters, like syspartitionstat, blow your

mind

you can replace that with syspstat.

I'm comfortable with long SQL names but I don't like calling SQL
from CL unless I'm not needing any returned values. In particular, I
don't even know that it is possible for data values to be passed into CL
variables from SQL that is invoked from CL. I'm interested in being
enlightened on that score, though. I also don't want to add an RPG call
into the process. But thanks anyway.

Sincerely,

Dave Clark