The following applies when the value expected or returned has a code showing the data type of the column and whether it can contain null values, as shown below.
|
Field |
Field |
Value |
Data Type |
Nulls |
|---|---|---|---|---|
|
SQLVAR |
SQLTYPE |
384/385 |
date |
no/yes |
|
SQLVAR |
SQLTYPE |
388/389 |
time |
no/yes |
|
SQLVAR |
SQLTYPE |
392/393 |
timestamp |
no/yes |
|
SQLVAR |
SQLTYPE |
436/437 |
numeric (zoned decimal) |
no/yes |
|
SQLVAR |
SQLTYPE |
448/449 |
varying-length character string |
no/yes |
|
SQLVAR |
SQLTYPE |
452/453 |
fixed-length character string |
no/yes |
|
SQLVAR |
SQLTYPE |
456/457 |
long, varying-length character string |
no/yes |
|
SQLVAR |
SQLTYPE |
464/465 |
varying-length graphic string |
no/yes |
|
SQLVAR |
SQLTYPE |
468/469 |
fixed-length graphic string |
no/yes |
|
SQLVAR |
SQLTYPE |
472/473 |
long varying-length graphic string |
no/yes |
|
SQLVAR |
SQLTYPE |
480/481 |
floating-point |
no/yes |
|
SQLVAR |
SQLTYPE |
484/485 |
decimal (packed decimal) |
no/yes |
|
SQLVAR |
SQLTYPE |
496/497 |
large integer |
no/yes |
|
SQLVAR |
SQLTYPE |
500/501 |
small integer |
no/yes |
Note: On DESCRIBE, the type codes 384/385, 388/389, and 392/393 denote date, time, and timestamp, respectively. However, host variables do not have date/time data types, so character string variables must be used to retrieve date/time values. Thus, when the SQLDA describes host variables, these type codes denote fixed-length character string variables.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|