Archives of the TeradataForum

Message Posted: Thu, 27 May 2004 @ 13:16:56 GMT

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

Hey Guys,

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....

Sonny.

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