IT38813: INFORMIX HQ - SQL EDITOR IS NOT ALLOWING TO RUN MULTIPLE SQL STATEMENTS AT A TIME

APAR status

• Closed as program error.

Error description

• Informix HQ - SQL Editor is not allowing to run multiple SQL
  statements at a time, only one SQL statement is allowed to run
  at a time
  
  For example : set explain on;
  
  select * from customer;
  
  is throwing below error
  
  -555: Cannot use a select or any of the database statements in a
  multi-query prepare.
  Near character pdosition 38
  
  Informix HQ - SQL Editor should run multiple SQL statements at a
  time
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of informixHQ prior to 2.4.0.                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to informixHQ 2.4.0.                                 *
  ****************************************************************
  

Problem conclusion

• Fixed in informixHQ 2.4.0.
  

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