The -D preprocessor command line option provides a means of converting
static SQL statements to dynamic statements with little or no change to existing source code.
This is termed static conversion processing
and provides the flexibility of running an application with either static
processing or dynamic processing. In addition, an already dynamic application can be preprocessed without having to specify a DBEnvironment name in the command line.
This functionality is available for C and Pascal applications.
The following sections describe how to implement this feature. Note that additional information and examples regarding static and dynamic processing are found in the language specific ALLBASE/SQL application programming guides and in later sections in this chapter.
Static Conversion Mode Syntax Specification |
 |
Use one of the following statements to both check SQL syntax and create output files that can be processed by the compiler. All static SQL statements are converted to dynamic statements. Dynamic SQL statements remain dynamic. No module is created, and no DBEnvironment is connected to during preprocessing.
Static Conversion Mode for C Applications
psqlc -D [-i SourceFileName ] [-p ModifiedSourceFileName.c ] [-f FlaggerName ] [-a ] |...|
Static Conversion Mode for Pascal Applications
psqlpas -D [-i SourceFileName ] [-p ModifiedSourceFileName.p ] [-f FlaggerName ] [-a ] |...|
Parameters |
|
- -D
indicates that all static SQL statements are to be converted to dynamic
statements, dynamic statements remain dynamic, and a module is not created.
- -i SourceFileName
identifies the name of the input file containing the source code to be
preprocessed. If a SourceFileName is not specified, a file by the name of sqlin is assumed.
- -p ModifiedSourceFileName
identifies the name for the modified source code file. If a name is not specified, the preprocessor generated code is written to a file with the same name as SourceFileName but with the file extension
.c for a C application and .p for a Pascal application.
- -f FlaggerName
is the name of the flagger being invoked. At this release FIPS127.1 is
the only valid FlaggerName. FlaggerName is not case sensitive.
Refer to the "Flagging Non-Standard SQL with the FIPS Flagger" chapter in this manual.
- -a
preprocesses the application in ANSI mode. The preprocessor generates an SQLCA declaration automatically and implicit updatability is in effect.
Refer to the sections "Understanding Implicit Updatability" and "Declaring the SQLCA" in this manual.
Description |
|
The complete set of ALLBASE/SQL syntax can be preprocessed in static
conversion mode with the following execeptions:
Any DECLARE CURSOR statements must be located in an executable portion
of the code. In the C language, for example, you would declare the cursor within curly brackets following any data declaration statements within a given block.
For Pascal, position the statement within a BEGIN/END block.
Static host variables in the source code (except for those used in a
BULK FETCH or BULK SELECT statement) are converted to dynamic parameters.
Therefore, such static host variables must adhere to the specifications for
dynamic parameters. For further information, refer to the "Using Parameter Substitution in Dynamic Statements" chapter in this document.
When you invoke the preprocessor with the -f option, your application must contain an ANSI mode compiler directive in order for the compiler to detect non-standard statements. The following table lists the appropriate directive for each language:
| Language | Directive |
|---|
| C | cc -Aa |
| COBOL | cob -C ANS85 |
| FORTRAN | $OPTION ANSI ON$ |
| Pascal | $standard_level 'ANSI'$ |
Authorization |
|
At run time, the owner of any unqualified object defaults to the user who
is running the application.
Example of Static Conversion Processing of a C Application |
|
psqlc -D -i ProgramName.sql
|
Example of Static Conversion Processing of a Pascal Application |
|
psqlpas -D -i ProgramName.sql
|
