How to write nulls as nulls
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 59
- Joined: Sat May 29, 2004 12:31 am
- Location: Pune
How to write nulls as nulls
Hi,
I am getting the following warning message in the Job log:
Exporting nullable field without null handling properties
I am just reading a Oracle Table using Oracle Enterprise Stage and writing data into 2 sequential files based on some condition with out any transformations.
The job is as follows:
Oracle Enterprise Stage ---> Transformer --->(condition1) File1
---->(condition2) File2
The Null proterty was set to Yes for the fields which can have NULL value in both the source and Target.
Can any one help me out in resolving this warning issue?
Thanks in Advance.
Vijay
I am getting the following warning message in the Job log:
Exporting nullable field without null handling properties
I am just reading a Oracle Table using Oracle Enterprise Stage and writing data into 2 sequential files based on some condition with out any transformations.
The job is as follows:
Oracle Enterprise Stage ---> Transformer --->(condition1) File1
---->(condition2) File2
The Null proterty was set to Yes for the fields which can have NULL value in both the source and Target.
Can any one help me out in resolving this warning issue?
Thanks in Advance.
Vijay
-
- Participant
- Posts: 59
- Joined: Sat May 29, 2004 12:31 am
- Location: Pune
Thank you for the response.kumar_s wrote:Also check through out the links including transformer.
Turn off RCP.
Try using NullToValue() and set null again for null values.
What is the datatype? ...
RCP property is OFF and through out the job the Nullable property is set to Yes. All the fields are of Varchar Type.
As the amout of data that I am extracting is huge, I don't want to use NullToValue() function. If I use any operators it may slow down the performance.
Why the DS Job is throwing such warning msg when I don't perform any tranformations in my job. Can't we write Null value into a sequential file??
-
- Participant
- Posts: 59
- Joined: Sat May 29, 2004 12:31 am
- Location: Pune
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is no such thing as NULL in a text file - there is only text.
You use the Null Field Value property to specify how you want NULL to be represented when writing to the file. This can be any string you like in a delimited file, but must be of the correct width in a fixed-width format file.
You use the Null Field Value property to specify how you want NULL to be represented when writing to the file. This can be any string you like in a delimited file, but must be of the correct width in a fixed-width format file.
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.
-
- Participant
- Posts: 59
- Joined: Sat May 29, 2004 12:31 am
- Location: Pune
Hi Ray,
In my job I want to extract data from Oracle database using Oracle Enterprise Stage to a Sequential File.
I don't want to replace the NULL values in output file, so I did a direct mapping with out any Null handling or transformations.
But when I run the job the job log shows many warning message.
Is there any way I can avoid these warning messages without doing any transformation for null handling?
Thanks & Regards,
Vijay
In my job I want to extract data from Oracle database using Oracle Enterprise Stage to a Sequential File.
I don't want to replace the NULL values in output file, so I did a direct mapping with out any Null handling or transformations.
But when I run the job the job log shows many warning message.
Is there any way I can avoid these warning messages without doing any transformation for null handling?
Thanks & Regards,
Vijay
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No. The warning messages will always be generated in this case, because you need to be aware of the situation.Vijay Kumar wrote:Is there any way I can avoid these warning messages without doing any transformation for null handling?
Either provide null handling or implement a message handler.
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.