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?
calling a .txt or .sql file in ODBC stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: