IBM Support

JR36511: INFORMIX WRAPPER RETURNS SQL1822N ERROR WHEN USING RTRIM FUNCTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • You will receive an  SQL1822N error with error code "-201
    (offset 68)"  if you meet both of the
    following condition:
    (1)Using rtrim function in Informix server version 11
    (2)the column to be trimed contains null value
    
    Reproducing steps:
    
    
    create wrapper informix;
    create server <your_server> type informix version 11.0 wrapper
    
    informix.........;
    create user mapping for user server <your_server> ............;
    
    set passthru <your_server>;
    
    create table testtbl (ch char(10));
    insert into testtbl values('aaa');
    insert into testtbl values(null);
    set passthru reset;
    create nickname "<your_nickname>" for
    "<your_server>"."<remote_schema>"."testtbl";
    
    
    db2 => select ch from "<your_nickname>" where rtrim(ch) = 'a'
    
    
    CH
    ----------
    SQL1822N  Unexpected error code "-201 (offset 68)" received from
    data source
    "DATASTORE2". Associated text and tokens are "A syntax error has
    occurred.".
    SQLSTATE=560BD
    

Local fix

  • Change the Informix server version from 11 to 10
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * You will receive an  SQL1822N error if you meet both of the  *
    *                                                              *
    * following condition:                                         *
    *                                                              *
    * (1)Using rtrim function in  Informix server version 11       *
    *                                                              *
    * (2)the column to be trimed contains null value               *
    *                                                              *
    *                                                              *
    *                                                              *
    * This problem occurs since v91 fixpack9, in which the error   *
    *                                                              *
    * reported is                                                  *
    *                                                              *
    * like below:                                                  *
    *                                                              *
    * SQL1822N  Unexpected error code "-201 (offset 68)" received  *
    * from                                                         *
    * data source                                                  *
    *                                                              *
    * "DATASTORE2". Associated text and tokens are "A syntax       *
    * error                                                        *
    * has occurred.".                                              *
    *                                                              *
    * SQLSTATE=560BD                                               *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    * For example:                                                 *
    *                                                              *
    *                                                              *
    *                                                              *
    * create wrapper informix;                                     *
    *                                                              *
    * create server DATASTORE2 type informix version 11.0 wrapper  *
    *                                                              *
    * informix.........;                                           *
    *                                                              *
    * create user mapping for user server DATASTORE2............;  *
    *                                                              *
    * set passthru DATASTORE2;                                     *
    *                                                              *
    * create table testtbl (ch char(10));                          *
    *                                                              *
    * insert into testtbl values('aaa');                           *
    *                                                              *
    * insert into testtbl values(null);                            *
    *                                                              *
    * set passthru reset;                                          *
    *                                                              *
    * create nickname "nick1" for                                  *
    * "DATASTORE2"."j15user1"."testtbl";                           *
    * db2 => select ch from "nick1" where rtrim(ch) = 'a'          *
    *                                                              *
    *                                                              *
    *                                                              *
    * CH                                                           *
    *                                                              *
    * ----------                                                   *
    *                                                              *
    * SQL1822N  Unexpected error code "-201 (offset 68)" received  *
    * from                                                         *
    * data source                                                  *
    *                                                              *
    * "DATASTORE2". Associated text and tokens are "A syntax error *
    * has                                                          *
    * occurred.".                                                  *
    *                                                              *
    * SQLSTATE=560BD                                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to Inforsphere Server version 9.5 fixpack 6          *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in Version 9.5 Fix Pack 6,this fix
    
    should be applied on the server
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR36511

  • Reported component name

    FEDERATION SERV

  • Reported component ID

    5724N9700

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-05-05

  • Closed date

    2010-06-17

  • Last modified date

    2010-06-17

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

    JR36424

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

Fix information

  • Fixed component name

    FEDERATION SERV

  • Fixed component ID

    5724N9700

Applicable component levels

  • R950 PSN

       UP

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPY","label":"General Issues"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
17 June 2010