Setting Date character type to NULL in Row Generator
Moderators: chulett, rschirm, roy
-
tutan4uall
- Participant
- Posts: 1
- Joined: Wed Jul 02, 2008 11:34 am
Setting Date character type to NULL in Row Generator
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:
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.