Archives of the TeradataForum

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

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

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