Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 26 Oct 2009 @ 20:30:26 GMT


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


Subj:   Can functions be nested in views that are used to insert
 
From:   Steve Hager

Can functions be nested in views that are used to insert? I assume not and a macro would be necessary.

     --example table

     CREATE TABLE
     sehager_example
     (c1 VARCHAR(20) CASESPECIFIC)

     --example view

     CREATE VIEW
     sehager_example_insert
     (c1)
     AS
     SELECT
     UPPER(c1)
     from
     sehager_example
     ;
     --insert fails with 3823:  VIEW 'sehager_example_insert' may not be used for Help
     Index/Constraint/Statistics, Update, Delete or Insert.
     INSERT
     sehager_example_insert
     (c1)
     VALUES
     ('abc')
     ;


     
  <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