Return Identity Data - Call-Level Interface Version 2

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
Language
English (United States)
Last Update
2024-05-14
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
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.