How do I find if the session in ANSI/Teardata mode? Are there any differences in the SQL's for both?
I actually have a code that checks for 'ABC' but the data is 'Abc'. Only when I use UPPER('Abc') it returns rows. I have read that in ANSI mode the case sensitivity comes in to picture. So want to check the mode of my session. And how do I change the mode?
Thanks Dieter! But my transaction_mode is 'T', which I think means Teradata. So why is my code case sensitive? It does not return rows when I check for 'Abc', however it returns rows when I convert it to UPPER.