Converting datatypes for input variables

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.

Table 4-4: Datatype conversions for input variables

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