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

Issue in trigger


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vickey_dw

New User


Joined: 10 Jun 2015
Posts: 51
Location: India

PostPosted: Wed Feb 10, 2016 5:41 pm
Reply with quote

Hi All

One of my program is inserting records in a table.That inserts statement invokes a trigger.And from this trigger a stored proc is called which is written in cobol.

Now my main program is abending with -723, trigger with -443 and stored proc with -805. I found these details in SQLERRMC.

Please help me resolve this error.
Back to top
View user's profile Send private message
pshongal

New User


Joined: 14 Jun 2012
Posts: 96
Location: India

PostPosted: Thu Feb 11, 2016 10:00 am
Reply with quote

Hello,

Can you please provide abend details with screenshot?

It looks like actual error is -805, make sure you bind your program and move the SP load to respective SP test load library.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Thu Feb 11, 2016 1:56 pm
Reply with quote

Quote:
Can you please provide abend details with screenshot?


do not post screenshots ...
use a plain TEXT cut and paste

wouldn' t it be simpler for the TS to look at the manual
and come back ONLY if something is not clear
Back to top
View user's profile Send private message
vickey_dw

New User


Joined: 10 Jun 2015
Posts: 51
Location: India

PostPosted: Thu Feb 11, 2016 4:56 pm
Reply with quote

I have bind the stored proc in test but still getting the same error.

Also i want to know can stored proc and package of program be kept in different collection id ?

I am using same plan for to bind stored proc(written in cobol) and main program.Packages for them are different.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Issue after ISPF copy to Linklist Lib... TSO/ISPF 1
No new posts Facing ABM3 issue! CICS 3
No new posts Panvalet - 9 Character name - Issue c... CA Products 6
No new posts Issue with EXEC CICS QUERY SECURITY c... CICS 6
Search our Forums:

Back to Top