topic Re: SAP Query Language max retrieve size 512 bytes? in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201663#M763097 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The RFC_READ_TABLE have a limitation of 512 char length.</P><P></P><P>a®</P><P></P></BODY></HTML> Mon, 10 Dec 2007 19:26:58 GMT former_member194669 2007-12-10T19:26:58Z SAP Query Language max retrieve size 512 bytes? https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201658#M763092 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>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?</P><P></P><P>Thanks</P></BODY></HTML> Mon, 10 Dec 2007 17:45:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201658#M763092 john_pawski 2007-12-10T17:45:41Z Re: SAP Query Language max retrieve size 512 bytes? https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201659#M763093 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Are you using fm RFC_READ_TABLE to query to SAP table?</P><P></P><P>a®</P><P></P></BODY></HTML> Mon, 10 Dec 2007 17:48:03 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201659#M763093 former_member194669 2007-12-10T17:48:03Z Re: SAP Query Language max retrieve size 512 bytes? https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201660#M763094 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Mon, 10 Dec 2007 18:51:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201660#M763094 Former Member 2007-12-10T18:51:07Z Re: SAP Query Language max retrieve size 512 bytes? https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201661#M763095 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Mon, 10 Dec 2007 19:24:35 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201661#M763095 john_pawski 2007-12-10T19:24:35Z Re: SAP Query Language max retrieve size 512 bytes? https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201662#M763096 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Mon, 10 Dec 2007 19:25:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201662#M763096 john_pawski 2007-12-10T19:25:14Z Re: SAP Query Language max retrieve size 512 bytes? https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201663#M763097 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The RFC_READ_TABLE have a limitation of 512 char length.</P><P></P><P>a®</P><P></P></BODY></HTML> Mon, 10 Dec 2007 19:26:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201663#M763097 former_member194669 2007-12-10T19:26:58Z Re: SAP Query Language max retrieve size 512 bytes? https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201664#M763098 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>And also you need check this thread </P><P></P><P></P><P></P><P>May this will help you out.</P><P></P><P>a®</P><P></P></BODY></HTML> Mon, 10 Dec 2007 19:29:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201664#M763098 former_member194669 2007-12-10T19:29:17Z Re: SAP Query Language max retrieve size 512 bytes? https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201665#M763099 <HTML><HEAD></HEAD><BODY><P>Sorry, I meant the adapter does use RFC_READ_TABLE</P></BODY></HTML> Mon, 10 Dec 2007 20:19:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201665#M763099 john_pawski 2007-12-10T20:19:23Z Re: SAP Query Language max retrieve size 512 bytes? https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201666#M763100 <HTML><HEAD></HEAD><BODY><P>Link not not show up.</P><P></P><P>I found out that the adapter uses RFC_TABLE_READ function module. Which I believe does have the 512 byte limitation.</P></BODY></HTML> Mon, 10 Dec 2007 20:30:16 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201666#M763100 john_pawski 2007-12-10T20:30:16Z Re: SAP Query Language max retrieve size 512 bytes? https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201667#M763101 <HTML><HEAD></HEAD><BODY><P>Yes.</P><P></P><P>The RFC have output table length of 512.</P><P></P><P>a®</P><P></P></BODY></HTML> Mon, 10 Dec 2007 20:39:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query-language-max-retrieve-size-512-bytes/m-p/3201667#M763101 former_member194669 2007-12-10T20:39:41Z