Return Identity Data
Usage Notes
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 GENERATED AS IDENTITY SQL syntax.
This field is a one-byte switch located at hex offset +165.
|
Language |
Variable Name |
|
COBOL: |
RETURN-IDENTITY-DATA |
|
C: |
return_identity_data |
|
Routine |
Action Taken |
|
DBCHINI: |
writes |
|
DBCHCL: |
reads (RSUP; IRQ) |
|
Used by |
Action Taken |
|
application program |
writes |
|
Value |
Description |
|
N |
This is the default. If N is set, there is no auto-generated key retrieval. |
|
C |
This value specifies column-oriented retrieval. |
|
R |
This value specifies row-oriented retrieval. |
The passed values must be in ASCII.
Do not specify Return-identity-data in clispb.dat or HSHSPB; you can only use Return-identity-data with the DBFIRQ function.