SET DEFINE

Syntax

SET DEFINE <C>|ON|OFF;

Description

Sets the character with which user variables are initiated. Presetting is the character "&". <C> must relate to one single special character. Using ON and OFF you can activate and deactivate user variables.

Examples

SQL_EXA> define value=A;
SQL_EXA> prompt &value;
SQL_EXA> set define %;
SQL_EXA> prompt %value &value;