5. Embedded SQL for Ada : Preprocessor Operation : Command Line Operations : esqla Command – Invoke Embedded SQL Preprocessor for Ada
 
Share this page                  
esqla Command – Invoke Embedded SQL Preprocessor for Ada
The Embedded SQL/Ada preprocessor is invoked by the following command line:
esqla {flags} {filename}
where flags are
Flag
Description
-d
Adds debugging information to the runtime database error messages generated by Embedded SQL. The source file name, line number, and statement in error are displayed with the error message.
-f[filename]
Writes preprocessor output to the named file. If you do not specify a filename, the output is sent to standard output, one screen at a time.
-l
Writes preprocessor error messages to the preprocessor's listing file, as well as to the terminal. The listing file includes preprocessor error messages and your source text in a file named filename.lis, where filename is the name of the input file.
-lo
Acts like the -l flag, but the listing file also includes the generated Ada code.
-?
Shows what command line options are available for Embedded SQL/Ada.
-s
Reads input from standard input and generates Ada code to standard output. This is useful for testing unfamiliar statements. If you specify the -l option with this flag, the listing file is called "stdin.lis." To terminate the interactive session, type Ctrl Z.
-sqlcode
Indicates the file declares an integer variable named SQLCODE to receive status information from SQL statements. That declaration need not be in an exec sql begin/end declare section. This feature is provided for ISO Entry SQL92 conformity.
However, the ISO Entry SQL92 specification describes SQLCODE as a "deprecated feature" and recommends using the SQLSTATE variable.
-nosqlcode
Tells the preprocessor not to assume the existence of a status variable named SQLCODE. The flag -nosqlcode is the default.
-w
Prints warning messages.
-wopen
This flag is identical to -wsql=open. However, -wopen is supported only for backwards capability. Refer to -wsql=open below for more information.
-wsql=entry_
SQL92
Causes the preprocessor to flag any usage of syntax or features that do not conform to the ISO Entry SQL92 entry level standard. (This is also known as the "FIPS flagger" option.)
-wsql=open
Use open only with OpenSQL syntax. -wsql = open generates a warning if the preprocessor encounters an Embedded SQL statement that does not conform to OpenSQL syntax. (For OpenSQL syntax, see the OpenSQL Reference Guide.) This flag is useful if you intend to port an application across different Enterprise Access products. The warnings do not affect the generated code and the output file may be compiled. This flag does not validate the statement syntax for any Enterprise Access product whose syntax is more restrictive than that of OpenSQL.
The Embedded SQL/Ada preprocessor assumes that input files are named with the extension ".sa". You can override this default by specifying the file extension of the input file(s) on the command line. The output of the preprocessor is a file of generated Ada statements with the same name and the extension ".ada".
If you enter the command without specifying any flags or a filename, a list of flags available for the command is displayed.
esqla Command Options
The following table presents the command options available with esqla.
Command
Comment
esqla file1
Preprocesses "file1.sa" to "file1.ada"
esqla file2.xa
Preprocesses "file2.xa" to "file2.ada"
esqla -l file3
Preprocesses "file3.sa" to "file3.ada" and creates the listing "file3.lis"
esqla -s
Accepts input from standard input
esqla -ffile4.out file4
Preprocesses "file4.sa" to "file4.out"
esqla
Displays a list of flags available for this command.