JR26981: ORACLE WRAPPER ON UNICODE FEDERATED SERVER DOES NOT RETURN CORRECT REQUIRED LENGTH WHEN CONVERTING STRING CONSTANT.

DB2 Version 9.1 Fix Pack 4a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 3   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 4   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 3a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• SQL0901 returned in Oracle wrapper on unicode federated server.
  Query does not return correct required length when converting
  string constant.
   Error text:
  SQL0901N The SQL statement failed because of a non-severe system
  error. Subsequent SQL statements can be processed. (Reason
  "sqlnt_add_constant        ￭150:rc(     0)                ")
  SQLSTATE=58004
  

Local fix

Problem summary

• Users affected: all
  
  Problem description and summary:
  The recreate script is:
  
  CREATE DB test USING codeset IBM-943 territory JP;
  CONNECT TO test;
  CREATE WRAPPER net8;
  CREATE SERVER ora TYPE oracle VERSION 9 WRAPPER net8 options (
        NODE 'ORA9I.SEEL',
        COLLATING_SEQUENCE 'Y',
        DB2_MAXIMAL_PUSHDOWN 'Y',
        DB2_MAX_SEL_SIZE '32000',
        PLAN_HINTS 'N',
        VARCHAR_NO_TRAILING_BLANKS 'Y');
  CREATE USER MAPPING FOR USER SERVER ora OPTIONS
     (REMOTE_AUTHID 'xxxxxxxx', REMOTE_PASSWORD 'xxxxxxxx');
  SET PASSTHRU ora;
  CREATE TABLE c_sample
     (smplcomm VARCHAR2(500));
  INSERT INTO c_sample(SMPLCOMM) VALUES('ID1234567890');
  SET PASSTHRU reset;
  CREATE NICKNAME c_sample FOR ora.xxxxxxxx.c_sample;
  SELECT * FROM c_sample WHERE smplcomm LIKE 'ID%' ;
  
  The error message is:
  SQL0901N The SQL statement failed because of a non-severe system
  error.
  Subsequent SQL statements can be processed.
  (Reason "sqlnn_tra_1st_err: the tra stack is empty!")
  SQLSTATE=58004
  

Problem conclusion

• Problem was first fixed in Version 9, FixPak 3 (s070719).  This
  fix should be applied on the federation server.
  

Temporary fix

Comments

APAR Information

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

  IY96692

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

Fix information

• Fixed component name

  ODBC WRAPPER

• Fixed component ID

  5724N9707

Applicable component levels

• R910 PSN

     UP

• R911 PSN

     UP