Archives of the TeradataForum
Message Posted: Thu, 27 May 2004 @ 13:16:56 GMT
I extracted the following select snippet from the view dbc.children
SELECT dbase.DatabaseName(NAMED Child), ownerdb.name(NAMED Parent) WHERE owners.ownerid = ownerdb.id AND owners.owneeid = dbase.DatabaseId
It actually compiles and returns a result set. Is this an old Teradata form of the Select SQL? The V2R5 doc for Teradata DML makes the FROM clause (which is missing above) mandatory....
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|