IT06257: JOIN EXPRESSION USING AN SPL CALL IN A STORED PROCEDURE CAN RETURN 9791/110 IN EV_PROCVAR/GETVARDATA

APAR status

• Closed as program error.

Error description

• When a select in a Stored procedure is using an expression like
  
                       where a.clnum == mnumber
                         and a.ncontract == b.ncontract
  -- here
                         and b.number ==
  vklgetccont(a.ncontract,"L")
                         and b.subacc[1,24] == c.acclsc
                         and c.dateclos > mtoday
                         and a.tstatus != 1
  
  where a Stored procedure is called on the right hand side of a
  join
  the server can return 9791 / -110 to the session and write an
  assert failure file with the following
  stack
  
  (oninit)afstack
  (oninit)afhandler
  (oninit)affail_interface
  (oninit)mt_ex_throw_sig@AF11_4
  (oninit)afsig_handler
  (oninit)getvardata
  (*nosymtab*)0x700000050046280
  (oninit)ev_procvar
  (oninit)new_eval
  (oninit)readidx_new
  (oninit)gettupl
  (oninit)scan_next
  (oninit)inner_next
  (oninit)join_next
  (oninit)merge_next
  (oninit)sort_open
  (oninit)prepselect
  (oninit)open_cursor
  (oninit)ip_scurstart
  (oninit)ip_evalcursor
  (oninit)runproc
  (oninit)udrlm_spl_execute
  (oninit)udrlm_exec_routine
  (oninit)udr_execute
  (oninit)exroutine
  (oninit)execproc
  (oninit)aud_execproc
  (oninit)excommand
  (oninit)sq_execute
  (oninit)sqmain
  (oninit)listen_verify
  (oninit)spawn_thread
  (oninit)th_init_initgls
  (oninit)startup
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * select in a stored procedure is using an iterative function  *
  * in where clause                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to IBM Informix Server 12.10.xC5                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In IBM Informix Server 12.10.xC5
  

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

• RC10 PSY

     UP