Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Issue in trigger

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

New User


Joined: 10 Jun 2015
Posts: 30
Location: India

PostPosted: Wed Feb 10, 2016 5:41 pm    Post subject: Issue in trigger
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: 70
Location: India

PostPosted: Thu Feb 11, 2016 10:00 am    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Thu Feb 11, 2016 1:56 pm    Post subject: Reply to: Issue in trigger
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: 30
Location: India

PostPosted: Thu Feb 11, 2016 4:56 pm    Post subject:
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    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 DFHRESPONSE returns issue divated CICS 3 Wed Nov 02, 2016 6:32 pm
No new posts Can sending 5 MB data between cobol p... Kevin Vaz CICS 12 Tue Oct 18, 2016 4:50 pm
No new posts REXX Screen not working due to LINKED... sundarkudos CLIST & REXX 1 Mon May 09, 2016 1:44 pm
No new posts Issue in sending zip file as mail att... ajithajt JCL & VSAM 8 Thu Apr 07, 2016 9:11 am
No new posts Include Cond issue vickey_dw DFSORT/ICETOOL 6 Tue Mar 29, 2016 8:51 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us