17.10 - Return Identity Data - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

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.