Hi,
I am trying to redesign a Cosort program into PX. Right now I am checking out the metadata details. The input file has a date column which can have null values.
As reported in different topics in this forum, I set the metadata as Date(10) with Nullable property to 'Yes' and the Null Field Value to a default value (9999-12-31). In spite of doing this, the records with null values for this field are getting rejected.
I changed the datatype to Varchar and then the record is retained. Why is it not accepting Date with Null values?
I have also tried other options like setting the Default property and Format string. Yet the problem still persists. Any inputs will be appreciated greatly.
Null handling with Date column
Moderators: chulett, rschirm, roy
Null handling with Date column
Joel Satire
What happens when you just specify a nullable column and set none of the optional attributes?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Ahh, I neglected to think about the inability to write nulls to a sequential file. If you change the date output to 9999-12-31 (are you 100% that is your correct default date format?) and check the output file, do you have 9999-12-31 in that column?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>