Page 1 of 1
calling a .txt or .sql file in ODBC stage
Posted: Wed Jun 01, 2011 4:11 am
by karthi_gana
All,
I would like to call a .txt file (which contain some piece of sql code) from ODBC stage. is it possible? if yes, how?
Posted: Wed Jun 01, 2011 6:36 am
by chulett
As long as 'some piece' means 'the whole statement' then yes, you should be able to do that. The mechanism is documented, from what I recall off the top of my head there's either a specific "SQL File" option or you use custom sql with a {FILE} or [FILE] prefix before the pathname.
Posted: Fri Jun 17, 2011 2:21 pm
by satisht
Hi Karthi,
If I am getting it right. You want to apply SQL code in your ODBC stage
from a .txt file.
I think there is an option in the Stage Tab to mention the SQL from file. Pls check the developers guide..........
Posted: Fri Jun 17, 2011 4:05 pm
by ray.wurlod
What does "call" mean in this context? For example, if you try to invoke a txt file from a CMD shell, nothing happens.