ReadVitamin

How to display multiple Answerset windows in SQL Assistant.

Written by admin in Monday, October 1st 2007 under IT

If you are new to Teradata SQL Assistant and would like to see your query results appear in multiple answerset windows rather than getting overwritten. Here is a way to do it.

1) Click on Tools.

2) Click on Options.

3) Click on the ‘General’ tab.

4) Off the 4 check box options, select the following:

a. Allow Multiple Queries

b. Close Answerset windows before submitting a new query.

5) You would also see a set of radio button choices with the following label:

a. User Separate Answerset Windows for

i. Each Resultset.

ii. Each Query

iii. Never

6) Choose “Each Resultset”.

7) Click OK.

Submit the following two queries with semicolon present at the end of 1^st query.

a. select date;

b. select time

The result set would be displayed in two separate windows.

In this “General” tab, you can also specify the string you want to display when a NULL data appears (by default it is ‘?’). Look for the label “Display this string for Null data fields” and put your favorite word in the text box present next to it.

Popularity: 4% [?]