Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 10 Aug 2007 @ 16:44:31 GMT


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


Subj:   Bteq SHOW TABLE export
 
From:   David Clough

I'd like to be able to write the result of a Show Table to a file, using Bteq. Thing is, I need to be able to make the script generic in such a way that I can pass in the table name (and database).

Potentially, I could export the database name and table to a file, prior to running the main Bteq script, and then read those values into the bteq script with a

     USING DB_NM CHAR(30),
             TABLE_NM CHAR(30)

type of approach, but then I don't think I can dynamically construct a SHOW TABLE XYX.MYTAB; statement, can I ?

Alternatively, I could dynamically build up a specific Bteq script, which would have all my hard-coded Show table commands already set, but that all seems a bit over-engineered.

Basically, I'd just like to pass into a Bteq script two parameters - like I could with a Stored Procedure - and then export the appropriate SHOW TABLE.

Any ideas ?

Dave Clough
Database Designer
Express ICS

www.tnt.com



     
  <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: 27 Dec 2016