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.