Using the SQL Assist SmartGuide Insert/Update page, you can specify columns and their values.
To specify columns and values for an insert:
To specify columns and values for an update:
You can also specify parameters in the Value list. If a parameter is specified, its value is used in the INSERT or UPDATE statement. A parameter is specified in the format :parm, where parm is the parameter name. For example, :empid is a valid specification for a parameter named empid.
To cancel visual composition of the SQL statement, select Cancel.
Composing an SQL INSERT, UPDATE or DELETE
Specifying the tables for an SQL statement
Specifying columns and their values for an SQL UPDATE or INSERT
Specifying search conditions
Displaying the SQL statement