You get what Sybase returns back. Try running the same code in isql on the same computer where 24x7 is run and should get the same.
FYI, in 24x7 the max size of varchar datatype values is 32765 bytes.
Also, you might be luckier if you use "Sybase SQL Server 11.x and later" driver or "ODBC" instead of the old
"SYC Sybase System 10/11" which is by the way is not supported anymore.
: Hello,
: we are using 24x7 ver. 3.4.24
: and have jobs running for months without any trouble with Sybase 12.0
: Recently we upgraded Sybase to ver. 12.5.4 and the following DatabaseRetrieve
: statement gives us a problem: DatabaseConnectEx "SYC Sybase System
: 10/11", global.db_server, global.database, global.db_user,
: db_password, true
: ...
: dim test, string
: dim rows, number
: set test, "select
: '1234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456'"
: DatabaseRetrieve( test, rows )
: ....
: DatabaseRetrieve used to work with any length of string returned from select
: in test variable for Sybase 12.0,
: but now it works only when length of returned string is less or equal 255
: chars.
: Could you please advise on this problem.
: Thank you,
: Eugene
|
