Parameters

With dynamic parameters, you are prompted for input for each parameter on a separate line. Values for parameters are specified the same way literals are specified in SQL.

SQL_TIMESTAMP columns can be added using dynamic parameters. (For example, values like '1998-09-08 12:1212').

Parameter values must be terminated with a semicolon character.

The possible types of values that can be entered are:

• Numeric literals. Example: 1234.5

• Time, date or timestamp literals within single quotation marks. Examples:

  '12:30:00''2000-10-29''2000-10-29 12:30:00''2000-10-29 12:30:00.123456'
  

• Unicode string literals within single quotation marks preceded by 'N'. Example: N'abc'

• A NULL value. Example: NULL

• The '*' character that indicates that the parameter input process should be stopped. Example: *

• The '?' character prints the parameter input help information. Example: ?