topic bdc session method in Application Development and Automation Discussions

bdc session method

Former Member — Fri, 28 Apr 2006 06:55:26 GMT

Hi all,

I have a req in bdc, it is to upload data using session method but for every 100 records new session has to be created.

I have 500 records in flat file..my program must develop 5 sessions once executed.Can anybody help me in this.

Regards,

Raghu.

Re: bdc session method

Former Member — Fri, 28 Apr 2006 07:01:07 GMT

Raghu,

When you build your BDCDATA table, in the loop, keep a counter create one BDC session (BDC_OPEN_GROUP / BDC_INSERT / BDC_CLOSE_GROUP) when the counter is 100.

Reset all the variables and repeat the same.

Regards,

Ravi

Note :Please mark the helpful answers

Re: bdc session method

vinod_gunaware2 — Fri, 28 Apr 2006 07:01:44 GMT

U have to use

SUBMIT <rep>|(<field>) [AND RETURN] [<options>].

with background in loop.

regards

vinod

Re: bdc session method

sreekanthgo — Fri, 28 Apr 2006 07:26:30 GMT

Hi Raghu,

You can do this using opening and closing BDC for 5 times.

You cannot open BDC session with out closing the open one.

So make sure that you will close a bdc before opening another one.

Keep a counter and after finishing 100 records use BDC_CLOSE and then call the BDC_OPEN, BDC_INSERT, BDC_CLOSE.

Thanks,

Sreekanth

Re: bdc session method

Former Member — Fri, 28 Apr 2006 07:35:36 GMT

Hi Raghu,

LOOP 500 records.

perfrom bdc_session using sesesion etc..

endloop.

from bdc_session.

open flag check if it is ' ' or 'X'.

if it is space then Open.

BDC_OPEN.

checck counter for 100 if it is not then

BDC_INSERT

increment counter

check counter for 100. if it is 100 then close it and clear the counter, and also openflag.

BDC_CLOSE or else don't close.

endform.

Regards

vijay