You can designate a literal value as a default value. A literal value is a string of alphabetic or numeric characters. To use a literal value as a default value, you must adhere to the syntax restrictions in the following table.
For Columns of Data Type | Format of Default Value |
---|---|
BOOLEAN | Use 't' or 'f' (respectively for true or false) as a Quoted String, p. Quoted String. |
CHAR, CHARACTER VARYING, DATE, VARCHAR, NCHAR, NVARCHAR, LVARCHAR | |
DATETIME | Literal DATETIME, p. Literal DATETIME |
DECIMAL, MONEY, FLOAT, SMALLFLOAT | Literal Number, p. Literal Number |
INTEGER, SMALLINT, DECIMAL, MONEY, FLOAT, SMALLFLOAT, INT8 | Literal Number, p. Literal Number |
INTERVAL | Literal INTERVAL, p. Literal INTERVAL |
Opaque data types (IDS) | Quoted String, p. Quoted String in Single-Column Constraint format (p. Single-Column Constraint Format) |
DATE literals must be of the format that the DBDATE (or else GL_DATE) environment variable specifies. In the default locale, if neither DBDATE nor GL_DATE is set, date literals must be of the mm/dd/yyyy format.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]