IT27610: SYSTEM THROWS 674 ERROR WHEN SYS_CONNECT_BY_PATH IS USED MORE THAN ONCE IN SQL QUERY

APAR status

• Closed as program error.

Error description

• System throws 674 error when SYS_CONNECT_BY_PATH is used more
  than once in SQL query in IDS version 12.10.FC11.
  
  Scenario 1 (SYS_CONNECT_BY_PATH used only once):
  
  Below sql  query executes without any error.
  
  SELECT empid, name, mgrid, SYS_CONNECT_BY_PATH( name,'/') as
  hierarchy
     FROM employee
     START WITH name = 'Henry'
     CONNECT BY PRIOR empid = mgrid;
  
  Scenario 2 (SYS_CONNECT_BY_PATH used more than once):
  
  Below sql query when executed throws 674 error.
  
  SELECT empid, name, mgrid,
  SYS_CONNECT_BY_PATH( name,'/') as hierarchy,
  SYS_CONNECT_BY_PATH( name,'/') as hierarchy1,
     FROM employee
     START WITH name = 'Henry'
     CONNECT BY PRIOR empid = mgrid;
  
  Error message:
   674: Routine (sys_connect_by_path) can not be resolved.
  
  Note: In IBM Informix Dynamic Server Version 12.10.FC10, the
  same sql query (query with SYS_CONNECT_BY_PATH more than once)
  executes without any error.
  The issue is only in IDS 12.10.FC11.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of IDS prior to 12.10.xC13.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * System throws 674 error when SYS_CONNECT_BY_PATH is used     *
  * more than once in SQL query.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Fixed in IDS 12.10.xC13.
  

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

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels