Blank "Timestamp" field shows *****
Moderators: chulett, rschirm, roy
Blank "Timestamp" field shows *****
Hi,
I have a job where I get blank data from the source for a column with "Timestamp" datatype in a seq file. The source is from a server job.
When i view the data in parallel it shows blank columns but when I write the data in a seq file or a dataset.... The data shows as "*******"
Please help me solve this
I have a job where I get blank data from the source for a column with "Timestamp" datatype in a seq file. The source is from a server job.
When i view the data in parallel it shows blank columns but when I write the data in a seq file or a dataset.... The data shows as "*******"
Please help me solve this
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Blank is not a valid timestamp, therefore you can not insert it in a timestamp field.
If you are writing to a text file, you can replace NULL with a Null Field Value, but blank is not the same as NULL; you might need to convert blank to NULL in an upstream stage.
If the text file is fixed width format, the Null Field Value must have the same number of characters as the Field Width. For example, for a timestamp with no fractional seconds, this means 19 characters. All blanks would be OK, so long as there were 19 of them.
If you are writing to a text file, you can replace NULL with a Null Field Value, but blank is not the same as NULL; you might need to convert blank to NULL in an upstream stage.
If the text file is fixed width format, the Null Field Value must have the same number of characters as the Field Width. For example, for a timestamp with no fractional seconds, this means 19 characters. All blanks would be OK, so long as there were 19 of them.
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.
First create a test job that reads your source, changes the datatypes using modify stage and then loads it back to a sequential file stage. If this works out then you can replace the target sequential file stage with the your "rest of the job".
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.