MVSFORUMS.com

SMS · Beginner Joined: 16 Oct 2005 Posts: 53 Topics: 24

Hi,

I have tried to run a stored procedure, but I am getting the below error.

kolusu · Posted: Tue Dec 11, 2007 7:03 pm Post subject:

SMS,

How are you invoking the SP? Via a pgm or thru web? Are you using DSNRLI (for RRSAF calling) ?
_________________
Kolusu
www.linkedin.com/in/kolusu

SMS · Beginner Joined: 16 Oct 2005 Posts: 53 Topics: 24

I am invoking the stored procedure via a COBOL program. Yes I am using DSNRLI.
_________________
Regards,
SMS

dbzTHEdinosauer · Posted: Wed Dec 12, 2007 8:21 am Post subject:

Have you signed-on to RRSAF prior to attempting any SQL?
_________________
Dick Brenholtz
American living in Varel, Germany

SMS · Beginner Joined: 16 Oct 2005 Posts: 53 Topics: 24

Actually I am not explicity doing anything with the RRSAF. For compiling the programs, we have the customized comilation screens wherein we will just provide the required program details. The system will generate the required JCL.

While compiling the Cobol program which calls the stored procedure, for the DBRM lib location I had given the source code library instead by mistake. After which I am getting this -981 error.

Please tell me how do I check whether my ID has implicitly signed on to RRSAF.
_________________
Regards,
SMS

dbzTHEdinosauer · Posted: Wed Dec 12, 2007 9:59 am Post subject:

If your shop has been running db2 programs (which may or may not invoke SP) under RRSAF, then they have an inhouse procedure.

a few years ago I wrote a cobol module that when invoked (CALLed) would perform the sign-on to rrsaf. Cobol DB2 modules where pre-compiled with the ATTACH(RRSAF) parm. Your Stored Procedure must also be pre-compiled with the ATTACH(RRSAF) parm. RRSAF COBOL/DB2 modules can be executed by PGM=COBOL-PROGRAM_NAME. If you use IKJEFT..., be sure that you have no DSN parms. The plan/package/DB2 SSID connect info is sent to RRSAF, not DB2.

somewhere, someplace in your shop, there is a program or utility that will perform a RRS Attach instead of a CAF attach.

Maybe IKJEFT.. has a new subroutine that will perform the rrs attach instead of a caf attach.

Your shop, your standards.
_________________
Dick Brenholtz
American living in Varel, Germany

kolusu · Posted: Wed Dec 12, 2007 11:24 am Post subject:

SMS,

You are invoking the SP via COBOL program which is Invoked via IKJEFT01 which is a batch TSO Call Attachment Facility. You CanNOT do that. simply because one attachment facility cannot start another. This means your RRSAF application cannot use DSN, and a DSN RUN subcommand cannot call your RRSAF application.

I suggest that you use CAF module DSNALI to invoke the SP

Check this link for more information on RRSAF and its limitations.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPJ12/6.8?DT=20050328013405

Hope this helps...

Cheers
_________________
Kolusu
www.linkedin.com/in/kolusu

SMS · Beginner Joined: 16 Oct 2005 Posts: 53 Topics: 24

Thanks to all.

Actually that stored procedure was trying to use a new table.
In my shop, for every new table there should be a RACF access in place. But for this table I forgot to get the same. That was the issue.
_________________
Regards,
SMS