JDBC Receiver Doubts

[Former Member]

Hi All,

Please clarify doubts on SAP PI JDBC Receiver adapter.

1) I have to retrieve Lacs of records by sending primary key using proxy.

   ->I am following SQL_QUERY Statement approach is it correct?

   ->When i execute i am getting only 1000 records is there limitation on receiver adapter?

   ->Which approach is best to update fetched records? Normal or SQL_Query Statement.

[former_member207703]

Hi Harish,

Follow this link, http://help.sap.com/saphelp_srm40/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.html .

You have to create one more field in your SQL DB Table, say some flag field. Once that record is selected set Flag as X.

So on base of initial value of Flag you can able to SELECT records and UPDATE flag with X so that PI will not pick up it again.

Hope its a easiest way to select data from DB.

But, actually JDBC Receiver CC use to UPDATE or INSERT data into SQL DB and pulling records from SQL DB is done by JDBC Sender CC only. Still you can able to use JDBC Receiver CC for pulling data from SQL DB, as SAP defined in above link.

Regards,

Anoop Kumar Rai

[Harish]

Hi,

Please refer the below thread

regards,

Harish

[Former Member]

Hi Harish,

Please go through the below post.