View previous topic :: View next topic
|
Author |
Message |
Balasudher
New User
Joined: 27 Oct 2006 Posts: 3
|
|
|
|
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 |
|
|
sbpati
New User
Joined: 11 Oct 2006 Posts: 11
|
|
|
|
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 |
|
|
|