Progress
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 sample program, 2StatSel.pc, is listed in Appendix A of the Progress Embedded SQL-92 Guide and Reference .

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

ENVIRONMENT

Embedded SQL-92 only

RELATED STATEMENTS

Static Array Types (Chapter 14 in the Progress Embedded SQL-92 Guide and Reference )


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