Reading zoned decimals in DB2

[venkycool]

Hi All,

I am trying to migrate the data from DB2 (source) and SQL (target).

In DB2, some tables are having columns with datatype as Numeric. When I try to view the data, the data represents in "?" wherever the columns has the datatype as numeric.

From the DB2 level table definitions, those numeric colums are zoned decimals. How can I make those data can be viewed in DataStage.

Thanks in advance.

[ArndW]

Are you reading sequential files or DB2 tables? I ask because DB2 does not have zoned decimal, whereas COBOL structures in sequential files do.

[venkycool]

I am reading the DB2 tables, not the sequentila file.

I have looked at the DB2 tables which is AS/400, the table definition are having packed decimals and xoned decimals. But packed decimals is working fine. Problem is with zoned decimals where I cannot view the data in DataStage.

[i_sivapras]

i think the columns are having null values.can u check those columns are nullable or not