topic Re: SAS Sybase data pull blank value issue in SAS Programming

SAS Sybase data pull blank value issue

samd123 — Thu, 12 Oct 2023 19:53:34 GMT

Hello, We are using SAS 9.4 M7 on rhel 7, grid environment.

When running below proc sql to pull data from Sybase db, var-1 and var-2 comes out with blank value. When look at variable details in EG table, both var-1 and var-2 has type: Character, length: 1.

code

proc sql outobs=100;
connect to odbc as myconn(datasrc='XYZ' user='user1' password='encryoted-pwd');
create table test1 as
select * from connection to myconn
(
select
var-1
, var-2
, var-3
, var-4
, var-5
from sybase-db-tbl
);

disconnect from myconn;
quit;

odbc details

[XYZ]
Description=Sybase ODBC Data Source
Driver=/path-to-lib/lib/libsybdrvodb.so
#Driver=/path-to-lib/lib/libsybdrvodb-sqllen4.so
DriverUnicodeType=1
Server=servername.com
Port=12345
Database=db_1
UseCursor=1
EnableProcessLicensing=1

sasenv_local

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/path-to-syb/syb/DataAccess64/ODBC/lib
export LD_LIBRARY_PATH
DRIVER_LIBRARY_PATH=/path-to-syb/syb/DataAccess64/ODBC/lib
export DRIVER_LIBRARY_PATH
EASYSOFT_UNICODE=YES
export EASYSOFT_UNICODE

However, when data pull from different tool, var-1 and var-2 has values like below (example).

var-1

ABC

DEF

GHI

JKL

var-2

DDF

FGH

JKL

175

Re: SAS Sybase data pull blank value issue

SASKiwi — Thu, 12 Oct 2023 20:22:05 GMT

What about the other columns? Do they populate OK? If so what type and length are they?

Re: SAS Sybase data pull blank value issue

samd123 — Thu, 12 Oct 2023 20:32:22 GMT

yes, other columns in EG populating fine.

example

var-3 is type: numeric, length:8

var-4 is type:date, length:8

Its a character data not coming out fine.

Re: SAS Sybase data pull blank value issue

samd123 — Thu, 12 Oct 2023 20:41:00 GMT

Also, this is happening after we have upgraded Sybase DB client on server side to 'Sybase_16.0_SP04'. Assuming it has to do something with it. Possibly, we can plug-in some additional parameters in odbc.ini file for that specific connection to treat character type of data differently/correctly.

Thank you.

Re: SAS Sybase data pull blank value issue

SASKiwi — Thu, 12 Oct 2023 20:51:59 GMT

So was it working OK before upgrading your Sybase DB client? I'd suggest you open a Tech Support track so they investigate more fully what has happened here.