Archives of the TeradataForum

Message Posted: Tue, 06 Oct 2009 @ 11:42:33 GMT

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

<-- Anonymously Posted: Tuesday, October 06, 2009 07:04 -->

Hi -

My SQL assistant session is working in the CASE SPECIFIC ANSI mode..I never switched to it. It is taking these SQLs differently

     sel * from dbc.tables where tablename like %TABLE1% ;

     sel * from dbc.tables where tablename like %table1%  ;

Any idea how can we turn the BTET mode on - using the SQL assistant window. set session transaction ansi is not working in the SQL assistant window. Also I am not sure how it switched to the ANSI mode. Are there some settings in the SQL assistant which could turn the BTET mode automatically.

Also blank (space bar) is appearing as "." in sql assistant.The scripts are not appearing correct. Please help me to change settings to normal.

Thanks and Regards

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