IBM Support

JR24289: SQL1882N ERROR WITH BIORS NICKNAME CREATION IF COLUMN NAME IS GREATER THAN 20 CHARACTERS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When creating a nickname for a BioRS databank, if the
    REMOTE_OBJECT option contains a name longer than
    20 characters or if a column in a REFERENCED_OBJECT is over 20
    characters, an SQL1882N error is returned.
    
    In the following example, "swissprot.features_002" will cause a
    failure.
    
    CREATE NICKNAME swissft
      (
      ID                CHAR (30) OPTIONS (ELEMENT_NAME '_ID_'),
      FtKey             CHAR (15),
      FtLength          CHAR (15),
      FtDescription     CHAR (15),
      Parent            CHAR (30) OPTIONS (REFERENCED_OBJECT
    'swissprot'),
      AllText           CHAR (15)
      )
        FOR SERVER biors_server
          OPTIONS (REMOTE_OBJECT 'swissprot.features_002');
    
    Using a long name in the REFERENCED_OBJECT column option will
    also cause an error.
    
    CREATE NICKNAME BIORS.CYGD_localizations
      (
      ID VARCHAR (256) NOT NULL OPTIONS( IS_INDEXED 'Y',
    ELEMENT_NAME '_ID_' ),
      Parent VARCHAR (256) OPTIONS( REFERENCED_OBJECT 'CYGD' ),
      LocalizationMolecular VARCHAR (256),
      LocalizationSubCellular VARCHAR (256),
      LocalizationEvidence VARCHAR (256)
      )
        FOR SERVER BIORS
          OPTIONS (ADD REMOTE_OBJECT 'CYGD.localizations' )
    
    DB21034E The command was processed as an SQL statement because
    it was not a
    valid Command Line Processor command. During SQL processing it
    returned:
    SQL1882N The "COLUMN" option "ELEMENT_NAME" cannot be set to
    "LOCALIZATIONMOLECULAR" for "LOCALIZATIONMOLECULAR".
    SQLSTATE=428EF
    

Local fix

  • N/A
    

Problem summary

  • Fixed in DB2 version 8 Fixpak 14 (8.2.7)
    

Problem conclusion

  • Fixed in DB2 version 8 Fixpak 14 (8.2.7)
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR24289

  • Reported component name

    WS II NONRELATI

  • Reported component ID

    5724C7413

  • Reported release

    820

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2006-06-29

  • Closed date

    2007-01-19

  • Last modified date

    2007-01-19

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

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

Fix information

  • Fixed component name

    WS II NONRELATI

  • Fixed component ID

    5724C7413

Applicable component levels

  • R820 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":"820","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
07 January 2022