Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DB2 CICS -923 SQLCODE Problem

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Manshadi

New User


Joined: 31 Aug 2005
Posts: 82

PostPosted: Tue Feb 23, 2010 8:47 pm    Post subject: DB2 CICS -923 SQLCODE Problem
Reply with quote

Hi,

Please help me about the following message:

Code:
 TRANSACTION: BTAC PROGRAM: SY0181   TASK: 0000151 APPLID: CICSU3A1 DISPLAY:  00
  STATUS:  COMMAND EXECUTION COMPLETE                                           
  CALL TO RESOURCE MANAGER DSNCSQL                                             
  EXEC SQL OPEN                              P.AUTH=CICSU3A1, S.AUTH=           
  PLAN=CEPL,     DBRM=DBIOBTAC, STMT=00599, SECT=00002                         
  SQL COMMUNICATION AREA:                                                       
   SQLCABC      = 136                                            AT X'1892C738'
   SQLCODE      =   -923                                         AT X'1892C73C'
   SQLERRML     = 070                                            AT X'1892C740'
   SQLERRMC     = ' ACCESS,00E30301,00000800,CEPL           '    AT X'1892C742'
   SQLERRP      = 'DSNAET03'                                     AT X'1892C788'
   SQLERRD(1-6) =  000,  000, 00000, 0000000000, 00000,  000     AT X'1892C790'
   SQLWARN(0-A) = '_ _ _ _ _ _ _ _ _ _ _'                        AT X'1892C7A8'
   SQLSTATE     = 57015                                          AT X'1892C7B3'
                                                                               
                                                                               
                      LINE:UNKNOWN        EIBFN=X'0612'                         



Many thanks
Manshadi
Back to top
View user's profile Send private message

Manshadi

New User


Joined: 31 Aug 2005
Posts: 82

PostPosted: Tue Feb 23, 2010 8:49 pm    Post subject: DB2 CICS -923 SQLCODE Problem
Reply with quote

Hi,

Do you have any idea about the following message:
Code:
 TRANSACTION: BTAC PROGRAM: SY0181   TASK: 0000151 APPLID: CICSU3A1 DISPLAY:  00
  STATUS:  COMMAND EXECUTION COMPLETE                                           
  CALL TO RESOURCE MANAGER DSNCSQL                                             
  EXEC SQL OPEN                              P.AUTH=CICSU3A1, S.AUTH=           
  PLAN=CEPL,     DBRM=DBIOBTAC, STMT=00599, SECT=00002                         
  SQL COMMUNICATION AREA:                                                       
   SQLCABC      = 136                                            AT X'1892C738'
   SQLCODE      =   -923                                         AT X'1892C73C'
   SQLERRML     = 070                                            AT X'1892C740'
   SQLERRMC     = ' ACCESS,00E30301,00000800,CEPL           '    AT X'1892C742'
   SQLERRP      = 'DSNAET03'                                     AT X'1892C788'
   SQLERRD(1-6) =  000,  000, 00000, 0000000000, 00000,  000     AT X'1892C790'
   SQLWARN(0-A) = '_ _ _ _ _ _ _ _ _ _ _'                        AT X'1892C7A8'
   SQLSTATE     = 57015                                          AT X'1892C7B3'
                                                                               
                                                                               
                      LINE:UNKNOWN        EIBFN=X'0612'                         


Best regards
Manshadi
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2504
Location: Atlanta, Georgia, USA

PostPosted: Tue Feb 23, 2010 8:59 pm    Post subject: Reply to: DB2 CICS -923 SQLCODE Problem
Reply with quote

Have you made any attempt to research these errors yourself icon_question.gif

The last EIB Function (EIBFN) of X'0612' equates to an 'ENDBR'.

Bill
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Feb 23, 2010 10:04 pm    Post subject:
Reply with quote

open DB2 manual : Messages & codes

search -923

search 00E30301
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How do you attach a DB2 plan to a CIC... John Poulakos DB2 0 Wed Apr 18, 2018 1:49 am
No new posts Call COBOL or PLI with a click from w... vaibhav gs All Other Mainframe Topics 1 Mon Apr 16, 2018 7:29 pm
No new posts How do I define a DB2 plan for a web ... John Poulakos CICS 4 Sat Apr 14, 2018 1:58 am
No new posts VSAM file NOT Found error while proce... SumaReva CICS 5 Wed Apr 11, 2018 9:54 pm
No new posts Limit in Length for a CICS START seahawk789 CICS 6 Mon Apr 02, 2018 8:34 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us