Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 13 Dec 2007 @ 20:52:57 GMT


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


Subj:   Re: Verifying tables structures between two different databases
 
From:   Leslie, Quincy

There is an approach contained in the standard package of Teradata SQL documentation. Essentially you write the same SQL for each structure and compare via UNIONS of the SELECT from each.

This raises a question, because their/TD example actually compares the structures between two TD servers, not just on the same server. The remote server is accessed by using a UDF they call "tdat". However, no where do they provide the "C" code for "tdat". Contacts with TD technical support/sales staff has not produced an answer, and the writer of the technical approach appears to no longer be with TD.

So! Does anyone have the "C" code for "tdat", the UDF for remote access to a TD server from a current server?

I would be very interested in obtaining that code!


Quincy Leslie
Sr. Systems Coordinator - EDW/BI



     
  <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: 15 Jun 2023