IT28327: MORE CDR COMMANDS FAILING WITH DELIMIDENT SET IN ENVIRONMENT

APAR status

• Closed as program error.

Error description

• A simple (master) replicate definition failing with:
  
  $ cdr def rep cust_repl -m al12s stores7@al12s:andreasl.customer
  "select * from customer"
  command failed -- undefined replicate  (31)
  Interpreting this replicate as a master replicate.cdr error:
  Cannot open cursor - ldTab
  SQL code -217 :Column (T) not found in any table in the query
  (or SLV is undefined).
  
  ISAM 0 :
  
  Trapping errno 217 would hit 11 times with this, last one's SQL
  containing:   ... fragtype = "T" ...
  
  Exact same problem obviously hit with 'cdr sync replicate'
  command.
  
  Workaround:  run these commands without DELIMIDENT env var
  (DELIMIDENT=n or =0  would NOT help).
  

Local fix

• It should not be required for this funcionality to have
  DELIMIDENT set, so the workaround simply is running such command
  without the env var set.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of IDS 12.10.xC13.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * More cdr commands failing with DELIMIDENT set in             *
  * environment.                                                 *
  ****************************************************************
  * 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