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.

Our Random Articles

• Somdev Devvarman ousts Xavier Malisse 6-1, 3-6,7-6(5)
• How To Choose A Good Online Traffic School
• New Year Wishes 2010
• New Year Wishes
• How to use EXTRACT function with date and time columns

More Links