|
Pivot
|
Condition
|
Datatype
|
|---|---|---|
|
P-AutoIdentifier
|
|
INTEGER
|
|
P-Binary
|
|
CHAR(@L) FOR BIT DATA
|
|
P-Boolean
|
|
CHAR(@L) FOR BIT DATA
|
|
P-Byte
|
|
CHAR (1) FOR BIT DATA
|
|
P-Character
|
Not Unicode and (L=0 or L ø)
|
CHAR
|
|
Not Unicode and 0<L<255
|
CHAR(@L)
|
|
|
Not Unicode and (L=256 or L ø)
|
GRAPHIC(@L)
|
|
|
Not Unicode and L>254
|
VARCHAR(@L)
|
|
|
Not Unicode and L>255
|
VARGRAPHIC(@L)
|
|
|
P-Currency
|
|
DECIMAL(@L,@D)
|
|
P-Date
|
|
DATE
|
|
P-Datetime
|
|
TIMESTAMP
|
|
P-Decimal
|
L=0 or L ø
|
DECIMAL
|
|
L>0 and D ø
|
DECIMAL(@L)
|
|
|
L>0 and D not ø
|
DECIMAL(@L,@D)
|
|
|
P-Double
|
|
DOUBLE
|
|
P-Float
|
L=0 or L ø
|
FLOAT
|
|
L<>0
|
FLOAT(@L)
|
|
|
P-Integer
|
|
INTEGER
|
|
P-Long Integer
|
|
BIGINT
|
|
P-Long Real
|
|
REAL
|
|
P-Multimedia
|
|
BLOB(@L)
|
|
P-Numeric
|
L not ø and D not ø
|
DECIMAL(@L,@D)
|
|
L>9 and D ø
|
FLOAT(@L)
|
|
|
4<L<10 and D ø
|
INTEGER
|
|
|
(L<5 and D not ø) or L ø
|
SMALLINT
|
|
|
P-Real
|
|
REAL
|
|
P-Smallint
|
|
SMALLINT
|
|
P-String
|
|
LONG VARCHAR
|
|
P-Text
|
|
LONG VARCHAR
|
|
P-Time
|
|
TIME
|
|
P-Timestamp
|
|
TIMESTAMP
|
|
P-Tinyint
|
|
SMALLINT
|
|
P-Varbinary
|
|
VARCHAR(@L) FOR BIT DATA
|
|
P-Varchar
|
Not Unicode and (L=0 or L ø)
|
VARCHAR
|
|
Not Unicode and L<>0
|
VARCHAR(@L)
|
|
|
Unicode
|
VARGRAPHIC(@L)
|
|
Datatype
|
Condition
|
Pivot
|
|---|---|---|
|
BIGINT
|
|
P-Long Integer
|
|
BLOB(L)
|
|
P-Multimedia
|
|
CHAR
|
|
P-Character
|
|
CHAR (1) FOR BIT DATA
|
|
P-Byte
|
|
CHAR(L)
|
|
P-Character
|
|
CHAR(L) FOR BIT DATA
|
|
P-Boolean
|
|
DATE
|
|
P-Date
|
|
DECIMAL
|
|
P-Decimal
|
|
DECIMAL(L)
|
|
P-Decimal
|
|
DECIMAL(L,D)
|
|
P-Decimal
|
|
DOUBLE
|
|
P-Double
|
|
FLOAT
|
|
P-Float
|
|
FLOAT(L)
|
|
P-Float
|
|
INTEGER
|
|
P-Integer
|
|
LONG VARCHAR
|
|
P-Text
|
|
REAL
|
|
P-Real
|
|
SMALLINT
|
|
P-Smallint
|
|
TIME
|
|
P-Time
|
|
TIMESTAMP
|
|
P-Timestamp
|
|
VARCHAR
|
|
P-Varchar
|
|
VARCHAR(L)
|
|
P-Varchar
|
|
VARCHAR(L) FOR BIT DATA
|
|
P-Varbinary
|