Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 17 Dec 2002 @ 22:16:59 GMT


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


Subj:   View Syntax Formatting
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, December 17, 2002 14:20 -->

Does anyone know how I can keep my original view formatting (line feeds, spaces, etc.) after creating it and then doing a show view? If I do a show view, it is displayed as one continuous line of text.

For example, I run the following view:

"CREATE VIEW DB1.Table2 AS LOCK row FOR ACCESS
        SELECT  Col1,
                  Col2,
                  Col3,
                  Col4
        FROM DB.Table1 ;"

But when, I do a show view, the statement is displayed as:

"CREATE VIEW DB1.Table2 AS LOCK row FOR ACCESS SELECT  Col1, Col2,
Col3, Col4 FROM DB.Table1 ;"

It looses all the formatting and for complex views, it is becoming a pain to recreate the formatting every time I need to review the sql.

I have looked through ODBC parameters, with no luck. I am running Teradata 2.08.00.00 driver. I have the problem creating views through both Queryman (V 5.1) and WinnDDI (V 5.0.0.01).

I appreciate any help!



     
  <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