Hi ,
I am trying to insert null in Date field in Oracle table which is nullable field, but somehow datastage or oracle is inserting '30-Dec-01' value instead of null.can any one suggest and help me how to keep in the null value in the date field.
Null issue in Date data type
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 194
- Joined: Thu May 11, 2006 9:42 am
Null issue in Date data type
Thanks,
Chris Jones
Chris Jones
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
-
- Participant
- Posts: 194
- Joined: Thu May 11, 2006 9:42 am
Re: Null issue in Date data type
Thanks for your reply..
it is coming from lookup...
it is coming from lookup...
Thanks,
Chris Jones
Chris Jones
Oracle supports a 'default value' but you need to not mention the column in your sql for it to be applied, if you specifically pass a null to the column it will be set to a null.
To me that means it is coming from your job, somewhere in there a default value is being applied.
To me that means it is coming from your job, somewhere in there a default value is being applied.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 33
- Joined: Wed May 19, 2010 12:15 am
- Location: Pune
-
- Participant
- Posts: 3
- Joined: Tue Apr 01, 2008 7:15 am
- Location: Hyderabad
Re: Null issue in Date data type
check somewhere in column level properties default value has been set to the value which you are finding for the field.
Soumyaranjan Mohaptra
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
two possibilities:
1) your job is fetching the date mentioned instead of NULL from the look up
2) a default value for the column has been defined at the database lever
Replace the database stage and put a seq file stage and check what value datastage is fetching, is it a NULL or the date you mentioned.
If it is fetching a NULL then check if there is a dafault value specified at the table level.
1) your job is fetching the date mentioned instead of NULL from the look up
2) a default value for the column has been defined at the database lever
Replace the database stage and put a seq file stage and check what value datastage is fetching, is it a NULL or the date you mentioned.
If it is fetching a NULL then check if there is a dafault value specified at the table level.