Skip to Content

VALUE

You can use the VALUE specification to assign a constant value to a column. The constant assigned to a column must be of the same type as the column.


Related topics

BMC-AMI-Load-Syntax-diagrams

Field-specification

INTO-TABLE-options 

value specification syntax

NGT_Load_value_spec.png

The VALUE specification accepts any SQL expression. Note the following restrictions:

  • You cannot specify both VALUE and POSITION.
  • You cannot specify VALUE on a column that determines the partitioning limit value or a clustering index key column.

For more information about constant and special register, see BMC-AMI-Utilities-SQL-language.

The following examples show constants for different data types:

Information
Example


Data types: CHARACTER, VARCHAR

Values for character columns must be a quoted string. For example:

VALUE('a string')


Information
Example


Data types: INTEGER, SMALLINT, BIGINT

Values for integer and small integer columns must be numeric. For example:

VALUE(12)
VALUE(3456)


Information
Example

Data type: DECIMAL

Values for decimal columns must be numeric. For example:

VALUE(12)
VALUE(34.02)


Information
Example


Data types: FLOAT, DECFLOAT

Values for float columns must be numeric.

VALUE(12)
VALUE(-459.2E -20)


Information
Example


Data type: DATE

Values for DATE columns must be a date or the special constant CURRENT DATE.

VALUE(CURRENT DATE)
VALUE(dd.mm.yyyy)
VALUE(mm/dd/yyyy)
VALUE(yyyy-mm-dd)


Information
Example


Data type: TIME

Values for TIME columns must be a date or the special register CURRENT TIME.

VALUE(CURRENT TIME)
VALUE(hh:mm:ss).
VALUE(hh.mm.ss)


Information
Example


Data type: TIMESTAMP

Values for TIMESTAMP columns must be a date or the special register CURRENT TIMESTAMP.

VALUE(CURRENT TIMESTAMP)
VALUE(yyyy-mm-dd-hh.mm.ss.nnnnnn)


Warning

Important

BMC AMI Load supports local date and time option.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Load for Db2 13.1