Archives of the TeradataForum

Message Posted: Fri, 30 May 2003 @ 21:33:08 GMT

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

Maybe BTEQ does something to the Query... I just ran it from Queryman and it does not return an error.

(My system has no entries in DBC.All_RI_Children but that should make no difference to a syntax error.)

Rather than build statements like this and then execute them you might find it easier to use a Queryman (SQL Assistant) Import statement.

First switch on Export, and run a simple Select statement as:

select DISTINCT CHILDDB, CHILDTABLE, INDEXNAME
from DBC.All_RI_Children
where childdb<>PARENTDB

This exports the results to a text file.

Use Notepad (or whatever) to remove the column headers from this file.

Then switch on Import mode and run the query:

ALTER TABLE ?.? DROP CONSTRAINT ?;

When it asks for the Import file point it to the file created by the export above.

In this particular case it may not be that much simpler ... but for more complex Queries it can make things much simpler. (Especially if the data already exists in a delimited text file. For example creating a whole bunch of UserIds for a new application group.)

Mike Dempsey
Teradata Client Tools

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