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

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 2a - interim special build 2a
DB2 Version 9.1 Fix Pack 1   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 2   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 UDB Version 8.1 FixPak 16 (also known as Version 8.2 FixPak 9 )
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

• 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 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