Progress
SQL-89
Guide and Reference
Progress/ESQL
You can embed Progress/ESQL within C source code. You can edit using your favorite text editor, then preprocess, compile, and link (against ESQL-LIB) to produce an executable, which you can run like any other executable.
You must end each Progress/ESQL statement with a semicolon, which is the C statement terminator.
In order to use a C data item in an Progress/ESQL statement, you must first declare the “host variable” to ESQL, and then you must prepend a colon to the C data item within the SQL statement.
Certain Progress 4GL extensions to SQL are not available in Progress/ESQL.
- You cannot use the SELECT statement’s WITH option, as you can in the interactive SQL to access frame, STREAM, and EXPORT options.
- All SELECT statements must be either cursor SELECTs, or singleton SELECTs that return values to host variables.
- You must reference columns and host variables by name.
- You cannot use most format phrase options or array subrange expressions
(variable [ expression [ FOR n ] ] ) that apply to columns and variables in Progress/SQL.NOTE
For more information on Progress/ESQL, see the Progress Embedded SQL-89 Guide and Reference .
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |