Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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


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