|
Pivot
|
Condition
|
Datatype
|
|---|---|---|
|
P-Boolean
|
|
boolean
|
|
P-Byte
|
L=0 or L ø
|
bit
|
|
Valid
|
bit(@L)
|
|
|
P-Character
|
L=0 or L ø
|
char
|
|
Valid
|
char(@L)
|
|
|
P-Currency
|
|
money
|
|
P-Date
|
|
date
|
|
P-Decimal
|
L=0 or L ø
|
decimal
|
|
L>=1 and D ø
|
decimal(@L)
|
|
|
L>=1
|
decimal(@L,@D)
|
|
|
P-Double
|
|
double precision
|
|
P-Integer
|
|
integer
|
|
P-Long Integer
|
|
bigint
|
|
P-Numeric
|
L=0 or L ø
|
numeric
|
|
L>=1 and D ø
|
numeric(@L)
|
|
|
L>=1
|
numeric(@L,@D)
|
|
|
P-Real
|
|
real
|
|
P-Smallint
|
|
smallint
|
|
P-Text
|
|
text
|
|
P-Time
|
L=0 or L ø
|
time
|
|
Valid
|
time(@L)
|
|
|
P-Timestamp
|
L=0 or L ø
|
timestamp
|
|
L <> 0
|
timestamp(@L)
|
|
|
P-Varchar
|
L=0 or L ø
|
varchar
|
|
Valid
|
varchar(@L)
|
|
Datatype
|
Condition
|
Pivot
|
|---|---|---|
|
bigint
|
|
P-Long Integer
|
|
bit
|
|
P-Byte
|
|
bit(L)
|
|
P-Byte
|
|
boolean
|
|
P-Boolean
|
|
char
|
|
P-Character
|
|
char(L)
|
|
P-Character
|
|
date
|
|
P-Date
|
|
decimal
|
|
P-Decimal
|
|
decimal(L)
|
|
P-Decimal
|
|
decimal(L,D)
|
|
P-Decimal
|
|
double precision
|
|
P-Double
|
|
integer
|
|
P-Integer
|
|
money
|
|
P-Currency
|
|
numeric
|
|
P-Numeric
|
|
numeric(L)
|
|
P-Numeric
|
|
numeric(L,D)
|
|
P-Numeric
|
|
real
|
|
P-Real
|
|
smallint
|
|
P-Smallint
|
|
text
|
|
P-Text
|
|
time
|
|
P-Time
|
|
time(L)
|
|
P-Time
|
|
timestamp
|
|
P-Timestamp
|
|
timestamp(L)
|
|
P-Timestamp
|
|
varchar
|
|
P-Varchar
|
|
varchar(L)
|
|
P-Varchar
|