Archives of the TeradataForum

Message Posted: Fri, 30 May 2003 @ 20:49:48 GMT

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

I have been trying to run a query in BTEQ using rtrim and I have not been succesful. Is it not possible? Below is a sample query. The mesage I receive is: *** Failure 3706 Syntax error: expected something between '(' and the word 'CHILDDB'.

select DISTINCT 'ALTER TABLE '||RTRIM(CHILDDB)||'.'|| CHILDTABLE ||' DROP CONSTRAINT '||INDEXNAME||'; '
from DBC.All_RI_Children
where childdb<>PARENTDB

Any help would be appreciated

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