Skip to Content
0

DBTextLimit doesn't seem to be handled correctly in Sybase 15.7 on Linux

Dec 13, 2016 at 04:59 PM

98

avatar image

Hello,

I have an issue with retrieving long text fields from Sybase 15.7 sp136 running on Linux. Exactly the same client app works fine with Sybase 15.5 on AIX and Sybase 16.0 on Windows Server 2012. Connection parameters and drivers are identical too (Open Client 12.5, SYC Sybase System 10/11).

I have DBTextLimit set to '600000' in the connection params. I confirmed the parameter takes effect, if it's set to something small (I can see the text being truncated). However, when it's set to a large number, like 600000, the text is also truncated.

The relevant part of the client powerbuilder code can be found below (see the comment in captials).

Essentially len(string(lds_reportDetails.Object.ht_report_format_text[1]) does not show the actual length of the text field.

My question is, is there any connection parameter, OS parameter or anything else, which could lead to this truncation? Is there any lilmit on DBTextLimit values in that particular version of Sybase on that OS? We're literally running out of ideas.

retRes = lds_reportModes.Retrieve(lds_reportDetails.Object.ht_report_reportid[1])

if retRes < 0 then

sError = "Retrieve Error while getting report modes" + string(myTrans.SQLDBCode) + ": " + myTrans.SQLErrText

this.logmessage(2, "CreateReport", sError) resetReport()

return false

else

this.logmessage(1, "CreateReport", "retrieved " + string(retRes) + " report modes")

end if

BLOB bformat

int rep_id

if len(string(lds_reportDetails.Object.ht_report_format_text[1])) > 32000 then

// WE DON'T GO HERE, EVEN THOUGH THE TEXT LEN IS WELL OVER 32000

this.logmessage(1, "CreateReport", "Format string length: " + string(len(string(lds_reportDetails.Object.ht_report_format_text[1]))) )

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Luke Grzela Dec 13, 2016 at 05:15 PM
0

I wonder if it could be caused by textsize being 32K. Would it take precedence over DBTextLimit?

It is 32K in Sybase 16.0 though and it doesn't seem to take precedence.

Share
10 |10000 characters needed characters left characters exceeded
Chris Pollach Dec 16, 2016 at 04:33 PM
0

Hi Luke;

Try using the "ASE" instead of SYC and set your release number for 15.5 & higher in your DBParm (

ie: SQLCA.DBParm = "Release='15.5'" ) and see if that makes a difference.

Regards ... Chris

Share
10 |10000 characters needed characters left characters exceeded