The value of property sqlDataCode is a number that identifies the SQL data type that is associated with the record field. The data code is used by the database management system when you access that system at declaration time, validation time, or generated-program run time.
The property sqlDataCode is available only if you have set up your environment for VisualAge® Generator compatibility. For details, see Compatibility with VisualAge Generator.
The default value depends on the primitive type and length of the record field, as shown in the next table. For other details, see SQL data codes.
EGL primitive type | Length | SQL data code |
---|---|---|
BIN | 4 | 501 |
9 | 497 | |
CHAR | <=254 | 453 |
>254 and <=4000 | 449 | |
>4000 | 457 | |
DBCHAR | <=127 | 469 |
>127 and <=2000 | 465 | |
>2000 | 473 | |
DECIMAL | any | 485 |
HEX | any | 481 |
UNICODE | <=127 | 469 |
>127 and <=2000 | 465 | |
>2000 | 473 |
Related concepts
Compatibility with VisualAge Generator
Record types and properties
SQL support
Fixed structure
Typedef
Related tasks
Retrieving SQL table data