JDBC ADAPTER

[Former Member]

Hi Team,

I have working on Jdbc to idoc interface.

i have 3,00,000 records in DB.if i use top command in jdbc sender cc for every 30,000 records.

should pi generates 10 idocs in target sap?

Regards

Srinivas

[rajasekhar_reddy14 · Accepted solution]

Your requirement not clear,

If you want to create single IDoc for multiple JDBC records then you have to build a maping logic in mapping.

change IDoc occurance to 1 to undbounded.

Regards,

Raj

[Former Member · Accepted solution]

Hi Raja Sekhar,

Thanks for your quick response.

in DB 3.00,000 records are there.

if we send all 3,00,000 records send once that would be load on DB.

Thats why i am using top command we can send 30.000 record once.

Regards

Srinivas

[rajasekhar_reddy14 · Accepted solution]

Hi,

That is one approach you can limit number number of records in top command.it works (frame correct query).

Regards,

Raj

[Former Member · Accepted solution]

Hi Raja sekhar,

how many ways we can achieve this requirement?.

could you please tell me

how can i use top command ?

if we use top command how many idocs generated in sap side?

Regards

Srinivas

[rajasekhar_reddy14 · Accepted solution]

There was one blog written on same concept in sdn.sap.com(not sure about link) search you would find it.

other way is request data base team to create function(cursor) then call that function this is also works.

[former_member184681 · Accepted solution]

Hi Srinivas,

The easiest way to limit the number of records selected is simply to use "LIMIT 30000" at the end of the SELECT statement, but this only works with certain DBMS. Refer here for details:

http://en.wikipedia.org/wiki/Select_(SQL)

Hope this helps,

Greg

[Former Member]

chk this similar discussion:

[baskar_gopalakrishnan2]

>i have 3,00,000 records in DB.if i use top command in jdbc sender cc for every 30,000 records.

should pi generates 10 idocs in target sap?

Yes. That is possible. In the sender JDBC communication channel specify the select statement something similar below...

Select * from tablename where rownum < 30000

Followed by

Update statement should update the flag that set value = true for the read 30000 records.

This will yield one message with 30,000 records.

Next time the same select query and update statment reads the second set of 30,000 records and update the flag for the read records.

Here is the link.

Hope that helps.

[iaki_vila]

Hi,

This thread deals with a similar problem

Regards.