Table 4-4 shows which data conversions are valid for input variables. A bullet indicates that conversion is possible. Errors, including truncation, can result if you choose nonconvertible host variable datatypes.
From: COBOL datatype |
To: Adaptive Server datatype |
||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
varchar |
money |
date, time, datetime, datetime4 |
int, smallint, tinyint |
bigint |
ubigint |
uint |
usmallint |
bit |
float |
char |
numeric |
real, float |
|
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-3 |
• |
• |
• |
• |
• |
• |
• |
• |
• |
• |
|||
CS-MONEY, CS-MONEY4 |
• |
• |
• |
• |
• |
• |
• |
• |
• |
• |
• |
• |
|
Key: DSL = Display Sign Leading DSLS = Display Sign Leading Separate DST = Display Sign Trailing DSTS = Display Sign Trailing Separate |