Return-identity-data specifies whether data is returned in response to an SQL Insert operation when Identity columns are involved. An Identity column is a table column created using the 'GENERATED ... AS IDENTITY' SQL syntax.
| In this language... |
The variable name for Return-identity-data is... |
|---|
| COBOL |
RETURN-IDENTITY-DATA |
| PL/I |
RETURN_IDENTITY_DATA |
| C, C++ |
returnIdentityData |
| IBM Assembler |
DBRIRID |
| This routine... |
Takes this action for Return-identity-data... |
|---|
| DBCHINI |
writes |
| DBCHCL |
reads (IRQ; RSUP; IWPF) |
| Return-identity-data is used by... |
To... |
|---|
| applications |
write |
One of the following values may be set before initiating a request:
| If Return-identity-data is set to... |
Then Return-identity-data... |
|---|
| 'N' |
indicates that no fields are returned. |
| 'C' |
indicates that the values for any Identity columns is returned. |
| 'R' |
indicates that the values for all fields in an inserted row that contains Identity columns are returned. |
If not specified, "N" is assumed.