IC61807: ERROR 999 IS RETURNED ON LOCAL DATABASE QUERY

APAR status

• Closed as program error.

Error description

• A query with an obvious syntax error will return error 999
  instead of the correct -217 error:
  
  -217    Column column-name not found in any table in the query
  (or SLV is undefined).
  
  See following repro:
  ------------------------
  create database db1 with log;
  create table tab1 (col1 integer);
  insert into tab1 values (1);
  
  create database db2 with log;
  create table tab2 (col2 integer);
  insert into tab2 values (1);
  
  -- Correct Syntax
  database db1;
  select *
  from tab1, db2:tab2
  where
  col1 = db2:tab2.col2;
  
  -- 999 errors
  database db1;
  select *
  from tab1, db2:tab2
  where
  col1 = tab2.col2;
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IDS 11.50xC5 users and below                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A wrongly formed cross-database query that does not resolve  *
  * to unambiguous table columns returns a -999 error.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS 11.50.xC6 and above.                          *
  ****************************************************************
  

Problem conclusion

• Problem first fixed in IDS 11.50.xC6.  A cross-database query
  that does not resolve to  unambiguous table columns will return
  a  -217 error to the user.
  

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:

  IT01454

Fix information

• Fixed component name

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP