nodejs-driver/samples/ElicitFile.ts at develop · Teradata/nodejs-driver · GitHub

36 lines (29 loc) · 1.21 KB

// This sample program demonstrates how to use the Elicit File feature of the Teradata SQL Driver for Node.js

// to upload the C source file to the Teradata Database and create a User-Defined Function (UDF).

// This sample program requires the udfinc.c source file to be located in the current directory.

// @ts-ignore

import * as teradatasql from "teradatasql";

type Row = any[] | null;

const con: teradatasql.TeradataConnection = teradatasql.connect({ host: "whomooz", user: "guest", password: "please" });

try {

const cur: teradatasql.TeradataCursor = con.cursor();

try {

console.log("Create function");

cur.execute(

"create function myudfinc(integer) returns integer language c no sql parameter style sql external name 'CS!udfinc!udfinc.c!F!udfinc'"

);

console.log("Execute function");

cur.execute("select myudfinc(1)");

const row: Row = cur.fetchone();

if (row) {

console.log("Function returned", row[0]);

}

console.log("Drop function");

cur.execute("drop function myudfinc");

} finally {

cur.close();

}

} finally {

con.close();

}

Expand file tree