calling a .txt or .sql file in ODBC stage

karthi_gana · Post by **karthi_gana** » Wed Jun 01, 2011 4:11 am

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?

chulett · Post by **chulett** » Wed Jun 01, 2011 6:36 am

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.

satisht · Post by **satisht** » Fri Jun 17, 2011 2:21 pm

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..........

ray.wurlod · Post by **ray.wurlod** » Fri Jun 17, 2011 4:05 pm

What does "call" mean in this context? For example, if you try to invoke a txt file from a CMD shell, nothing happens.