Sequential File Import - Doesnt like NULL Integer and Dates
Posted: Mon Nov 03, 2008 6:15 am
Hi all,
General Question here, something basic or obvious I'm not doing.
Situation.
I Have server jobs which extract from source to Sequential files.
The data types vary - Varchars, Integers, Dates.
I then use the Sequential file in Px stage to load into Target schema.
Problem :
When I try and view the data file from the Sequential File stage in Px It fails as it cannot import nulls ???
So there would be some columns which do not contain any data in the source. These would apear as <DATA> ,,,, in the csv file. Would seem common place, no integer or date values. ( i,e End dates )
I changed the DATE dataypes to VARCHAR as that will be fine to load into the DB2 DATE field as long the format is correct. But still need to be able to handle integers ?
But when these columns do not have any values the Sequential file stage doesn't allow it to load.
Is there some general rules that I've missed here ?
Thanks
Nick
General Question here, something basic or obvious I'm not doing.
Situation.
I Have server jobs which extract from source to Sequential files.
The data types vary - Varchars, Integers, Dates.
I then use the Sequential file in Px stage to load into Target schema.
Problem :
When I try and view the data file from the Sequential File stage in Px It fails as it cannot import nulls ???
So there would be some columns which do not contain any data in the source. These would apear as <DATA> ,,,, in the csv file. Would seem common place, no integer or date values. ( i,e End dates )
I changed the DATE dataypes to VARCHAR as that will be fine to load into the DB2 DATE field as long the format is correct. But still need to be able to handle integers ?
But when these columns do not have any values the Sequential file stage doesn't allow it to load.
Is there some general rules that I've missed here ?
Thanks
Nick