15.10 - Return-identity-data - Call-Level Interface Version 2

Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

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 the 'GENERATED ... AS IDENTITY' SQL syntax.

 

In this language...

The variable name for Return‑identity‑data is...

COBOL

RETURN‑IDENTITY‑DATA

PL/I

RETURN_IDENTITY_DATA

C

returnIdentityData

IBM Assembler

DBRIRID

 

This routine...

Takes this action for Return‑identity‑data...

DBCHINI

writes

DBCHCL

reads (IRQ; RSUP; IWPF)

 

Return‑identity‑data is used by...

To...

applications

write

One of the following values may be set before initiating a request:

 

If Return‑identity‑data is set to...

Then Return‑identity‑data...

'N'

indicates that no fields are returned.

'C'

indicates that the values for any Identity columns is returned.

'R'

indicates that the values for all fields in an inserted row that contains Identity columns are returned.

Note: If not specified, "N" is assumed.