IC96275: SQL1822N ERROR WHEN QUERYING CURRENT DATE OR TIMESTAMP FROM NICKNAME

DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• A query that has "current date" or "current timestamp" in its
  select-list may result in SQL1822N error, e.g.
  
  select distinct current date, col1 from nick
  
  SQL1822N  Unexpected error code "-418" received from data source
  "AHE_LPDB_SERVER". Associated text and tokens are " SQL0418N  A
  statement
  

Local fix

• Remove "current date" or "current timestamp" from the
  select-list
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * all platforms, all relational data sources                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to v101fp3                                           *
  ****************************************************************
  

Problem conclusion

• v101fp3
  

Temporary fix

Comments

APAR Information

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

  JR42865

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

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• R970 PSY

     UP

• RA10 PSY

     UP

• RA50 PSY

     UP