1. Tobias Roth
  2. PowerBuilder
  3. Friday, 02 February 2018

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 Accepted Answer Pending Moderation
0
Votes
Undo

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
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. Tobias Roth
  2. Friday, 2 February 2018
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. Chris Pollach
  2. Monday, 5 February 2018
There are no comments made yet.
  1. Friday, 2 February 2018
  2. PowerBuilder
  3. # 1
  • Page :
  • 1


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