IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IFS version 9.7.9                                 *
    ****************************************************************
    

Problem conclusion

  • v97fp9, the query will succeed
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    JR42865

  • Reported component name

    FEDERATION SERV

  • Reported component ID

    5724N9700

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-05-15

  • Closed date

    2013-12-24

  • Last modified date

    2013-12-24

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

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

    IC95361 IC96275

Fix information

  • Fixed component name

    FEDERATION SERV

  • Fixed component ID

    5724N9700

Applicable component levels

  • R970 PSY

       UP

  • RA10 PSY

       UP

  • RA50 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
11 October 2021