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

if not abend while inserting records in a table


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

New User


Joined: 27 Oct 2006
Posts: 3

PostPosted: Mon Oct 30, 2006 9:27 am
Reply with quote

Hi,
Could you tell while inserting records in a table,
for successful ececution whts the code and steps we need to follow
Back to top
View user's profile Send private message
sbpati

New User


Joined: 11 Oct 2006
Posts: 11

PostPosted: Mon Oct 30, 2006 4:49 pm
Reply with quote

Hi,

After the SQL insert statement according to your requirement you can proceed further with the following statements.Hope this fulfills your requirement.

EVALUATE SQLOCODE
WHEN 0
SET ROW-INSERTED TO TRUE
INSERT SOME PROCESS HERE.......
WHEN -803(DUPLICATES)
SET ROW-NOT-INSERTED TO TRUE
INSERT SOME PROCESS HERE..........
WHEN OTHER
PERFORM DB2-ERROR PROCESS....
END-EVALUATE
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 Load new table with Old unload - DB2 DB2 6
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts ISAM and abend S03B JCL & VSAM 9
No new posts Multiple table unload using INZUTILB DB2 2
Search our Forums:

Back to Top