IFEXISTS

Conditionally executes an INCLUDE statement, depending on the value of an expression. The expression evaluates the existence of a database object, such as a database, a table, and a column. Depending on the result, it executes the true or false INCLUDE statement. The syntax is:

Syntax

IFEXISTS [Object][Include if true][Include if false]

Parameters

Object

A database object such as database, table, or column.

Include if true

The file name of a script file. If the database object exists, the instruction includes this script file in the load process.

Include if false

The file name of a script file. If the database object does not exist, the instruction includes this script file in the load process.

The example shown in Figure 5-51 checks if the [SalesData].[CarInventory] table exists. The Ifexists instruction executes the Export-file.xml script if the table exists, or Aggregation-scripts.xml, if the table does not exist.

Figure 5-51

Creating the Ifexists instruction

Copyright Actuate Corporation 2013

BIRT Analytics 4.2