Return‑identity‑data
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 |
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. |
Note: If not specified, "N" is assumed.