Update database table

[Former Member]

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

[Former Member]

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...

[Former Member]

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

[Former Member]

Why dont you try with LSMW ? Instead of using UPDATE method.

[Former Member]

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

[Former Member]

This is a custom Z table - correct?

Rob

[Former Member]

Yes, It is a Z custom table.

Regards,

DNP

[Former Member]

Data all ready in Application server mean better way using DATASET concept.

Regards,

Ram

[Former Member]

finally decide to go with UPDATE statement