Archives of the TeradataForum
Message Posted: Tue, 20 Apr 2004 @ 18:00:08 GMT
In Teradata how does one go about retrieving the generated identity value after a row is inserted?
As an example suppose I have the following table:
CREATE TABLE test01 (a1 INTEGER GENERATED BY DEFAULT AS IDENTITY, a2 INTEGER);
After executing the following statement:
INSERT INTO test01(a2) VALUES(1)
How would I retrieve the value that has been assigned to a1?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|