Archives of the TeradataForum

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

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

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>>