Re: SQL Stored Procedure Strangeness

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 02/26/2018
09:22:01 PM:

You've shown us the source for IM_LIFO_BACKUP and IM_LIFO_RESTORE but

not

the source for IMLFBACKUP and IMLFRESTOR.

How much of the CL do you need to see? The following is from
IMLFBACKUP:

SNDPGMMSG MSG(&SQLSTMT) TOPGMQ(*SAME) MSGTYPE(*INFO)
RUNSQL SQL(&SQLSTMT) COMMIT(*CS) NAMING(*SYS)

and the following is from IMLFRESTOR (added the SNDPGMMSG today
for testing):

SNDPGMMSG MSG(&SQLSTMT) TOPGMQ(*SAME) MSGTYPE(*INFO)
RUNSQL SQL(&SQLSTMT) COMMIT(*CS) NAMING(*SYS)

Sincerely,

Dave Clark