IC94856: CODESET CONVERSION FAILURES ARE NOT DETECTED WHEN USING SQLPUTDATA WITH TEXT DATATYPE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • You have an ODBC program that uses Unicode on client side
    (calling API functions ending with W and using wide-char
    strings).  For some statement parameters the program binds them
    as SQL_LONGVARCHAR and then send data using SQLPutData() as in
    the following code fragment:
    
        //error checking not included for clarity
        rc= SQLBindParameter(hstm, 1, SQL_PARAM_INPUT, SQL_C_WCHAR,
    SQL_LONGVARCHAR, len, 0, (VOID *)1,0,&cbTextSize);
        rc =
    SQLExecDirectW(hstm,insert_statement_with_placeholder,SQL_NTS);
        if (rc == SQL_NEED_DATA)
        {
           rc = SQLParamData(hstm, &pParmID);
           rc = SQLPutData(hstm,data_to_insert,SQL_NTS);
           rc = SQLParamData(hstm, &pParmID);
       }
    
    If you insert or update data for a TEXT column and there is a
    codeset conversion error, this is not reported, the insert in
    general goes through but the data in the TEXT column is empty.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ODBC application using SQLPutData() to insert data into TEXT *
    * column.                                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The SQLPutData API doesn't report locale conversion error if *
    * an error happens when it inserts data into TEXT column.      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * The fix has gone into CSDK 3.70.xC8.  Please upgrade CSDK to *
    * this version or higher.                                      *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC94856

  • Reported component name

    IBM CSDK

  • Reported component ID

    5724C2381

  • Reported release

    370

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-08-13

  • Closed date

    2014-02-26

  • Last modified date

    2014-02-26

  • 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

  • R370 PSN

       UP

  • R370 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Informix Tools
Informix Client Software Development Kit (CSDK)

Software version:

370

Reference #:

IC94856

Modified date:

2014-02-26

Translate my page

Machine Translation

Content navigation