Char data type compatibility with DataSets.
Posted: Thu Feb 01, 2007 10:11 pm
I have flat file (sequential file), having one column containing date values in AIX unix environment.
Since its format is fixed as dd-mm-yyyy, I can suitably define char(10) data type for it. When I go for View data for that stage, it is displaying data properly.
If I try to load the same data in DataSet through transformer in between, the job is not working. DataSet also has data type as char(10).
If I change this Data Type to Varchar, all works as expected. Is there any restriction in using char datatype with datasets?
Since its format is fixed as dd-mm-yyyy, I can suitably define char(10) data type for it. When I go for View data for that stage, it is displaying data properly.
If I try to load the same data in DataSet through transformer in between, the job is not working. DataSet also has data type as char(10).
If I change this Data Type to Varchar, all works as expected. Is there any restriction in using char datatype with datasets?