Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Teradata Visual Explain without access to QCF
From:   Dennis Calkins


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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020