JR30773: IA ERROR WITH COLUMN NAMES STARTING WITH NUMBERS

APAR status

• Closed as fixed if next.

Error description

• Customer is getting the following errors with IA:
  
  The source of data is IMS on the MF, via Classic Federated, via
  Federated Server. The actual field names are imported into
  classic from COBOL copylibs. Notice all field names begin with a
  number. This is legal on the COBOL side but is not legal in DB2.
  When IA attempts to retrieve the data by field name DB2
  generates many errors.
  
  
  Event 1: pxbridge: Error occurred during initializeFromArgs().
  Event 2: pxbridge: Error parsing schema for output link '1';
  Schema string = 'record (
  320_DEALER_SALES_QTR:  string[4];
  320_DEALER_SSN:  string[9];
  320_DEALER_STATE_ADDRESS:  string[2];
  320_DEALER_PLATES_AVIS:  string[3];
  320_DEALER_XFER_CODE:  string[1];
  320_DEALER_PLATES_COMM:  string[3];
  320_DEALER_QTR_RPT_DUE:  string[10];
  320_DEALER_COUNTY_CODE:  string[4];
  320_DEALER_PLATES_CODE:  string[1];
  320_DEALER_NAME:  string[30];
  320_DEALER_PLATES_ISSUED:  string[3];
  320_DEALER_STREET_ADDRESS:  string[30];
  320_DEALER_UPDATE_DATE:  string[10];
  320_DEALER_FILLER:  string[7];
  320_DEALER_START_DATE:  string[10];
  320_DEALER_QUARTERLY:  string[1];
  320_DEALER_CURR_QUARTER:  string[1];
  320_DEALER_ZIP:  decimal[9,0];
  320_DEALER_CITY_ADDRESS:  string[15];
  320_DEALER_REASSIGNED_FLAG:  string[1];
  320_DEALER_OPERATING_LICENSE:  string[9];
  320_DEALER_SALES_YTD:  string[5];
  )'.
  Event 3: main_program: Creation of a step finished with status =
  FAILED.
   Job Name:
  

Local fix

• Not to use columns with numbers in IA
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Users with columns starting with numbers
  ****************************************************************
  PROBLEM DESCRIPTION:
  Currently, columns that start with numbers cause problems
  ****************************************************************
  RECOMMENDATION:
  Wait until 8.1 RP1 comes out.  This change is also included in
  8.1 Fix Pack 1.
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• TBD
  

Fix information

Applicable component levels

• R801 PSN

     UP