DSXchange

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??

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.