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.