AS400 data issue

[thanush9sep]

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...

[chulett]

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.

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.