Specifies which columns are returned by the JDBC Statement.getGeneratedKeys() method. By default, the entire row(s) is returned.

Possible Values

Data Type

string

Default Value

"All"

Remarks

The following are three options for retrieving data from a database:

• When GeneratedKeys is set to All, the system returns the entire rows for modified rows without requiring an additional query for column metadata.
• When GeneratedKeys is set to Generated, only the values of columns generated by the database are returned.
• When GeneratedKeys is set to GeneratedAndKeys, both the database-generated column values and the primary key column values are returned.