A fix is available
APAR status
Closed as program error.
Error description
CSV file containing metadata about Data Files is being converted and imported using istool workbench generate. The file appears to convert and load successfully. However, when the user views the field metadata in IGC the length property is missing and there are no messages or warnings that these properties were not loaded. +++ Data File Field - begin +++ Name,Host,Data File,Data File Structure,Path,Description,ODBC Type,Data Type,Native Type,Length,Unique,Nullability,Fraction,Position dl_source_cd,AXIOM_SERVER,ACUS9_M_LOAN_AGREEMENT_ACCT_20170831.T XT,ACUS9_M_LOAN_AGREEMENT_ACCT_20170831.TXT,/data/Axiom/BAT/Inpu t_Data/2017/acus9/201708 ,,,,VARCHAR,5.0,,false,,2 +++ Data File Field - end +++ When viewed in IGC the length property is not displayed. There was no indication from istool that there was an issue with the metadata in the CSV file. It converted successfully with istool workbench generate command and imported successfully with istool import command. The user expects tan error raised and a non-zero return code if any of the content of the CSV file is invalid.
Local fix
This works as designed. "5.0" is an invalid value for Length. The value must be integer. When detecting a corrupted value the attribute gets an empty value for types with precision and scale (ex: Decimal). Decimal, CSV format for workbench generate has separate columns: length and fraction, both type integer.
Problem summary
********************************************* APAR Users Affected: ********************************************* The users that use the IGC and run the istool for converting the CVS files to the other format (ISX). The files are for Database objects creation. ********************************************* APAR Problem Description: ********************************************* The istool does not write warnings when there is incorrect data format for database objects values, for example the Column Length value is in decimal format, but not in integer (for example: 245.4 instead of 245). ********************************************* APAR Recommendation: ********************************************* Apply the fix for JR59804 *********************************************
Problem conclusion
Apply the fix for JR59804
Temporary fix
Comments
APAR Information
APAR number
JR59804
Reported component name
IS GOVCATLOG
Reported component ID
5724Q36GC
Reported release
B50
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-07-24
Closed date
2018-11-16
Last modified date
2018-11-16
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
IS GOVCATLOG
Fixed component ID
5724Q36GC
Applicable component levels
RB50 PSY
UP
RB70 PSY
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"InfoSphere Information Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5"}]
Document Information
Modified date:
03 September 2021