Archives of the TeradataForum

Message Posted: Thu, 24 Oct 2014 @ 01:53:22 GMT

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

Hi,

I tried to perform the below test using SQL assistant as well as bteq. Both works fine for me.

SQL Assistant :-

Before test I have to disable Named parameter options as below.

To switch off parameter substitution

1 Select Tools > Options.

2 Select the Query tab.

3 Clear the option Allow use of Named Parameters in queries.

Note: If an empty string is entered, or the Cancel button is used, the query is left unchanged. This allows for those rare cases where SQL Assistant incorrectly identifies a regular part of the query as being a parameter name.

Steps :-

     drop table idw_datacopy.test -- If it exist

     create table idw_datacopy.test(c10 varchar(20));


     insert into idw_datacopy.test values('"?2.5 ppm"' );

     select * from  idw_datacopy.test

Output :-

              c10
     1       "?2.5 ppm"

For the Bteq, There is no setting require. Just login and execute statement as below, It works fine.

     *** Logon successfully completed.
     *** Teradata Database Release is 14.10.03.04
     *** Teradata Database Version is 14.10.03.04
     *** Transaction Semantics are BTET.
     *** Session Character Set Name is 'ASCII'.

     *** Total elapsed time was 1 second.

     BTEQ -- Enter your SQL request or BTEQ command:
     drop table idw_datacopy.test -- If it exist;

     ;

     *** Table has been dropped.
     *** Total elapsed time was 2 seconds.


     BTEQ -- Enter your SQL request or BTEQ command:
     create table idw_datacopy.test(c10 varchar(20));

     create table idw_datacopy.test(c10 varchar(20));

     *** Table has been created.
     *** Total elapsed time was 1 second.


     BTEQ -- Enter your SQL request or BTEQ command:
     insert into idw_datacopy.test values('"?2.5 ppm"' ) ;

     insert into idw_datacopy.test values('"?2.5 ppm"' ) ;

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


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

     select * from  idw_datacopy.test;

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

     c10
     --------------------
     "?2.5 ppm"

Thanks,

Pinal Patel

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