Archives of the TeradataForum
Message Posted: Fri, 30 May 2003 @ 21:16:56 GMT
Subj: | | Re: BTEQ and RTRIM |
|
From: | | Ghosh, Sanjib K |
There is no RTRIM function in Teradata, try the TRIM function instead :-
TRIM ( [ [ LEADING | BOTH | TRAILING ] [ trim_character ] FROM ]
[ character_set ] string_expr )
Remark: TRIM suppresses blanks or binary zeros in the argument result.
select DISTINCT 'ALTER TABLE '||TRIM(TRAILING FROM CHILDDB)||'.'
||CHILDTABLE||' DROP CONSTRAINT '||INDEXNAME
||'; ' from DBC.All_RI_Children
where childdb<>PARENTDB;
|