Call an SQL script from Teradata API

[r.julia]

Hi All,

Is it possible to call an .sql script containing the Select statement (to read fromDB) in a Teradata API stage? I mean instead of typing the SQL statement in the SQL tab in Teradata API. Likewise, would it be possible to do the same if I were to load into Teradata(insert SQL file)

Thank you.
Julia

[JoshGeorge]

Firstly Teradata API stage does not call any teradata utility. It submits whatever ANSI SQL statements you define exactly as you define them on a per-incoming row basis, with a COMMIT sent after each "Transaction Size" of rows.