Troubleshooting
Problem
When Generating a DDL in IDA, columns are showing as NULL in the create table statement. This only happens when the generated columns are in DB2 ISeries.
Cause
Columns that result in NULL being displayed when trying to generate a DDL are of type 'Generated' in the properties view in IDA. In DB2 ISeries if a column is made as 'Generated' (also called an identity column), its datatype can only be SMALLINT, INTEGER, BIGINT, DECIMAL, or NUMERIC.
Resolving The Problem
There are two ways to resolve this problem:
- Change the datatype of the column showing NULL to SMALLINT, INTEGER, BIGINT, DECIMAL, or NUMERIC. You will then be presented with two options in the drop down list for 'Expression'. The options are 'As Identity' and 'As Identity with Specifier'. After performing the datatype change, the DDL will be generated properly.
- Do not create the ISeries column as 'Generated'. In other words, don't create the column as an identity column.
Related Information
[{"Product":{"code":"SS9UM9","label":"IBM InfoSphere Data Architect"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"7.5.1;7.5.1.1;7.5.2;7.5.2.1;7.5.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21426691