Toad World® Forums

DB2 not include Table Alias


I am using Toad for Data Analyst and I am connecting to db2 via an odbc connection. The connection does not require that the library be specified so when I use the sql diagram it always puts it on the query or in the viewer you can not run a sample query of the data because it is specifing the library and table on the field. Is there an option to fix this.


I assume you are trying to use the Query Builder. If so, you can go to Tools -> Options and then look for Database -> Query Builder in that dialog and uncheck “Use fully qualified object names”. Please let me know if that helps.