When I generate any script using a where clause; it returns all rows whether they meet the criteria of my where clause or not.
1. Create a native connection directly to SQL server in stead of ODBC. OR
2. Create an ODBC connection with Data Source: IBM DB2 ODBC DRIVE - TACOMzz
Note: zz is version of current used Toad for Data Analysts.