IT16100: ODBC DRIVER MAY CRASH WHEN EXECUTING A 'INSERT INTO ... SELECT FROM' SQL STATEMENT IF THERE ARE ANY 'TEXT' COLUMNS IN THE INSERT

APAR status

• Closed as fixed if next.

Error description

• The ODBC driver may crash trying to insert into a TEXT column if
  it uses the 'INSERT INTO ... SELECT FROM ...' syntax.
  
  The IDS server may fail to cast the TEXT data type and will
  return a -617 error.
  If that happens, rather than returning the error to the
  application, the driver tries to re-prepare the SQL using
  parameters which end in a memory violation within the driver.
  The stack looks like:
  
     MSVCR90!strcat
     iclit09b!parseParam
     iclit09b!TextBlobLiteralOperation
     iclit09b!TextBlobLiteralProcessing
     iclit09b!__SQLExecDirect
     iclit09b!SQLExecDirectW
     ODBC32!SQLExecute
     ODBC32!SQLExecDirect
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 4.10.xC8                                          *
  ****************************************************************
  

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:

Fix information

Applicable component levels