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.