Looks like Toad doesn't recognize the QUALIFY clause of Teradata's SQL flavour and when I apply formating to the SQL statement it's considered as part of the previous one, also the semicolumn of the statement gets removed. Ex. SQL1 ....;SQL2 with qualify;SQL3 ....;After applying format:SQL1....;SQL2SQL3;Using TDP 3.2
I've attached screenshots. Please notice the "QUALIFY" keyword is not colored in blue, hence not recognized as a keyword.
Message was edited by: veskojl
I'm using the default format and haven't customized it.