Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Capture output from "show select *" into a table
From:   DUELL, BOB

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 WIDTH 256
     .EXPORT REPORT FILE=myfile1.exp
     SHOW SELECT * FROM mydb.myviewname;

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.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023