This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Next revision Both sides next revision | ||
|
oaenv:home [2009/12/18 16:40] admin |
oaenv:home [2009/12/18 16:42] admin |
||
|---|---|---|---|
| Line 368: | Line 368: | ||
| Use of the keyword when also using an Omnidex section improves the readability of the Environment Catalog source code. | Use of the keyword when also using an Omnidex section improves the readability of the Environment Catalog source code. | ||
| - | == DATATYPE datatype_spec == | + | ==== DATATYPE datatype_spec ==== |
| Required. Declares the data type format of the defined column. The DATATYPE keyword is required. See Supported Datatypes for a list of supported datatypes. | Required. Declares the data type format of the defined column. The DATATYPE keyword is required. See Supported Datatypes for a list of supported datatypes. | ||
| Line 389: | Line 389: | ||
| DOUBLE Double-precision floating point data stored in 8 bytes. This is equivalent to a “datatype FLOAT length 8”. | DOUBLE Double-precision floating point data stored in 8 bytes. This is equivalent to a “datatype FLOAT length 8”. | ||
| + | <code> | ||
| + | Figure 2 - Examples of Declaring Datatypes Using New and Existing Syntax | ||
| + | New syntax Existing syntax | ||
| + | datatype CHARACTER(10) datatype CHARACTER length 10 | ||
| + | datatype C STRING(10M) datatype C STRING length 1000001 | ||
| + | datatype TINYINT datatype INTEGER length 1 | ||
| + | datatype SMALLINT datatype INTEGER length 2 | ||
| + | datatype INTEGER datatype INTEGER length 4 | ||
| + | datatype BIGINT datatype INTEGER length 8 | ||
| + | datatype FLOAT datatype FLOAT length 4 | ||
| + | datatype DOUBLE datatype FLOAT length 8 | ||
| + | datatype ORACLE DATETIME datatype ORACLE DATETIME length 7 | ||
| + | datatype OMNIDEX DATE(4) format MMDD datatype OMNIDEX DATETIME length 2 format MMDD | ||
| - | + | Figure 3 - Declaring Omnidex Datatypes in the Environment File | |
| - | == LENGTH n == | + | Description Number Value in Parentheses |
| + | For New Syntax Value after LENGTH | ||
| + | For Existing Syntax | ||
| + | CHARACTER 100 characters characters | ||
| + | C STRING 201 characters characters + null terminator | ||
| + | VARCHAR 1700 characters characters | ||
| + | CLOB 1800 characters characters | ||
| + | NATIONAL CHARACTER 102 characters characters * 2 | ||
| + | NATIONAL C STRING 202 characters (characters + null terminator) * 2 | ||
| + | NATIONAL VARCHAR 1701 characters characters * 2 | ||
| + | NATIONAL CLOB 1801 characters characters * 2 | ||
| + | OMNIDEX VARCHAR 1799 characters characters + 4 | ||
| + | OMNIDEX CLOB 1899 characters characters + 4 | ||
| + | [SIGNED] TINYINT 301 1 | ||
| + | UNSIGNED TINYINT 401 1 | ||
| + | [SIGNED] SMALLINT 302 2 | ||
| + | UNSIGNED SMALLINT 402 2 | ||
| + | [SIGNED] INTEGER 300 1, 2, 4 or 8 | ||
| + | UNSIGNED INTEGER 400 1, 2, 4 or 8 | ||
| + | [SIGNED] BIGINT 303 8 | ||
| + | UNSIGNED BIGINT 403 8 | ||
| + | FLOAT 600 4 or 8 | ||
| + | DOUBLE 605 8 | ||
| + | DATE 1000 10 | ||
| + | ODBC DATE 1007 6 | ||
| + | DB2 DATE 1009 6 | ||
| + | INFORMIX DATE 1100 4 | ||
| + | ASCII DATE 1101 6 or 8 (optional, default of 8) 6 or 8 | ||
| + | OMNIDEX DATE 1102 2-8 (optional, default of 8) 1-4 | ||
| + | TIME 1199 11 | ||
| + | ODBC TIME 1200 6 | ||
| + | DB2 TIME 1202 6 | ||
| + | OMNIDEX TIME 1207 2-8 (optional, default of 8) 1-4 | ||
| + | DATETIME 1208 22 | ||
| + | ORACLE DATETIME 1206 7 | ||
| + | ODBC DATETIME 1205 6 | ||
| + | DB2 DATETIME 1208 16 | ||
| + | INFORMIX DATETIME 1206 24 | ||
| + | C DATETIME 1205 4 | ||
| + | OMNIDEX DATETIME 1299 2-16 (optional, default of 16) 1-8 | ||
| + | BLOB 1900 bytes bytes | ||
| + | OMNIDEX BLOB 1999 bytes bytes + 4 | ||
| + | </code> | ||
| + | ==== LENGTH n ==== | ||
| Required. Declares the storage length (as n) of the column in bytes. | Required. Declares the storage length (as n) of the column in bytes. | ||