Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 16 Aug 2007 @ 15:34:26 GMT


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


Subj:   Re: Dynamic View creation
 
From:   Vinay Bagare

Martin,

The way the stored procedure was coded uses two paramenters viz Source DB and Target DB.

This stored procedure also creates the views for you in the target DB.

It takes the column list of the object (View/Table) from DBC.Columns and prepares the column list for the view to be created.

I would suggest you to include a third parameter which could be a table name or view name.

In this case you won't end up creating all views based on objects in Source DB.

Does that make sense?


Thanks,

Vinay Bagare



     
  <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: 28 Jun 2020