I have a record in which some of the columns are nulls. When i export this record to a sequential file the message is "exporting nullable fields without null handling properties". Then i used a xformer and handled all nulls and in the sequential i left the nullable column YES. Still the error is same. if i put nullable column NO, it works fine.
Does this mean i cannot put YES in the nullablecolumn and export a null field? Should i always need to handle nulls. Cannot i export nulls as it is to sequential file.Please help me
Sequential file in PX
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
In Parallel jobs you need to handle NULLs explicitly. This doesn't mean that you should do null handling only in the Transformer. Moreover you don't have to do the Null handling on a field if you don't transform that field or if it is not being used in any stage variables.
Now you are having this problem because datastage doesn't know how to write NULLs to the sequential file. This can be solved by setting the "Null Value" property to an empty string "" for instance, Which tells datastage to write empty strings whenever it encounters a NULL. You can set this property to the value you want in the output whenever a NULL is encountered.
Now you are having this problem because datastage doesn't know how to write NULLs to the sequential file. This can be solved by setting the "Null Value" property to an empty string "" for instance, Which tells datastage to write empty strings whenever it encounters a NULL. You can set this property to the value you want in the output whenever a NULL is encountered.
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You need a null handing property - for example Null Field Value or Null Field Length - which informs DataStage what to write into the text file to replace a NULL. Text files don't really have data types - they just have text - so there can be no concept of NULL in a text file, just a pre-defined representation of NULL - what DataStage terms an "in-band null", one that's a legal value for the domain but which is defined as representing null.
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.
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
Sequential file px
Where can i find the null value property in sequential file. i have checked all the properties. i didnt find any null value propertyMinhajuddin wrote:In Parallel jobs you need to handle NULLs explicitly. This doesn't mean that you should do null handling only in the Transformer. Moreover you don't have to do the Null handling on a field if you don't transform that field or if it is not being used in any stage variables.
Now you are having this problem because datastage doesn't know how to write NULLs to the sequential file. This can be solved by setting the "Null Value" property to an empty string "" for instance, Which tells datastage to write empty strings whenever it encounters a NULL. You can set this property to the value you want in the output whenever a NULL is encountered.
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
You can find it in the format tab. It's in the same category as the Delimiter.
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>