Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


Subj:   Re: Script stops after OREPLACE function
 
From:   Md, Asifuddin

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020