Space announcements

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

EXECSQL statement

The EXECSQL statement directs Log Master to execute a set of SQL statements against a DB2 database. Log Master uses the High-speed Apply Engine to execute SQL statements.

The following figure shows the EXECSQL statement syntax.


SQLDataSetName

Specifies the name of a data set containing valid ANSI SQL statements.

BINDOWNER (authid)

Specifies an authorization ID that has authority within DB2 security to bind programs and generate plans. Log Master uses this authorization ID to bind an application plan whenever Log Master executes generated SQL statements.

The default value of this keyword depends on the value of the BINDOWN= installation option. If your environment does not specify a value for BINDOWN, Log Master uses the user ID of the user who submitted the job.

DECIMAL POINT

Defines the character that was used to delineate fractional values in the SQL generated by the product. The default value for this keyword is the character specified in the DSNHDECP module of the target DB2 subsystem.

  • PERIOD

    Defines the decimal point character as a period (.).

  • COMMA

    Defines the decimal point character as a comma (,).

PLAN NAME (planName)

Specifies the name of an existing plan that Log Master uses to access data during execution of the generated SQL. Log Master creates or updates this plan during processing and uses it to access the required data. The default value for planName is the character constant ALP, followed by the job number (for example, 'ALP00302').

See also PLANESQL=ALP.

FREE | NOFREE

The FREE and NOFREE keywords determine the persistence of information about the plan defined by planName.

  • FREE

    Indicates that Log Master deletes plan information from the DB2 catalog after processing. This is the default value.

  • NOFREE

    Indicates that Log Master retains plan information in the catalog for a subsequent run of the job.

SQLPRINT

Determines the content of the SQLPRINT data set. Log Master writes the results of SQL execution (including SQL codes and statement identifiers) into the SQLPRINT data set as it executes generated SQL statements.

  • WARN

    Causes the SQLPRINT data set to include only the results of SQL statements that receive nonzero SQL codes or SQL warnings. This is the default value.

  • ALL

    Causes the SQLPRINT data set to include the results of all executed SQL statements.

For more information, see SQLPRINT in Specifying the DD statements.



Was this page helpful? Yes No Submitting... Thank you

Comments