Handling nulls for Timestamp, date in Schema file

[dsdsds4ever]

Hi All,

I am using schema file concept to extract data from .txt file to dataset then load into Table.

Actually, we need to load 50 tables from 50 files..that's why We are using Schema file concept with Single extract and single load job.

I am facing the problem with handling nulls for Timestamp, date in Schema file only. not in Datastage transformer or NulltoValues..etc..!!

Please let me know How can we handle nulls for those two datatypes and default some values when null come in those fields..!!

My schema file:

record { delim='#', final_delim=end, record_delim_string="\n", date_format='%yyyy-%mm-%dd', quote=none}
( REQ_ID: int64;
REQ_SUBM_TS: nullable TIMESTAMP {null_field='1900-01-01 00:00:00'};
)

Please help on this asap..!

Best Regards,
Williams
DataStage Developer,
IBM.

[chulett]

Welcome aboard.

Next time please use the Post new topic link when you have a problem rather than replying to some random post. I've split your issue out to your own post this time but had no idea what your particulars are so guessed Version 8 and a UNIX server. Please let us know if either of those are incorrect.

And for the record, this is an all volunteer peer-to-peer support forum where people help when and if they can. There is no "ASAP"... or you might say that our definition may not quite match up with yours. Please keep that in mind.

You'll also find that most questions have been asked and answered here by now, usually more than once. The weapon of choice there is the Search link at the top of the page, specifically the Exact search. Always a good idea to see if that turns up anything before posting.

For example, found this with a very quick search: viewtopic.php?t=132279