Re: ADDEXITPGM with CRTSQLRPGI

Gad,

If you issue:
    DSPCMD QSYS/CRTSQLRPGI  

you will see that it is not a normal command, but a "proxy" that points to the real command QSQL/CRTSQLRPGI ...   

If you issue:
    WRKOBJPDM  QSYS  CRTSQLRPGI  *CMD

you will see that the *CMD object has an attribute of "PRX" for "proxy".

You cannot use "proxy" commands with ADDEXITPGM ... you must use the "real" command, e.g. in this case, QSQL/CRTSQLRPGI 


All the best,

Mark S. Waterbury

On Sunday, November 12, 2023 at 04:15:42 AM EST, Gad Miron <gadmiron@xxxxxxxxx> wrote:

Hello Sages

Many moons ago (many suns ago actually, more then I care to remember) I
have added a sort of a "Precompiler" to CRTBNDRPG and CRTRPGMOD by adding Exit PGM to these 2 CMDs for setting LIBL, OVRDBF etc. (I was helped by Bruce Vining) 

For instance:

ADDEXITPGM EXITPNT(QIBM_QCA_CHG_COMMAND)     FORMAT(CHGC0100) PGMNBR(2)
    PGM(ACUMGPL/RPGEXITPGM) 
    PGMDTA(*JOB 20 'CRTRPGMOD QSYS')

However, I failed to do the same with CRTSQLRPGI,

Issuing:

ADDEXITPGM EXITPNT(QIBM_QCA_CHG_COMMAND)     FORMAT(CHGC0100) PGMNBR(3)
    PGM(ACUMGPL/RPGEXITPGM) 
    PGMDTA(*JOB 20 'CRTSQLRPGI QSYS')

fails with MSG

    CPF0197 Value  QSYS/CRTSQLRPGI is not a valid name.

I sure can use some help here

TIA

Gad