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,
How is a TIMESTAMP column read from Sybase?
Moderators: chulett, rschirm, roy
Re: How is a TIMESTAMP column read from Sybase?
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,
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,