Static ESQL Variables and Literal Constants

For Static ESQL, the Preprocessor declares several variables and literal constants that specify global information or are passed as parameters to Static ESQL-LIB functions. Table 4–1 lists these data components and their usage as the Preprocessor defines them.

Table 4–1: Static ESQL Variable Declarations  
Variable or
Literal Constant
ESQL-LIB
Reference
Usage
static char *sqlv[]
psqlv
Specifies the host variables to which the current SQL request refers.
static char sqltxt[]
prequest
Passes the text of the specified SQL request to a Static ESQL-LIB function. If the request is precompiled, this is a literal character string specifying the name of the r-code file that is compiled for the request.
static char sqlfmt[]
pvformat
Specifies the format of each host variable that psqlv specifies to a Static ESQL-LIB function.
Literal character strings
pcursnam
prcfile
Passes the specified cursor name.
Passes the name of the precompiled r-code file that implements some specific ESQL-LIB functions (or a null string if the request is not precompiled).
Literal integers
flag
Passes ESQL-LIB execution options for a Static ESQL-LIB function.


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