Upto how many characters will accept in SELECT query SENDER JDBC (PI 7.1)

[Former Member]

Hi Friends,

I have to use Sender JDBC adapter in SAP PI 7.1, I need to use SELECT query only.

I have a SELECT query is around 2 pages. Is this will accepet in SENDER JDBC in PI 7.1

Thanks in advance.

[Former Member · Accepted solution]

Hi,

I don't think so there is any limit on the number of characters in the SELECT query in channel.

You can paste your query there and check for any issue.

-Supriya.

[former_member472138 · Accepted solution]

Hi Challarapu,

You can check it out and if it is not accepted by the same then you need to check the maximal length @ DB settings or JDBC Settings whether it is limited. If not then you are allowed.

Hope this helps.

Regards

Pothana

[Former Member · Accepted solution]

Thanks Friends.

[Former Member]

Hi

have a look to:

[PI/XI Sender JDBC Select query and Update Query to limit our records to be picked up by XI from Database to avoid Huge Message processing failed.|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/18652] [original link is broken] [original link is broken] [original link is broken];

Regards

Francesco

[Former Member]

HI friends, any updates oh my question