09-09-2008 4:24 PM
I have 1 million records in application server and I want to update database table from that.
Is UPDATE statement the best technique to do it.
Just wanted to know if there is any other better tehcniques.
Also i want to write the errors to job log. How can we do that?
Regards,
DNP
09-09-2008 4:30 PM
Using dataset concept, read the data and use UPDATE command to insert the data to table....If any error occurs move the record to error message internal table for display purpose...
UPDATE means, will insert if no record found and if record found will update the entry...
09-09-2008 4:30 PM
Using dataset concept, read the data and use UPDATE command to insert the data to table....If any error occurs move the record to error message internal table for display purpose...
UPDATE means, will insert if no record found and if record found will update the entry...
09-09-2008 4:41 PM
If they are all new records or all changes, it would be best to use INSERT or UPDATE. You will also want to do mass inserts/changes using an internal table. Since you have so many records, you will probably have to do this in chunks in order to avoid dumping on the rollback area.
Rob
09-09-2008 4:43 PM
09-09-2008 5:11 PM
Using LSMW is very slow. It's taking long time. Also, I have to perform few checks(of duplicate entry) along with Update.
Regards,
DNP
09-09-2008 5:13 PM
09-09-2008 5:15 PM
09-09-2008 6:42 PM
Data all ready in Application server mean better way using DATASET concept.
Regards,
Ram
09-09-2008 8:22 PM