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
Call an SQL script from Teradata API
Moderators: chulett, rschirm, roy
Call an SQL script from Teradata API
Datastage is pretty interesting
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
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.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>