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.