Setting Date character type to NULL in Row Generator

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
tutan4uall
Participant
Posts: 1
Joined: Wed Jul 02, 2008 11:34 am

Setting Date character type to NULL in Row Generator

Post by tutan4uall »

i have a datastage job ,which consists of a row generator linked to a DB2 Enterprise Stage.I have imported a number of columns from the table definations,out of which one is called START_DATE,another is called END_DATE(both with data type Date).I went to row generator properties,i went to columns,then i went to the option EDIT ROW(by right clicking on the columns)..now i'm not finding any options to set the field to NULL(By any means).....there are options like epoch..etc etc...i cant change the value to NULL,,,please give ur suggestions....wat to do??can i change it at column level at all??or i have to put a transformer in between??
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard. The generator operator can generate a proportion of null or invalid values, so you could try setting that to 100% for the column in question. Otherwise interpose a Transformer stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply