Table 4-3 shows which data conversions are valid for result variables. A bullet indicates that conversion is possible, but be aware that certain types of errors can result if you are not careful when choosing host variable datatypes.
From: Adaptive Server datatype |
To: COBOL datatype |
||||
---|---|---|---|---|---|
S9(1—9) COMP, COMP-4, COMP-5, BINARY |
CS-DATE, CS-TIME, CS-DATETIME, CS-DATETIME4 |
PIC X(n) |
S9(m)V9(n) DSLS, DSL, DSTS, DST, COMP, COMP-3 |
CS-MONEY, CS-MONEY4 |
|
char |
• |
• |
• |
• |
• |
varchar |
• |
• |
• |
• |
• |
bit |
• |
• |
• |
||
tinyint |
• |
• |
• |
• |
|
smallint |
• |
• |
• |
• |
|
int |
• |
• |
• |
• |
|
bigint |
• |
• |
• |
• |
|
ubigint |
• |
• |
• |
• |
|
uint |
• |
• |
• |
• |
|
usmallint |
• |
• |
• |
• |
|
float |
• |
• |
• |
• |
|
money |
• |
• |
• |
• |
|
money4 |
• |
• |
• |
• |
|
numeric |
• |
• |
• |
• |
|
real |
• |
• |
• |
• |
|
date |
• |
||||
time |
• |
||||
datetime |
• |
• |
|||
datetime4 |
• |
• |
|||
Key: DSL = Display Sign Leading DSLS = Display Sign Leading Separate DST = Display Sign Trailing DSTS = Display Sign Trailing Separate |