[sqr-users] Is it possible - or advisable - to set a sql commit to1?

[Joe_Johnson@adp.com]

Greetings,

We have an interface that inserts rows of data into PS_JOB.

We have been asked to change the logic so when an insert error occurs, the rest 
of the input file data can be inserted rather than
have the process stop with the insert error.

I'm thinking the only way to do this is to commit the insert after each row.

1)  Can this be done?  I am using begin-sql for the insert statement.

2)  What are the risks with this approach, besides, large overhead as each row 
is committed?

Thanks,

Joe Johnson
Programmer Analyst
ADP ESG - Technical Services Group





_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users