first of all I'm a beginner. I created a script with an ORACLE ODBC connection and all the selected column are written in capital letters ( for example
"SUPPLIER_CODE"). If I change the odbc connection to an SQL SERVER, my script doesn't work: I have to change all the columns names in small letters and the script works fine again.
Does anybody knows if there is a workaround or I have to write two scripts, one for ORACLE and another one for SQL SERVER ?