SAP Query Language max retrieve size 512 bytes?

[john_pawski]

Hello,

Does anyone know if there is a 512 byte limit on retrieves from a table when using SAP Query Language? In other words the length of all the fields in the retrieve can't exceed 512 bytes?

Thanks

[john_pawski]

Hello,

Does anyone know if there is a 512 byte limit on retrieves from a table when using SAP Query Language? In other words the length of all the fields in the retrieve can't exceed 512 bytes?

Thanks

[former_member194669]

Hi,

Are you using fm RFC_READ_TABLE to query to SAP table?

a®

[john_pawski]

It is functionality as part of the WebSphere SAP adapter. I believe it uses RFC_READ_Function. Do you know if that has the 512 byte limit?

[john_pawski]

Sorry, I meant the adapter does use RFC_READ_TABLE

[Former Member]

If you mean Open SQL (SAP's version of SQL), then no. There is no limit of 512 bytes. You can retrieve MBs and even GBs of data back from an Open SQL statement.

[john_pawski]

It is functionality as part of the WebSphere SAP adapter. I believe it uses RFC_READ_Function. Do you know if that has the 512 byte limit? This is the length of all fields.

[former_member194669]

Hi,

The RFC_READ_TABLE have a limitation of 512 char length.

a®

[former_member194669]

Hi,

And also you need check this thread

May this will help you out.

a®

[john_pawski]

Link not not show up.

I found out that the adapter uses RFC_TABLE_READ function module. Which I believe does have the 512 byte limitation.

[former_member194669]

Yes.

The RFC have output table length of 512.

a®