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.00
Published
June 2020
Language
English (United States)
Last Update
2021-04-19
dita:mapPath
xen1544831946512.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.