Archives of the TeradataForum
Message Posted: Sun, 17 Jul 2005 @ 18:18:56 GMT
the DDL for creating the QCF tables is stored in the SYSTEMFE database with default grant Select to public. This was done as part of V2r4.1
You can simply do what the GUI does from BTEQ or SQL Assistant and create your own set of QCF tables in your database from the command line.
This is how I did it on my MPRAS system. ( don't forget the width parameter in BTEQ or someone of the lines may be truncated )
.os rm /tmp/qcfcreate .export file = /tmp/qcfcreate .set width 512 sel TabDefinition from SystemFe.CreateQCF order by SeqNumber; .export reset database bob ; .run file = /tmp/qcfcreate
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|