topic Re: Update database table in Application Development and Automation Discussions

Update database table

Former Member — Tue, 09 Sep 2008 15:24:30 GMT

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

Re: Update database table

Former Member — Tue, 09 Sep 2008 15:30:22 GMT

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

Re: Update database table

Former Member — Tue, 09 Sep 2008 15:41:47 GMT

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

Re: Update database table

Former Member — Tue, 09 Sep 2008 15:43:35 GMT

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

Re: Update database table

Former Member — Tue, 09 Sep 2008 16:11:03 GMT

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

Re: Update database table

Former Member — Tue, 09 Sep 2008 16:13:06 GMT

This is a custom Z table - correct?

Rob

Re: Update database table

Former Member — Tue, 09 Sep 2008 16:15:25 GMT

Yes, It is a Z custom table.

Regards,

DNP

Re: Update database table

Former Member — Tue, 09 Sep 2008 17:42:38 GMT

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

Regards,

Ram

Re: Update database table

Former Member — Tue, 09 Sep 2008 19:22:51 GMT

finally decide to go with UPDATE statement