Please enable JavaScript to view this site.

ESL Documentation

Navigation: ESL Documentation > ESL DB/Assist > Dialog Boxes (SQL Statement)

Code Generation-Statement Options Dialog Box

Scroll Prev Top Next More

Use this dialog box to specify code generation options for each SQL statement that you create in the SQL Access Module (SAM).

CodeGenerationStatementOptionsDialog

Statement Type

Displays the current statement type.

 

Action Routine Name

Specifies the action routine name that DB/Assist will append to the prefix OPEN_, FETCH_, CLOSE_, or EXECUTE_. The default is the statement name.

 

WHENEVER Processing

Use to specify an action that your EASEL program should take when it executes the generated code for this SQL statement and finds any of the following exception conditions:

SQL system error

SQL system warning

No rows found

The default error handling for the SAM, specified in the Code Generation Options dialog box, will apply unless you change this for a specific statement.

 

Cursor Options

Use to specify a cursor name, and whether the cursor is declared FOR FETCH ONLY and WITH HOLD. This is enabled only for multi-row SELECT statements.

 

OK

Sets the selected options and saves them in the SAM.

 

Cancel

Closes the dialog box without performing any action.

 

Help

Displays help for the dialog box.