Unanswered: cannot find not null in db2look for hierarchy tables definition
I don't know i would able to explain my problem or not. I have a hierarchy tables and i want to duplicate those hierarchy tables into other database. I tried loading data with export and import. but what i have seen after importing the data is the nullability characteristics of some columns are lost..i.e in original tables they were not null and now they are null(i did "describe table" both the sides). then i used db2look to generate the DDL for the original table but i couldn't find anywhere in the table definition or structured data type definition that there is a not null defined. but I can see in the "describe table" output that the columns have not null characteristics. I don't know where to look now.