APAR status
Closed as program error.
Error description
When trying to import sequential file definition into DataStage, the import process incorrectly identifies data columns. Although " is specified as the quote character and the string fields are enclosed in double quotes, if one of the string fields has a period in it, some quoted fields are imported as Numeric type. Also if a field has a comma, that can change which field is incorrectly identified as numeric. See CRM for details, including the data file.
Local fix
This fix is included in 8.0.1 fix pack 3
Problem summary
**************************************************************** USERS AFFECTED: Users may see this problem when importing table definitions fromsequential file data. **************************************************************** PROBLEM DESCRIPTION: This may be seen when importing table definitions from sequential file data. If there are quoted fields in the data that contain comma characters, then the suggested data types will be offset by one after that field containing the comma. Quoted fields that contain a single period character somewhere in the quoted value will be suggested as Numeric, even if there are no numeric characters in the string. **************************************************************** RECOMMENDATION: Apply patch JR31065 This fix is included in 8.1 FP1 ****************************************************************
Problem conclusion
The resolution was to correct the parsing of quoted fields to handle the quoted comma as part of the field rather than as a field separator. The numeric test was also improved to verify that the quote field containing the single period character was made up of digits.
Temporary fix
Comments
APAR Information
APAR number
JR31065
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-11-11
Closed date
2008-12-12
Last modified date
2010-12-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
CLIENT
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R801 PSY
UP
R810 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.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 December 2010