Archives of the TeradataForum

Message Posted: Sun, 17 Jul 2005 @ 18:18:56 GMT

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

Hi,

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

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