A fix is available
APAR status
Closed as program error.
Error description
Import of "Cobol File definitions" using DataStage Designer: PIC 9(4) is generated without 'unsigned' attribute ({zoned, default=0} instead of {default=0, zoned, unsigned} )
Local fix
Workaround After import the Cobol File Definition into table definition open the table definition from DataStage Designer, and then change MainFrame Access type from "QSAM_SEQ_FLAT" to "QSAM_SEQ_COMPLEX" in the Genral tab. After changing the MainFrame Access type proprty then load the table definition or drag-and-drop it into CFF stage the column definition will be loaded correctly.
Problem summary
Import of "Cobol File definitions" using DataStage Designer: PIC 9(4) is generated without 'unsigned' attribute ({zoned, default=0} instead of {default=0, zoned, unsigned} )
Problem conclusion
Install the patch which goes with this APAR.
Temporary fix
Workaround After import the Cobol File Definition into table definition open the table definition from DataStage Designer, and then change MainFrame Access type from "QSAM_SEQ_FLAT" to "QSAM_SEQ_COMPLEX" in the Genral tab. After changing the MainFrame Access type proprty then load the table definition or drag-and-drop it into CFF stage the column definition will be loaded correctly.
Comments
APAR Information
APAR number
JR39870
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
850
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-06-17
Closed date
2011-09-08
Last modified date
2011-09-08
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R850 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
08 September 2011