Page 2 of 2
Posted: Sun Aug 13, 2006 5:55 am
by kumar_s
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.
Posted: Sun Aug 13, 2006 6:01 am
by prabu
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.
Hi Kumar,
Yes, the column is nullable. I miss the point here, why a dataset as target
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
. 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
Posted: Sun Aug 13, 2006 6:24 am
by kumar_s
Sorry, I missed. I was about to say Oracle stage to dataset.
And what is the data type of the column, on which datastage complaints.
Posted: Sun Aug 13, 2006 4:57 pm
by dsusr
prabu wrote: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.
Hi Kumar,
Yes, the column is nullable. I miss the point here, why a dataset as target
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
. 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!
Posted: Sun Aug 13, 2006 10:42 pm
by prabu
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
Hi dsuser,
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
Posted: Mon Aug 14, 2006 8:19 am
by prabu
any volunteers to close it once and for all
regards,
Prabu
Posted: Mon Aug 14, 2006 8:57 am
by Krazykoolrohit
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.