Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved Embedded SQL Select - Stringsize

  1. Issue
0
Votes
Undo
  1. Tobias Roth
    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

  1. Embedded SQL
prerequisites
Error al conectarme el la web
Responses (1)
Chris Pollach @Appeon
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
Tobias Roth
  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
Chris Pollach @Appeon
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.