topic Re: suggestion about modify database table remotely ? in Application Development and Automation Discussions

suggestion about modify database table remotely ?

Former Member — Wed, 18 Jul 2007 01:19:19 GMT

hi,

i want to modify database table which is in another R/3 system through RFC, and i need some suggestion about parameters . Because there're many entries to be inserted, so i'm afraid that putting all the entries to an internal table and pass the table will cause memory problem. and if i pass the entry one by one, maybe it'll cost much time in connection.

any suggestion about this ?? also modify data through other ways would be ok, but one note is that i have no right to access DBMS.

thank you!

Re: suggestion about modify database table remotely ?

RichHeilman — Wed, 18 Jul 2007 01:21:37 GMT

How many records are we talking about?

Regards,

RIch Heilman

Re: suggestion about modify database table remotely ?

Former Member — Wed, 18 Jul 2007 01:44:08 GMT

Hi Rich,

really honor to see your reply !! i'm your fans:)

it'a about 30000 records and each line with about 200 character.

thank you!

Re: suggestion about modify database table remotely ?

Former Member — Wed, 18 Jul 2007 03:13:41 GMT

Hi Zhang,

In such case try to reduce the no. of entries lets say pass max 5000 entries in each call of RFC.

Call the RFC in a LOOP.

Regards,

Atish