Archives of the TeradataForum

Message Posted: Mon, 24 Feb 2003 @ 21:51:47 GMT

I have done the following for different reasons but you might be able to us the process.

First make a query to make the queries:

sel 'Show '||
(case
when tablekind='G' then ' Trigger '
when tablekind='I' then ' Join Index '
when tablekind='M' then ' Macro '
when tablekind='P' then ' Procedure'
when tablekind='T' then ' Table '
when tablekind='V' then ' View '
end)||
trim(databasename)||'.'||trim(tablename)||
';' as XQL
from DBC.Tables
Where databasename like ('%%')
and tablename like ('%%')
order by databasename,tablename
;

Then paste the results into queryman.

Change queryman to export the results to a single file.

Tools, options, answerset, check 'write all answersets to a single file'.

File, export results.

Run all the commands. The results will be written to a single file which can then be executed on the target system. You can use a text
editor to remove the 'Request Text' which precedes each result set and to make any databasename or tablename changes.