Progress
Embedded SQL-92
Guide and Reference


BEGIN-END DECLARE SECTION

Declares variables and types used by the precompiler. Any variables you refer to in an embedded SQL-92 statement must be declared in a DECLARE SECTION. This section starts with a BEGIN DECLARE SECTION statement and ends with an END DECLARE SECTION statement. Each variable must be declared as a host language data type.

SYNTAX

EXEC SQL BEGIN DECLARE SECTION
host_lang_type variable_name ;
  .
  .
  .
EXEC SQL END DECLARE SECTION 

host_lang_type variable_name ;

A conventional C Language variable declaration. This form of variable declaration conforms to the ANSI standard for the C Language.

SYNTAX
{  char  |  short  |  long  |  float  |  double  } 

EXAMPLE

This example is a code fragment from the StatSel function in the sample program 2StatSel.pc. The complete source for the sample program is listed in "ESQL-92 Sample Programs."

EXEC SQL BEGIN DECLARE SECTION ;
      short InvTransNum_v ;
      short Qty_v ;
      short OrderNum_v ;
      EXEC SQL END DECLARE SECTION ; 

NOTES

AUTHORIZATION

None

SQL COMPLIANCE

Declarations that use host-language types are SQL-92 compliant.

ENVIRONMENT

Embedded SQL-92 only

RELATED STATEMENTS

Type Specifications for Static Array Types


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095