Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 21 Mar 2003 @ 00:20:33 GMT


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


Subj:   Re: Creating Index from BETQ
 
From:   Chuck McDevitt

The syntax is incorrect for most versions of Teradata. ODBC rewrites this into the correct syntax for you (Queryman uses ODBC).

Try doing it this way in BTEQ

CREATE INDEX (empname,empdesc) ON testdb.employee;



     
  <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: 15 Jun 2023