A table in AS400 has a column named CREATED with datatype Date and it is NOT NULLABLE. I am using the DbVisualizer to view the records. In that most of the records in the CREATED column shows as (null). But I don't understand why, since the CREATED column is NOT NULLABLE.
I am using the DRS stage to read this table, however the (null) converted into 0001-01-01 by default.
I really don't understand what to do.
Should i keep this as NOT NULLABLE or is there anything to convert this default date (0001-01-01)
but i dont want this '0001-01-01' which is being given by Datastage.
Please help...
AS400 data issue
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 54
- Joined: Thu Oct 18, 2007 4:20 am
- Location: Chennai
AS400 data issue
Regards
LakshmiNarayanan
LakshmiNarayanan
Re: AS400 data issue
That seems like a question or issue to raise with your DBA. Once you know what's going on, it should be easier to know how to deal with it.thanush9sep wrote:A table in AS400 has a column named CREATED with datatype Date and it is NOT NULLABLE. I am using the DbVisualizer to view the records. In that most of the records in the CREATED column shows as (null). But I don't understand why, since the CREATED column is NOT NULLABLE.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers