1  –  DEFAULT default-value

    Provides a default value to be used if the user presses the
    Return key. The default value must be a correctly formatted
    character string that can be converted to the data type of the
    variable.

2  –  HIDE

    Disables echo of the input text. The default is to echo all input
    characters.

3  –  PROMPT string-literal

    Provides a prompt string that is displayed before accepting
    input.

4  –  NOPROMPT

    Disables prompting with a string.

5  –  TIMEOUT numeric-literal

    If the user does not respond within this many seconds, then an
    error is returned. Negative or zero values of the numeric-literal
    are ignored. The default is to wait indefinitely.

6  –  UPPER

    All lowercase characters are converted to uppercase before
    assignment to the variable. The default is to leave lowercase
    characters unchanged.

7  –  variable-ref

    An interactive SQL variable defined using the DECLARE Variable
    statement.