Prabu - I hope the column is nullable - yes.
Since the the error is at export, for test, try with a sequential file to a dataset.
how to transfer nulls as nulls?
Moderators: chulett, rschirm, roy
Hi Kumar,kumar_s wrote:Prabu - I hope the column is nullable - yes.
Since the the error is at export, for test, try with a sequential file to a dataset.
Yes, the column is nullable. I miss the point here, why a dataset as target
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
Any specific pointers on this
regards,
Prabu
prabu wrote:Hi Kumar,kumar_s wrote:Prabu - I hope the column is nullable - yes.
Since the the error is at export, for test, try with a sequential file to a dataset.
Yes, the column is nullable. I miss the point here, why a dataset as target. my target is a sequentia file and it expects the null to be handled as a pre-requisite.
Any specific pointers on this
regards,
Prabu
Prabu,
Can you please tell us your understanding of 'Null' because if you just set the property in sequential file as Null Field value ='' it will be similar to Null in Oracle.
--dsusr
null , null who holds the key to null!
Hi dsuser,dsusr wrote: Prabu,
Can you please tell us your understanding of 'Null' because if you just set the property in sequential file as Null Field value ='' it will be similar to Null in Oracle.
--dsusr
my target is not Oracle but a sequential file and i want to set the value to "Null" , same eaxact meanining of null . i am exploring to find any system variable instead of a hard-coded value like =". i know you can set the value to any character ~ and decode it as null whenever i read the created target. i can use this decoding logic, if there is no way !
looking for some confirmation
regards,
Prabu
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
Are you using the column for any calculations in stage variable (inside transformer). If yes then you cannot use a nullable variable inside transformer.
And for you other question, a null should be loaded into a delimited sequential file without any transformations required provided all settings a right.
And for you other question, a null should be loaded into a delimited sequential file without any transformations required provided all settings a right.