PI68494: SQL CODE -408 IS CONFUSING WHEN BINARY TYPE (TYPE=X) IN NATIVE SQL IS USED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer does the following SQLIMS UPDATE call:
  
  UPDATE WARD SET WARDBIN = 00001011 where WARDNO='02';
  
  and gets the following error codes:
  
  SQLIMSCODE =       -408 The value is not compatible with the
  data type
  of column
  
  SQLIMSSTATE   = 42821
  
  SQLIMSERRP    = DFSSQL30 SQLIMS PROCEDURE DETECTING ERROR
  
  
  This is confusing to the customer.  There should be a separate
  negative SQL code that clearly states that the action is not
  supported in the current environment, and a referral to the
  approriate manual for an explanation of what is supported.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IMS V14 Native SQL users.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When the UPDATE SQL statement contains a column with         *
  * unsupported BINARY data type, the application gets a         *
  * SQLIMSCODE -408, which means type mismatch. This is          *
  * incorrect and confuses users.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Install corrective service for APAR/PTF.                     *
  ****************************************************************
  BINARY is not a supported data type in IMS Native SQL. When the
  UPDATE SQL statement contains a column of type BINARY, such as
  this statement:
  
      UPDATE PCB01.HOSPITAL SET XBINARY = 00001011 WHERE HOSPCODE=
  'ARS1001000A
  
  it must get an error that tells the BINARY data type is not
  supported.
  

Problem conclusion

• The problem is resolved by having DFSSQL20 validate the data
  type of columns of UPDATE statements. If a column data type is
  BINARY, an error with SQLIMSCODE -8027 is returned to the
  application. The error message of SQLIMSCODE -8027 clearly
  points out that the UPDATE statement could not be executed
  because it contains an unsupported data type.
  

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:

  UI42277

Modules/Macros

• DFSSQL20
  

Fix information

• Fixed component name

  IMS V14

• Fixed component ID

  5635A0500

Applicable component levels

• R400 PSY UI42277

     UP16/11/08 P F611

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.