Reading VARGRAPHIC data type in source table/View.
Posted: Mon May 30, 2011 11:44 am
Hi,
I am trying to read data from XMETA of DataStage.The XMETA table/view has VARGRAPHIC as data type.
As DataStage does not have VARGRAPHIC as the datatype, i used NChar and other datatypes in db2 connector stage, i am getting the following error:
ERROR during execution of DB2-CLI requests: SQL_ERROR; SQLSTATE = HY004; NativeErrorCode = -99999; Message = [IBM][CLI Driver] CLI0123E SQL data type out of range. SQLSTATE=HY00.
I tried using Type casting i.e. cast (column name as Varchar(255)) in select query. This works fine.
I also searched through forums but could not get an answer for the following questions:
1) Doing Type Casting will affect the performance.Is there any other way to read data from data type of VARGRAPHIC
2) When i do type casting i.e. cast (column name as Varchar(lenght)). What is the length i need to keep here. Does it needs to be same length as the VARGRAPHIC column or more or less than that.
Appreciate reply.
I am trying to read data from XMETA of DataStage.The XMETA table/view has VARGRAPHIC as data type.
As DataStage does not have VARGRAPHIC as the datatype, i used NChar and other datatypes in db2 connector stage, i am getting the following error:
ERROR during execution of DB2-CLI requests: SQL_ERROR; SQLSTATE = HY004; NativeErrorCode = -99999; Message = [IBM][CLI Driver] CLI0123E SQL data type out of range. SQLSTATE=HY00.
I tried using Type casting i.e. cast (column name as Varchar(255)) in select query. This works fine.
I also searched through forums but could not get an answer for the following questions:
1) Doing Type Casting will affect the performance.Is there any other way to read data from data type of VARGRAPHIC
2) When i do type casting i.e. cast (column name as Varchar(lenght)). What is the length i need to keep here. Does it needs to be same length as the VARGRAPHIC column or more or less than that.
Appreciate reply.