Archives of the TeradataForum
Message Posted: Fri, 10 Aug 2007 @ 16:44:31 GMT
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 ?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|