Archives of the TeradataForum

Message Posted: Tue, 02 Sep 2014 @ 13:03:03 GMT

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

Hi,

It worked good for me,

     insert into vb_nm('ganga');

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


      BTEQ -- Enter your SQL request or BTEQ command:


     select * from test.vb_nm;

     select * from test.vb_nm;

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

     name_test            <<<<<<<<<<<<<<<<<<<<<<<<<<<<
     --------------------
     ganga


      BTEQ -- Enter your SQL request or BTEQ command:
     select oreplace('name_test','_','') from test.vb_nm;

     select oreplace('name_test','_','') from test.vb_nm;

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

     oreplace('name_test','_','')
     ---------------------------------------------------------------------------
     nametest                          <<<<<<<<<<<<<<<<<<<<<<<<

     BTEQ -- Enter your SQL request or BTEQ command:
     select * from test.vb_nm;

     select * from test.vb_nm;

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

     name_test            <<<<<<<<<<<<<<<<<<<<<<<
     --------------------
     ganga

Do this help?

Thanks,

Sandeep.

GANGA SANDEEP KUMAR
GTS-Technical Support Specialist

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