| View previous topic :: View next topic |
| Author |
Message |
sasubashri
Beginner
Joined: 20 May 2003
Posts: 15
Topics: 7
|
 Posted: Mon Jun 30, 2003 5:56 am Post subject: SQL Code -927 Language interface problem |
 |
|
Hi,
When I try to call a COBOL-DB2 program with a COBOL program I encounter the following problem:
SQLCODE = -927, ERROR: THE LANGUAGE INTERFACE (LI) WAS CALLED WHEN THE CONNECTING ENVIRONMENT WAS NOT ESTABLISHED. THE PROGRAM SHOULD BE INVOKED UNDER THE DSN COMMAND
Can anyone help me in resolving this problem??
Thanks,
Subashri. |
|
| Back to top |
|
 |
ofer71
Intermediate
Joined: 12 Feb 2003
Posts: 358
Topics: 4
Location: Israel
|
| Posted: Mon Jun 30, 2003 7:47 am Post subject: |
|
|
How did you invoked your program ?
O.
________
ROOR BONGS
Last edited by ofer71 on Thu Mar 17, 2011 10:33 am; edited 1 time in total |
|
| Back to top |
|
|
vp
Beginner
Joined: 30 Jun 2003
Posts: 9
Topics: 0
|
| Posted: Mon Jun 30, 2003 10:56 am Post subject: |
|
|
You need to submit the calling program under DB2:
Most application programs written for the batch environment run under the TSO Terminal Monitor Program (TMP) in background mode. Figure 127 shows the JCL statements you need in order to start such a job.
//jobname JOB USER=MY DB2ID
//GO EXEC PGM=IKJEFT01,DYNAMNBR=20
//STEPLIB DD DSN=prefix.SDSNEXIT,DISP=SHR
// DD DSN=prefix.SDSNLOAD,DISP=SHR
.
.
.
//SYSTSPRT DD SYSOUT=A
//SYSTSIN DD *
DSN SYSTEM (ssid)
RUN PROG (SAMPPGM) -
PLAN (SAMPLAN) -
LIB (SAMPPROJ.SAMPLIB) -
PARMS ('/D01 D02 D03')
END
/*
Figure 127. JCL for running a DB2 application under the TSO terminal
monitor program
*** please note ***
The return code will be for the disposition of the Terminal program IKJEFT01. If you want the application program's rc then you might want to try IKJEFT1B version. |
|
| Back to top |
|
|
coolman
Intermediate
Joined: 03 Jan 2003
Posts: 283
Topics: 27
Location: US
|
| Posted: Wed Jul 02, 2003 3:29 am Post subject: |
|
|
Subasri,
Post your JCL.
All,
BTW, where is kolusu?
Cheers,
Coolman.
________
RA271
Last edited by coolman on Sat Feb 05, 2011 1:25 am; edited 1 time in total |
|
| Back to top |
|
|
sasubashri
Beginner
Joined: 20 May 2003
Posts: 15
Topics: 7
|
| Posted: Wed Jul 02, 2003 4:12 am Post subject: |
|
|
Hi everyone,
I invoked the program using IKJEFT1A and its running fine now.
Thanx a lot for your help. 
_________________
Thanks,
Subashri. |
|
| Back to top |
|
|
Premkumar
Moderator
Joined: 28 Nov 2002
Posts: 77
Topics: 7
Location: Chennai, India
|
| Posted: Wed Jul 02, 2003 5:12 am Post subject: |
|
|
| Kolusu is on vacation in India. He got married on June 15th. Wish you “Happy Married Life”, Mr. and Mrs. Kolusu. |
|
| Back to top |
|
|
Cogito-Ergo-Sum
Advanced
Joined: 15 Dec 2002
Posts: 637
Topics: 43
Location: Bengaluru, INDIA
|
| Posted: Wed Jul 02, 2003 6:37 am Post subject: |
|
|
Kolusu!
Many, many congratulations on entering conjugal life!! My best wishes to you and Mrs. Kolusu!
_________________
ALL opinions are welcome.
Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
