Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: ODBC sqlfile question


From   Joseph Coveney <jcoveney@bigplanet.com>
To   Statalist <statalist@hsphsun2.harvard.edu>
Subject   Re: st: ODBC sqlfile question
Date   Thu, 22 Apr 2004 14:43:49 +0900

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/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index