IT40280: SQL ERROR (-19819): AN ON CLAUSE HAS AN INVALID TABLE REFERENCE

APAR status

• Closed as program error.

Error description

• Getting error when executing the below query. The same query is
  working for other databases (like SQL, Oracle...etc)
  
  select
  automaton2_.id as id1_0_,
  automaton2_.code as code2_0_
  from
  operationtype operationt0_ cross
  join
  operation operation1_
  inner join
  automaton automaton2_
  on operationt0_.automaton_id=automaton2_.id
  where
  operation1_.operationtype_id=operationt0_.id
  and operation1_.id=1
  
  SQL Error (-19819): An ON clause has an invalid table reference
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 12.10.xC16 and 14.10.xC9.  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 12.10.xC16 or 14.10.xC9.          *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC16 and 14.10.xC9.
  

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