Eclipse / Teradata Studio Express Code Assist

Tools & Utilities

Eclipse / Teradata Studio Express Code Assist

Hi all,

i have a problem with the Code Assist in Eclipse and Teradata Studio Express. 

--Work correctly 

select * from db.table where db.table.

-Doesn't work

select * from db.table as a where a.

Have anybody in idea how to fix that? The settings in Eclipse are OK i think. All options at "Preferences/Data Management/SQL Development/SQL editor/Code assist" are checked. Are there settings on other places that have to be modified?

Best regards Johannes

2 REPLIES
Teradata Employee

Re: Eclipse / Teradata Studio Express Code Assist

The code assist doesn't deal with such aliases as your second statement contains. It basically understands what types of database objects (tables, columns, etc.) are valid at the insertion point. It offers choices of names of such objects that are contained in the database object whose name is before the dot. 

The editor doesn't maintain the semantic meaning of tokens such as your "a" that are defined only in the context of the SQL statement. It only deals with objects defined within the database. There are no settings to make that will make the editor's code assist deal with aliases.

Re: Eclipse / Teradata Studio Express Code Assist

Thanks chuckbert. That aren't good news!