Patrick Grealy wrote (excerpted):
>odbc sqlfile("test.sql"), dsn(al)
>
>it seems to run without error but I have no data loaded. What am I missing?
Unlike -odbc load-, -odbc sqlfile- doesn't load any data. It just executes
the script file and displays the results, just as -odbc exec- executes a SQL
statement without loading the answer table. -odbc load- won't run a SQL
script file as far as I know.
Joseph Coveney
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/