All Forums Teradata Studio
gloxton 2 posts Joined 05/14
15 Jun 2016
Code Assist functionality questions

I have been asked a number of questions about Code Assist, and wanted to know if anyone knows of any additional insight into its functionality before I respond with the results of my testing:
1. Does the user have to code "DatabaseName." to get a list of tables?
    - from my testing the answer is Yes apart from tables in the default schema
2. Does the user have to code "DatabaseName.TableName" to get a list of Columns?
    - from my testing the answer is Yes
3. Can alisas be used to get a list of Columns?
    - from my testing the answer is No
4. Can the Code Assist dropdown list of functions be edited? (e.g. to remove the less performant functions such as LENGTH )
5. Also, is there a way of disabling the Run in Background button when a query is being run?
 
 

fgrimmer 553 posts Joined 04/09
15 Jun 2016

Greg, You are correct in your answers (1, 2, 3). As you have discovered, the code assist is trigger by a pause or Ctrl+SPACE or when entering a 'dot' on a SQL object in your SQL statement. The list of syntax words is generated internally from three places: 1) the grammar returns the list of 'next' words 2) the scope for the SQL object you have entered the 'dot' at and 3) the list of templates supplied for Teradata, Aster, or Hadoop, if entered Ctrl+SPACE at the beginning of the statement. 
Question 4) Can the list be edited? No, not currently.
Question 5) Yes. This is in your preferences. Bring up the Preferences dialog (Window>Preferences). If you enter the work 'background' in the search field the General page is provided. Click on that page and there is a checkbox 'Always run in background' that you can uncheck.

gloxton 2 posts Joined 05/14
16 Jun 2016

Many Thanks for this Francine.
In regards to Question 5, unchecking 'Always run in Background' just seems to stop this automatically running in the backgorund. The question I had was whether there was the ability to disable the "Run in Background" option that appears in the SQL select execution display that pops up when the query is running (and also allows you to cancel the query). This would be to prevent users to ever being able to run queries in the background.

fgrimmer 553 posts Joined 04/09
16 Jun 2016

Nothing currently to stop it. But we are working on a new Query Manager and I think it will change this behavior.

Dan95 2 posts Joined 08/16
09 Aug 2016

Hi,
I have some problem with code completion, when writting database. i'm not getting a list of table. Is it working on teradata studio express v15.11 ?
Thanks a lot,
Dan

fgrimmer 553 posts Joined 04/09
09 Aug 2016

There is a menu option in the top level SQL Mmenu to toggle on Code Assist Autoactivation. It may be untoggled.

You must sign in to leave a comment.