|
View previous topic :: View next topic
|
| Author |
Message |
ykishore
New User
Joined: 12 Aug 2005
Posts: 53
Location: USA
|
|
|
|
Hi
I'm getting following abend when im executing cobol-db2 program.
IDI0089I Subsystem IDISDB2P RC=C, Rsn=40000004 ODBC DLL function
DSNAOCLI not found..Subsystem IDIS subtask termination rc=C 40000004.
IDI0082E DB2 Call Level Interface error: SQLAllocConnect SqlError
sqlrc=-1.{DB2 FOR OS/390}{ODBC DRIVER} SQLSTATE=58004
ERRLOC=2:170:10. CAF "OPEN" failed using DB2 system:DB2M and
Please advise me what could be the problem. |
|
| Back to top |
|
 |
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL
|
|
|
|
And what is the SQLCODE you received.
Regards,
Priyesh. |
|
| Back to top |
|
|
ykishore
New User
Joined: 12 Aug 2005
Posts: 53
Location: USA
|
|
|
|
Hi
Actually i didnt see any SQL Code But status is job cancelled. Please advise me ... |
|
| Back to top |
|
|
small_world
New User
Joined: 22 Jul 2005
Posts: 24
Location: pune
|
|
|
|
error message SQLSTATE=58004 when performing update and delete operations when the index is created on columns
If an index is created on a column position that exceeds 256, data corruption may occur or SQLSTATE 58004 will be returned. This fix also prevents creating a table with more than 256 columns.
58004 when trying to access a database that is stored on an external media (for example, SD Card, CompactFlash Card, and IBM Microdrive) on a PalmOS device.
SQLState 58004 when joining two tables with a join condition that involves VARCHAR colums containing empty strings (when an index is being used for fetching data). |
|
| Back to top |
|
|
ykishore
New User
Joined: 12 Aug 2005
Posts: 53
Location: USA
|
|
|
|
Hi
Actually, I have a COBOL-DB2 program. when i tried to execute that, it is going to loop. So can you guys let me know causes for that? My program is simply selecting the data from DB2 table using Cursor. Please let me know the causes... |
|
| Back to top |
|
|
|
|
