DSXchange

Hi there,

How is a column with data type TIMESTAMP in Sybase can be read with Datastage? No matter what type in Datastage table column is used, if it is Bigint, or Binary, or Decimal, it can be got to read. The error is as the following.


Bigint - DSBrowser..SYBASEOC_1: SQL data type 'BigInt' defined on column timestamp is not supported.
DSBrowser..SYBASEOC_1.DSLink1: DSP.Open GCI $DSP.Open error -2.

Binary - DSBrowser..SYBASEOC_1: SQL data type 'Binary' defined on column timestamp is not supported.
DSBrowser..SYBASEOC_1.DSLink1: DSP.Open GCI $DSP.Open error -2.

Bit - DSBrowser..SYBASEOC_1: Sybase data type 'CS_BINARY_TYPE' for column 'timestamp' is not supported
SQL statement: SELECT retlr_loc_id,owner_grp_id,owner_grp_ref_id,owner_grp_ref_effctv_date,owner_grp_ref_exp_date,timestamp FROM dbo.OWNER_GROUP_REFERENCE

DSBrowser..SYBASEOC_1.DSLink1: DSP.Open GCI $DSP.Open error -2.

Char - DSBrowser..SYBASEOC_1: Sybase data type 'CS_BINARY_TYPE' for column 'timestamp' is not supported
SQL statement: SELECT retlr_loc_id,owner_grp_id,owner_grp_ref_id,owner_grp_ref_effctv_date,owner_grp_ref_exp_date,timestamp FROM dbo.OWNER_GROUP_REFERENCE

DSBrowser..SYBASEOC_1.DSLink1: DSP.Open GCI $DSP.Open error -2.

Decimal, Integer, Numeric - DSBrowser..SYBASEOC_1: Sybase data type 'CS_BINARY_TYPE' for column 'timestamp' is not supported
SQL statement: SELECT retlr_loc_id,owner_grp_id,owner_grp_ref_id,owner_grp_ref_effctv_date,owner_grp_ref_exp_date,timestamp FROM dbo.OWNER_GROUP_REFERENCE

DSBrowser..SYBASEOC_1.DSLink1: DSP.Open GCI $DSP.Open error -2.

Thanks,

olgc wrote:Hi there,

How is a column with data type TIMESTAMP in Sybase can be read with Datastage? No matter what type in Datastage table column is used, if it is Bigint, or Binary, or Decimal, it can be got to read. The error is as the following.


Bigint - DSBrowser..SYBASEOC_1: SQL data type 'BigInt' defined on column timestamp is not supported.
DSBrowser..SYBASEOC_1.DSLink1: DSP.Open GCI $DSP.Open error -2.

Binary - DSBrowser..SYBASEOC_1: SQL data type 'Binary' defined on column timestamp is not supported.
DSBrowser..SYBASEOC_1.DSLink1: DSP.Open GCI $DSP.Open error -2.

Bit - DSBrowser..SYBASEOC_1: Sybase data type 'CS_BINARY_TYPE' for column 'timestamp' is not supported
SQL statement: SELECT retlr_loc_id,owner_grp_id,owner_grp_ref_id,owner_grp_ref_effctv_date,owner_grp_ref_exp_date,timestamp FROM dbo.OWNER_GROUP_REFERENCE

DSBrowser..SYBASEOC_1.DSLink1: DSP.Open GCI $DSP.Open error -2.

Char - DSBrowser..SYBASEOC_1: Sybase data type 'CS_BINARY_TYPE' for column 'timestamp' is not supported
SQL statement: SELECT retlr_loc_id,owner_grp_id,owner_grp_ref_id,owner_grp_ref_effctv_date,owner_grp_ref_exp_date,timestamp FROM dbo.OWNER_GROUP_REFERENCE

DSBrowser..SYBASEOC_1.DSLink1: DSP.Open GCI $DSP.Open error -2.

Decimal, Integer, Numeric - DSBrowser..SYBASEOC_1: Sybase data type 'CS_BINARY_TYPE' for column 'timestamp' is not supported
SQL statement: SELECT retlr_loc_id,owner_grp_id,owner_grp_ref_id,owner_grp_ref_effctv_date,owner_grp_ref_exp_date,timestamp FROM dbo.OWNER_GROUP_REFERENCE

DSBrowser..SYBASEOC_1.DSLink1: DSP.Open GCI $DSP.Open error -2.

Thanks,

Read as Char

When read as char, the error is:

Char - DSBrowser..SYBASEOC_1: Sybase data type 'CS_BINARY_TYPE' for column 'timestamp' is not supported
SQL statement: SELECT retlr_loc_id,owner_grp_id,owner_grp_ref_id,owner_grp_ref_effctv_date,owner_grp_ref_exp_date,timestamp FROM dbo.OWNER_GROUP_REFERENCE

DSBrowser..SYBASEOC_1.DSLink1: DSP.Open GCI $DSP.Open error -2.

Already included in the original post.

Thanks,