Select statements issued against a multiversioned view in DB2 and Informix return base table information

Last Published: April 25, 2020


When using a multiversioned view against versioned data in a DB2 or Informix database, issuing a SELECT statement against the view without first setting the geodatabase version returns only the information in the base table.


The multiversioned view is not defaulting to the DEFAULT geodatabase version.


Always set the version before issuing a SELECT statement against the multiversioned view. This must be done before every SELECT statement.

For DB2, call the sde.setcurrentversion stored procedure to set the geodatabase version.

For Informix, execute the sde.set_current_version function.

For more information on working with multiversioned views, see the ArcGIS Desktop Web Help topic, "Using multiversioned views", listed in the Related Information section below.

  • For DB2, the syntax to call the sde.setcurrentversion stored procedure is as follows:

    CALL sde.setcurrentversion('<version_name>',?,?)
  • For Informix, the syntax to execute the sde.set_current_version function is as follows:

    EXECUTE FUNCTION sde.set_current_version('<version_name>')

Article ID:000010656

  • Legacy Products

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options