Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 15 Dec 1999 @ 10:00:34 GMT


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


Subj:   EXCEPT keyword
 
From:   Dean Taplin

It appears you cannot use the EXCEPT keyword in a CREATE VIEW statement. I get error 3706: expected something between an integer and the 'EXCEPT' keyword. Is there anyway round the problem without reverting back to using a NOT IN.

     CREATE VIEW fred.fview1(CLIENTID) AS
         SELECT CLIENTID
         FROM MIDASVA.VCLIENT A
         WHERE A.status = 'A'
           AND A.age > 40
         EXCEPT ( SELECT E.CLIENTID FROM MIDASVA.VEVENT E WHERE E.mailable = 'N')

The above query doesn't work,,,

     SELECT CLIENTID
         FROM MIDASVA.VCLIENT A
         WHERE A.status = 'A'
           AND A.age > 40
         EXCEPT ( SELECT E.CLIENTID FROM MIDASVA.VEVENT E WHERE E.mailable = 'N')

...but if I run just the SELECT part of the query it works okay.


Thanks,

Dean Taplin
Development

Intrinsic
Faringdon Oxfordshire UK SN7 7HY
www.intrinsic.co.uk



     
  <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: 27 Dec 2016