Archives of the TeradataForum
Message Posted: Thu, 13 Dec 2007 @ 20:52:57 GMT
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
|