Archives of the TeradataForum

Message Posted: Mon, 12 Dec 2011 @ 22:54:20 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

With a little off-list help, I found a way to export the results of a SHOW command to a file:

     .LOGON myserverid/myaccount, mypassword
     .SET TITLEDASHES OFF
     .SET WIDTH 256
     .EXPORT REPORT FILE=myfile1.exp
     SHOW SELECT * FROM mydb.myviewname;
     .EXPORT RESET
     .LOGOFF
     .EXIT

Now that I have the results in a file, I can use SAS to load it into a table. I'm sure one can load the table using BTEQ directly, but I'm much more confident of my SAS skills. I can wrap all this into a SAS macro using my own parameters (generating the above script and executing it from inside SAS).

Just thought I'd share,

Thanks for the help and have a good weekend.

Bob

	<Prev	Next>		<<First	<Prev	Next>	Last>>