column

The property column refers to the name of the database table column that is associated with the field. The default is the name of the field. The column and related field affect the default SQL statements, as described in SQL support.

For "columnName", substitute a quoted string; a variable of a character type; or a concatenation, as in this example:
  column = "Column" + "01"
A special syntax applies if a column name is one of the following SQL reserved words:
As shown in the following example, each of those names must be embedded in a doubled pair of quote marks, and each of the internal quote marks must be preceded with an escape character (\):
  column = "\"SELECT\""

(A similar situation applies if you use of those reserved words as a table name.)

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.