AGKRInsertSelect.ts

// Copyright 2023 by Teradata Corporation. All rights reserved.

// This sample program demonstrates Insert/Select with Auto-Generated Key Retrieval (AGKR).

// @ts-ignore
import * as teradatasql from "teradatasql";

const con: teradatasql.TeradataConnection = teradatasql.connect({ host: "whomooz", user: "guest", password: "please" });
try {
    const cur: teradatasql.TeradataCursor = con.cursor();
    try {
        const sTableName: string = "agkrdemo";
        cur.execute("drop table " + sTableName, undefined, 3807);
        cur.execute("create table " + sTableName + " (c1 integer generated by default as identity, c2 varchar(100))");

        try {
            console.log("Using AGKR option C to return identity column values only");
            cur.execute("{fn teradata_agkr(C)}insert into " + sTableName + " (c2) select InfoKey from DBC.DBCInfo");

            console.log("All identity column values are returned in one result set");
            console.log(cur.fetchall());

            console.log("Using AGKR option R to return entire inserted rows");
            cur.execute("{fn teradata_agkr(R)}insert into " + sTableName + " (c2) select InfoData from DBC.DBCInfo");

            console.log("All inserted rows are returned in one result set");
            console.log(cur.fetchall());

            console.log("Final contents of table");
            cur.execute("select * from " + sTableName + " order by 1");
            console.log(cur.fetchall());
        } finally {
            cur.execute("drop table " + sTableName);
        }
    } finally {
        cur.close();
    }
} finally {
    con.close();
}