This should change the session mode in SQL Assistant from ANSI to Teradata, but that may not work since the ODBC Driver may have been updated while SQL Assistant was not. (You need to be in Teradata mode to ignore duplicate rows.) Try Teradata Studio. The means of changing mode varies with the tool. I have not tried it myself, but apparently in Studio the method is: "To change the TMODE property, press the Add button and select the property TMODE. Choose the propert..."