namitjai
New User
Joined: 12 Feb 2008 Posts: 41 Location: Bangalore
|
|
|
|
Hi ,
I am calling a sql stored procedure inside my cobol function,but I am getting an error code of -927 at the place where I am calling my Stored Procedure. Please help me out as to how to solve this issue. Giveb below are the Link edit step of the jcl used to compile Stored procedure as well as Cobol functions:
Stored procedure:
//PROCESS EXEC DSNHSQL,MEM=TESTSP,
//* COND=(4,LT),
// PARM.PC='HOST(SQL),SOURCE,XREF,MAR(1,80),STDSQL(NO)',
// PARM.PCC='HOST(C),SOURCE,XREF,MAR(1,80),STDSQL(NO)',
// PARM.C='SOURCE LIST MAR(1,80) NOSEQ LO RENT',
// PARM.LKED='AMODE=31,RMODE=ANY,MAP,RENT'
//PC.SYSUT1 DD DSN=&&SPDML,DISP=(,PASS),
// UNIT=SYSDA,SPACE=(TRK,1),
// DCB=(RECFM=FB,LRECL=80)
//PC.SYSIN DD DISP=SHR,DSN=SECURENT.SP.SRCELIB(&MEM.)
//PC.SYSLIB DD DUMMY
//PCC.DBRMLIB DD DISP=SHR,DSN=SECURENT.DBRMLIB(&MEM.)
//PCC.SYSLIB DD DUMMY
//LKED.SYSLMOD DD DSN=SECURENT.SP.LOADLIB.FINAL(&MEM.),
//LKED.SYSIN DD *
INCLUDE SYSLIB(DSNRLI)
NAME TESTSP(R)
/*
//*
//*
Function:
//LKED EXEC PGM=IEWL,
// COND=((8,LE,COB),(8,LE,PC)),
// PARM='XREF'
//SYSLIB DD DSN=CEE.SCEELKED,DISP=SHR
// DD DSN=CEE.SCEERUN,DISP=SHR
// DD DSN=DSN810.SDSNLOAD,DISP=SHR
//SYSLIN DD DISP=(OLD,DELETE),
// DSN=&&LOADTMP
//SYSLMOD DD DISP=SHR,
// DSN=SECURENT.SP.LOADLIB.FINAL(TESTPROC)
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSUT1 DD SPACE=(1024,(50,50)),
// UNIT=SYSDA
//*
pLEASE LET ME KNOW WHAT CHANGES ARE REQUIRED. |
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Look here:
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnmc0f7/2.1.7.332?
Among other info that link contains:
Quote: |
Explanation: In the TSO environment, the user has attempted to execute an application program without first establishing the correct execution environment by issuing the DSN command. In the IMS, CICS, or call attachment facility (CAF) environment, the user has attempted to execute an application program that is not using the correct language interface module. |
Suggest you work with your dba or other system support people to resolve how to launch your code. |
|