1. Tobias Roth
  2. PowerBuilder
  3. Friday, 2 February 2018 12:47 PM UTC

Hi,

is there an option to modify the maximal string size that can be selected with embedded SQL Select?
At the moment there is a limit of about 32000.

This is my workaround at the moment (dw_syntax can be larger than 32k):

selectblob dwsyntax into :lb_dwsyntax from sp....() using sqlca;
ls_dwsyntax = string(lb_dwsyntax,EncodingAnsi!)

This dont't work with more that 32k size, but would be the better solution:
select dwsyntax into :ls_dwsyntaxfrom sp....() using sqlca;

Thanks

Regards Tobi

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 2 February 2018 14:05 PM UTC
  2. PowerBuilder
  3. # 1

Hi Tobias;

   Try adding this to the DBParm field in your App's  Transaction Object before you connect to the DB, for example ...

SQLCA.DBParm =" PBMaxTextSize='100000' "

HTH

Regards ... Chris

Comment
  1. Tobias Roth
  2. Friday, 2 February 2018 15:45 PM UTC
Hi Chris,



we are using SQL Anywhere as DBMS.

I read the Help for PBMaxTextSize. The Connection Option is for "SNC SQL Native Client for Microsoft SQL Server".



Is there a solution for SAP SQL Anywhere too?



Thanks



Regards Tobi

  1. Helpful
  1. Chris Pollach @Appeon
  2. Monday, 5 February 2018 14:43 PM UTC
Hi Tobias;



  I cannot be sure, bu I seem to remember that we needed to add this setting to PB's ODBC INI control file. I the current case, PBODB170.ini in the SQL Anywhere section.



Regards ... Chris



 

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.