Re: [sqr-users] Is it possible - or advisable - to set a sqlcommit to1?

["Larry Roux" <LRoux@syr.edu>]

What RDBMS are you on?

I have done this in oracle just by having 2 begin-sql statements

begin-sql
  insert into blah
end-sql
begin-sql
  commit
end-sql





******************************
Larry Roux
Syracuse University
lroux@syr.edu
*******************************

>>> Joe_Johnson@adp.com 04/06/04 01:53PM >>>

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


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