Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 23 Jan 2006 @ 23:03:37 GMT


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


Subj:   Comments inside a view not showing...
 
From:   nazy_gholizadeh

I am using SQL Assistant 7.0 and when try to create a view, the comment lines inside of the view disappear!

It works on the earlier verison but not on 7.0.

Is there a setting I need to turn on for this version to show/accept comment lines, or is this a bug with this version of SQL Assistant?

ex:

     REPLACE VIEW  database.viewname
     -- CREATED FOR .............
     -- CONTAINS ONLY ................
     -- ELIMINATED .....................
     --  1/13/06
     AS LOCKING ROW FOR ACCESS
     SELECT
      ...
     ...
     ...
     FROM
     .......
     WHERE
      .............;

When run this, I get:

     REPLACE VIEW  database.viewname
     AS LOCKING ROW FOR ACCESS
     SELECT
     ...
     ...
     ...
     FROM
     .......
     WHERE
     .............;

Thanks,



     
  <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