Using the user-defined sql in Teradata API, and the oprtion
{FILE} (file path) instead of typing the SQL script directly into the user-defined sql tab in Teradata, would it be possible to parameterize the table path in sql script itself?
For example, I want to execute {FILE} /root/aaa.sql
In the aaa.sql script I have this:
Code: Select all
USING NUMBER(INTEGER),PLAYERNAME(CHAR(255))
INSERT INTO Clubs.Arsenal(Number, Playername)
VALUES (:Number, :Playername);
INSERT INTO #p_clubs#.Arsenal(Number, Playername)
VALUES (:Number, :Playername);
Pls advise.
Rgds,
Kay