GENSQLOBJS Program

GENSQLOBJS is an OLAP DML program that generates a SQL script. The script uses the OLAP_TABLE function to generate views of multidimensional workspace data. The analytic workspace must contain ECM-type metadata, whether generated by CNV_CWM.TO.ECM or provided in a legacy Express database. The resulting dimension views and measure views comprise a star schema that represents the analytic workspace.

You can use the resulting relational views in two ways:

• Create OLAP metadata so that the OLAP API can access data in the analytic workspace.
• Use standard SQL to access data in the analytic workspace.

  See Also: Chapter 15, "CWM2_OLAP_AW_ACCESS" for information about generating views of analytic workspace data.

Return Value

None

Syntax

GENSQLOBJS(aw_name, directory, filename [, language])

Arguments

aw_name

A text expression that provides the name of an ECM-type analytic workspace.

directory

A text expression that provides the name of the directory alias where the SQL script will be created. For information about obtaining access to a directory alias, see "Controlling Access to External Files".

filename

A text expression that specifies the base name of the output script file. An extension of .sql will be appended to this base name.

language

A text expression that identifies the desired language dimension value. Required only when there are workspace objects that support multiple languages. For example, a variable with dimension labels might have a language dimension with values for English, French, and Spanish. When generating a relational view, you must identify which language you want the view to support.

Examples

The following command creates a SQL script with a name of salesdat.sql from the sales analytic workspace. The files are stored in the directory identified by the scripts directory alias. The workspace language dimension will be limited to ENGLISH.

CALL GENSQLOBJS('sales', 'scripts', 'salesdat', 'ENGLISH')