PH49104: DATASOURCE COLUMN DEFINED AS TIMESTAMP(12) RETURNS A SHORTENED DATA TYPE VALUE VIA THE SQL RETRIEVE OPERATION.

APAR status

• Closed as program error.

Error description

• A table contains the following Timestamp definition:
  RAEKKE_START TIMESTAMP(12) NOT NULL
  
  When implementing an SQL retrieve operation within the EGL
  source editor this will then return the column as:
  RAEKKE_START char(26) {column="RAEKKE_START"};
  
  This is an incorrect data value, it should instead represent the
  following larger value:
  RAEKKE_START char(32) {column="RAEKKE_START"};
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * EGL user implementing SQL Retrieve operations against        *
  * datasource                                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When a table contains a Timestamp definition the SQL         *
  * retrieve operation returns the column with an incorrect,     *
  * shortened length                                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Fixed in RBD 961
  

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:

Fix information

• Fixed component name

  RATL BUS DEV

• Fixed component ID

  5724S5000

Applicable component levels