JR32655: SQL0901N REPORTED WHEN QUERYING FROM NICKNAME WITH HEAD EXPRESSION LIKE COALESCE(CHAR,TIME) USING MSSQLSERVER WRAPPER

DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as fixed if next.

Error description

• When you create a nickname on remote table which has a column
  defined as DATETIME/SMALLDATETIME, and then alter the
  corresponding nickname column type to time, it will reported
  error like blow:
  select COALESCE(chti,ti)  from t7
  1
  --------
  SQL0901N  The SQL statement failed because of a non-severe
  system error.
  Subsequent SQL statements can be processed.  (Reason "MSSQL:
  unknown time
  format".)  SQLSTATE=58004
  
  Below is steps to reproduce this error:
  set passthru DATASTORE2;
  drop table t7;
  create table t7 (chti char(30) not null,ti  DATETIME not null);
  insert into t7 values ('01:11:11', '03:33:33');
  set passthru reset;
  create nickname t7 for DATASTORE2.j15user1.t7;
  alter nickname t7  alter column ti local type time;
  select COALESCE(chti,ti)  from t7
  

Local fix

Problem summary

• Users affected:
     Users of the MSSQL wrapper in InfoSphere Federation Server
  Problem description and summary:
     See error description.
  

Problem conclusion

• Problem was first fixed in Version 9.5, FixPak 4 (s090429). This
  fix should be applied on the federation server.
  

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

• R950 PSN

     UP