Archives of the TeradataForum
Message Posted: Fri, 30 May 2003 @ 20:49:48 GMT
| Subj: || || BTEQ and RTRIM |
| From: || || Paul Swier |
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||'; '
Any help would be appreciated