IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Sqlcode as 00000092P when i try to update a row


IBM Mainframe Forums -> ABENDS & Debugging
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
aavugari mayuri

New User


Joined: 15 Aug 2006
Posts: 10

PostPosted: Wed Sep 20, 2006 10:05 pm
Reply with quote

hi all,
i'm getting sqlcode as 00000092P when i try to update a row in a table
kindly help

Regards
mayuri
Back to top
View user's profile Send private message
PeD

Active User


Joined: 26 Nov 2005
Posts: 459
Location: Belgium

PostPosted: Thu Sep 21, 2006 1:09 am
Reply with quote

You don't display correctly the error SQL code.
As P in hex = D7, your sql code is -927 meaning
Quote:
-927 THE LANGUAGE INTERFACE (LI) WAS CALLED WHEN THE CONNECTING
ENVIRONMENT WAS NOT ESTABLISHED. THE PROGRAM SHOULD BE INVOKED
UNDER THE DSN COMMAND

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.

System Action: The statement cannot be executed.

Programmer Response: In the TSO environment, DB2 application programs should be invoked under the RUN subcommand of the DSN
command processor. In the IMS, CICS or CAF environment check that the application was link-edited with or is dynamically allocating the correct
language interface module. The language interface modules required in each environment are as follows:

 IMS: DFSLI000
 CICS: DSNCLI
 CAF: DSNALI
 TSO: DSNELI

The DYNAM option can result in the incorrect language interface module being loaded at runtime.

SQLSTATE: 51006


Regards
Pierre
Back to top
View user's profile Send private message
aavugari mayuri

New User


Joined: 15 Aug 2006
Posts: 10

PostPosted: Mon Sep 25, 2006 11:25 am
Reply with quote

hey thanks pierre..
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> ABENDS & Debugging

 


Similar Topics
Topic Forum Replies
No new posts Read a flat file and update DB2 table JCL & VSAM 2
No new posts how to update an ISR appl var from an... TSO/ISPF 8
No new posts SQLCODE = -122 while using the scalar... DB2 4
No new posts SQLCODE = -16002 when using XMLEXISTS DB2 1
No new posts DB2 SQL query to read and update data... DB2 12
Search our Forums:

Back to Top