ALLBASE/SQL Reference Manual (36216-90216)

592 Chapter12
SQL Statements S - Z
VALIDATE
VALIDATE
The VALIDATE statement validates modules and procedures that have already been
created.
Scope
ISQL or Application Programs
SQL Syntax
VALIDATE [FORCE
DROP SETOPTINFO]
{MODULE { {[ Owner. ] ModuleName } [,...]
{SECTION [ Owner. ] ModuleName ( SectionNumber )} [,...] }
PROCEDURE { {[ Owner. ] ProcedureName } [,...]
{SECTION [ Owner. ] ProcedureName ( SectionNumber )} [,...] }
ALL{MODULES
PROCEDURES} [WITH AUTOCOMMIT]}
Parameters
WITH AUTOCOMMIT executes automatically a COMMIT WORK after each module
or procedure is updated.
[
Owner. ] ModuleName identifies the module containing sections to be validated.
The owner name is the DBEUserID of the person who
preprocessed the program or the owner name specified
when the program was preprocessed. The module name is
the name stored in the SYSTEM.SECTION view.
[
Owner .] ModuleName ( SectionNumber ) identifies the section number as well as the
module to be validated.
[
Owner. ] ProcedureName identifies the procedure to validate. The owner name is the
DBEUserID of the person who created the procedure or
the owner name specified when the procedure was created.
The procedure name is the name stored in the
SYSTEM.SECTION view.
[
Owner .] ProcedureName ( SectionNumber ) identifies the section number as well as the
procedure to be validated.
Description
• When you validate a module or procedure, all the sections within it are checked and
validation is attempted. If an embedded SQL statement accesses an object that does not
exist or that the module or procedure owner is not authorized to execute, then the
corresponding section is marked invalid.
• You may find it convenient to use the VALIDATE statement after an UPDATE