Previous Topic: Example 3Next Topic: DELETE

SQL Statements › DECLARE STATEMENT

DECLARE STATEMENT

This SQL statement can be executed in the following ways:

Through the CA Datacom Datadictionary Interactive SQL Service Facility (interactive)

In an application program prepared using a CA Datacom/DB SQL Preprocessor (embedded)

By using CA Dataquery (SQL & Batch Modes)

DECLARE STATEMENT

YES

 

Note: YES indicates a valid execution method for this statement.

The DECLARE STATEMENT is accepted by the CA Datacom/DB Preprocessors for SQL for the purpose of syntax compatibility with other SQL implementations, but CA Datacom/DB ignores everything after the keyword STATEMENT up to the end-of-statement delimiter. CA Datacom/DB functionality is not affected.

Following is the syntax diagram for the DECLARE statement (statement-name specifies the 1- to 18-character(s) name of a prepared SQL statement):

►►─ DECLAREstatement-nameSTATEMENT ───────────────────────────────────────────►◄