Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Language Elements : Data types
 

Data types

CREATE TABLE statements specify the data type for each column in the table they define. This section describes the data types SQL supports for table columns. All the data types can store null values. A null value indicates that the value is not known and is distinct from all non‑null values.

Syntax

char_data_type
|exact_numeric_data_type
|approx_numeric_data_type
|date_time_data_type
|bit_string_data_type
|array_data_type
|vararray_data_type

Example

The following example illustrates the use of data types in a CREATE TABLE statement:
CREATE TABLE CUSTOMERS
(CUST_NUM INTEGER NOT NULL,
COMPANY VARCHAR (20) NOT NULL,
CUST_REP INTEGER,
CREDIT_LIMIT INTEGER,
PRIMARY KEY (CUST_NUM));
The OpenEdge SQL data types are:
*CHARACTER
*EXACT NUMERIC
*APPROXIMATE NUMERIC
*DATE-TIME
*BIT STRING
*ARRAY
Each data type is described in the following sections.
* Character data types
* Exact numeric data types
* Approximate numeric data types
* Date-time data types
* Bit string data types
* Array data types
* Literals
* Relational operators