sqlDataCode

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

Related reference
Field-presentation properties
add
close
Data initialization
delete
execute
get
get next
open
prepare
Primitive types
Record and file type cross-reference
replace
set
SQL data codes and EGL host variables
terminalID
VAGCompatibility

Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.