APAR status
Closed as suggestion for future release.
Error description
Enhancement Request Information Analyzer - Generate Schema Definition Column Ordering Information Analyzer > Publish Analysis Results > Generate Schema Definition > Generate DDL The DDL is generated successfully however the original column ordering is lost. Ideally when generating a DDL the columns should be ordered according to the "Sequence Number" seen in the Column Analysis tab The "Generate Inforsphere Model Definitions PDR" function does result in a model definition in the metadata repository with correct column ordering.
Local fix
None other than manually re-ordering the columns once created
Problem summary
Problem conclusion
Temporary fix
Comments
Upgrade to Information Analyzer 8.7. The following behavior was introduced: 1) Generated DDL will have the columns in the same order as the source data. 2) Generated PDR model in repository will also have the same order.
APAR Information
APAR number
JR39160
Reported component name
WIS INFORM ANAL
Reported component ID
5724Q36IA
Reported release
810
Status
CLOSED SUG
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-03-16
Closed date
2011-09-01
Last modified date
2012-01-20
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
20 January 2012