Archives of the TeradataForum

Message Posted: Wed, 04 Jul 2012 @ 14:24:40 GMT

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

Paul:

It runs fine for me.

Test 1

     BTEQ -- Enter your SQL request or BTEQ command:

     BTEQ -- Enter your SQL request or BTEQ command:
     UPDATE DATABASE1.TABLE1
     SET FIELD2 = OREPLACE(FIELD2,' ','')
     ;

     *** Update completed. 2 rows changed.
     *** Total elapsed time was 1 second.


     BTEQ -- Enter your SQL request or BTEQ command:
     help function syslib.oreplace;


     *** Help information returned. 4 rows.
     *** Total elapsed time was 1 second.

     Parameter Name                 Type Comment
     ------------------------------ ---- -------
     input_string                   CV   ?
     search_string                  CV   ?
     replace_string                 CV   ?
     RETURN0                        CV   ?

Test 2

     create table DATABASE1.TABLE2 (
     LEAD_ID VARCHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC,
           FIELD2 VARCHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC) PRIMARY INDEX ( LEAD_ID );

     insert DATABASE1.TABLE2('asif',' ');


     *** Insert completed. One row added.
     *** Total elapsed time was 1 second.


     UPDATE DATABASE1.TABLE2
     SET FIELD2 = OREPLACE(FIELD2,' ','')
     ;


     *** Update completed. One row changed.
     *** Total elapsed time was 1 second.

     +++++++++++++++++++++++++

Do not know whats wrong on your side. It would be good to reach out your DBA/support personnel.

Thank you,

Asif

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