MVSFORUMS.com

[mahesh_chv]

We are currently using DB2 V7 and want to migrate to Db2 V9. So we are coming with a tool which can find out all the nullable columns in Db2 tables and

Currently we don't have null indicators for some of the fields, so we need to find the list of all the null columns which don't have null indicators in cobol programs.

In our DCLGEN we don't have null indicators. Most of the programs have declared working storage variables for null indicators.

Is there any way to find out all Nullable columns of all the tables in a DB2

[sriramla]

I believe sysibm.syscolumns table has this information. Look at the column named "NULLS". If it is "Y" then the column is nullable; otherwise not.

[kolusu]

mahesh_chv,

Try this