Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 10 Aug 2007 @ 17:36:20 GMT


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


Subj:   Re: Bteq SHOW TABLE export
 
From:   Hanson, Robert

I created a small unix file called bob with the following code in it:

     exec bteq <


I then run this from the unix command line as follows:

     Master:/home/sysdba # ./bob dbc.dbcinfotbl

The results are as follows:

     Master:/home/sysdba # ./bob dbc.dbcinfotbl
     BTEQ 08.02.03.07 Fri Aug 10 11:11:27 2007
     +---------+---------+---------+---------+---------+---------+
     .logon tdampfe1/sysdba,
      *** Logon successfully completed.
      *** Teradata Database Release is V2R.06.01.01.49
      *** Teradata Database Version is 06.01.01.47
      *** Transaction Semantics are BTET.
      *** Character Set Name is 'ASCII'.
      *** Total elapsed time was 1 second.
     +---------+---------+---------+---------+---------+---------+
     show table dbc.dbcinfotbl;
      *** Text of DDL statement returned.
      *** Total elapsed time was 1 second.
     +---------+---------+---------+---------+---------+---------+
     CREATE SET TABLE dbc.dbcinfotbl ,FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT
          (
           InfoKey VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
           InfoData VARCHAR(16384) CHARACTER SET LATIN NOT CASESPECIFIC)
     UNIQUE PRIMARY INDEX ( InfoKey );

     +---------+---------+---------+---------+---------+---------+
     .quit
      *** You are now logged off from the DBC.
      *** Exiting BTEQ...
      *** RC (return code) = 0
     Master:/home/sysdba #


     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020