|
View previous topic :: View next topic
|
| Author |
Message |
LearningDb2
New User
Joined: 19 Jun 2009
Posts: 40
Location: India
|
|
|
|
Hi..
I am working on DB2 v9.1 z/os
While connecting to DB2 from my Rexx application i am getting the sqlcode -981.
The reason code being 00C12219.
In Manuals
| Quote: |
00C12219
Explanation: The application program issued an SQL
or IFI function request without completing CREATE
THREAD processing. SQL or IFI requests cannot be
issued until CREATE THREAD processing is complete.
User response: You can continue processing with a
corrected request.
|
The Rexx simply fetches data from sysibm.syspackdep.
Do in need to explicitly call DSNRLI in my application?
Please suggest what exactly should be my approach regarding this.
Thanks in advance......
Regards |
|
| Back to top |
|
 |
don.leahy
Active Member
Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada
|
|
|
|
| Does your program issue a DSNREXX "CONNECT" __ssid command? If so, what is the RC? |
|
| Back to top |
|
|
LearningDb2
New User
Joined: 19 Jun 2009
Posts: 40
Location: India
|
|
|
|
Hi don.leahy,
Thx for your reply...it just ticked into my mind that i am not closing the connection..hence i added..
| Quote: |
S_RC=RXSUBCOM('DELETE','DSNREXX','DSNREXX')
|
n its working fine..
Thanks again
Regards |
|
| Back to top |
|
|
|
|
