Micro Focus Enterprise Developer 3.0 for Eclipse > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > SQL Statements > START PROCEDURE

START PROCEDURE

The START PROCEDURE command checks the argument list for a stored procedure already defined to the SQL engine. If the stored procedure meta-data has been imported from another system, this command can be used to check that the argument list is compatible with XDB syntax rules.

Restriction: This topic applies to Windows environments only.

Invocation

START PROCEDURE is an executable command that can be issued interactively.

Authorization

To execute the START PROCEDURE command, users must possess one (or more) privileges listed in the SYSADM or SYSCTRL authority.

Syntax

START PROCEDURE (Proc-item-list)

Proc-item-list:

Proc-item [, Proc-item]

Proc-item:

{ Procedure-name | * }

Parameters:

Procedure-name

The procedure name is any long identifier that names the procedure. The procedure name can be a partial name followed immediately by an asterisk. The partial name will identify a set of stored procedures to be checked. If an asterisk is used by itself, all procedures defined to the location will be checked. The SQL engine will stop when it encounters the first error.