15.00 - Teradata SQL Assistant for Microsoft Windows User Guide - SQL Assistant

prodname: SQL Assistant
vrm_release: 15.00
category: User Guide
featnum: B035-2430-034K

Preface
Audience
Supported Releases
Prerequisites
Changes to this Book
Additional Information
Product Safety Information
Chapter 1 Getting Started
Introduction
What is Teradata SQL Assistant?
How Teradata SQL Assistant Works
Teradata SQL Assistant Features
Defining a Data Source
Defining an ODBC Data Source
Defining a .NET Data Provider for Teradata Data Source
Defining a .NET Data Provider for Oracle Data Source
Starting Teradata SQL Assistant
Connecting to and Disconnecting from a Data Source
Connecting to an ODBC Data Source
Connecting to .NET for Teradata
Connecting to .NET for Oracle
Connecting to Multiple Data Sources
Re-Connecting to a Data Source
Displaying a Color Bar in the Query Window
Changing the Database Password
Main Window
Menu Bar
Hiding Toolbars
Using the Status Bar
Tabbing Windows
Cascading Windows
Tiling Windows
Arranging Windows
Changing the text size in a child window
Using Online Help
Using Shortcut Menus and Commands
Database Explorer Tree
Viewing Object Types
Opening and Closing the Database Explorer Tree
Navigating to the Database Explorer Tree
Changing the Width of the Tree Area
Moving the Explorer Tree Window
Dragging Object Names to the Query Pane
Dragging Multiple Objects
Using Quick Paste
Adding Double Quotes around Object Name
Adding Object Types
Displaying Object Definitions
Displaying Data Source Information
Generating SQL for use with an Object
Editing Table Data
Working with the Edit Table Dialog Box
Adding Databases
Removing Databases
Refreshing the Database Explorer Tree
Displaying the Shortcut Menu
Setting Database Tree Preferences
Favorites and Examples Pane
Opening and Closing the Favorites Pane
Navigating to the Favorites Pane
Changing the Width of the Favorites Pane
Moving the Favorites Pane Window
Listing All Tables or Views In a Database
Listing All Columns In a Table or View
Setting General Program Preferences
Setting Default File Paths
Using Page Setup
Using Print Preview
Support for Unicode® and UTF-8
Displaying Unicode® Data
Exporting Unicode® Data
Importing Unicode® Data
Support for the Visually Impaired
Text Size
Color scheme
Audible support
Limitations
General Teradata Limitations
Teradata.NET Specific Limitations
Oracle.NET Specific Limitations
ODBC Specific Limitations
Chapter 2 The Query Window
Introduction to the Query Window
Using the Query Window
Using SQL, DDL, and DML Statements
Displaying the Query Window Toolbar
Allowing Multiple Queries
Splitting the Query Window into Two Windows
Selecting Text and Inserting Bookmarks Using the Query Window Margin
Creating Statements (Single and Multi)
Parameterized Queries
Magnifying the Query Window
Setting Query Options
Setting Code Editor Options
Entering and Executing Queries
Entering a Query
Using Conditional Logic in a Query
Outlining
Using Code Completion
Displaying Function Descriptions
Inserting Function Templates
Customizing Code Completion Lists
Executing a Query
Using Transactions
Running Multiple Queries
Executing Multiple Statements in Parallel
Submitting Part of a Query
Aborting a Query in Progress
Executing a Query Saved To a File
Automatically Minimizing the Teradata SQL Assistant Window
Renaming a Query Tab
Deleting a Query Tab
Working With SQL Text in the Query Window
Copying SQL from Previous History Record to the Query Window
Copying SQL from Next History Record to the Query Window
Preventing Queries from Being Saved in the History Window
Undoing or Redoing Query Window Changes
Setting Repeat Count
Recording and Executing Query Window Macros
Saving a Query
Performing a Quick Save
Adding a Query to Favorites
Opening a Query from a File
Copying a Query to Notepad
Printing a Query
Adding Comments to Queries
Highlighting a block of Text
Showing Whitespace
Converting Tabs to Spaces
Indenting Lines in a Query
Using the Right-to-Left Editor for Queries
Deleting Blank Lines from a Query
Finding a Text String in the Query Window
Replacing a Text String in the Query Window
Displaying an Explain Plan of a Query
Displaying a Visual EXPLAIN Plan
Displaying a Textual EXPLAIN Plan
Query Builder Overview
SQL Statements
Procedure Builder
<User Defined>
Using Query Builder
Supported Databases for Query Builder
Creating Custom SQL Sets
Scheduling Queries for Later Execution
Before Scheduling Queries
Scheduling Queries for Later Execution
Formatting a Query
Indentation
Language Definition Files
Importing Data
Before You Begin
Importing Data from a File
Exiting from Import Mode
Types of Import Operations
Import Rules
Defining the Null Value for an Import Operation
Generating Multiple Reports From a Single Query
Using the Query Window Shortcut Menu
Displaying the Shortcut Menu
Functions in the Query Window
Chapter 3 The Answerset Window
Introduction to the Answerset Window
Using the Answerset Window
Viewing Your Results
Adjusting Row Height
Adjusting Column Width
Re-arranging Column Order
Keeping Selected Columns From Scrolling Out of View
Viewing Long Strings of Text Within Cells
Closing Answerset Windows Before Submitting a New Query
Selecting All Answerset Rows
Merging Cells in the Answerset
Displaying the SQL That Generated an Answerset
Hiding Columns/Showing All Columns
Closing All Answersets
Hiding Column Headers
Hiding Row Headers
Displaying Totals for Numeric Columns
Displaying Aggregate Values
Finding a Text String in the Results Grid
Naming an Answerset Window
Naming an Answerset Tab
Deleting an Answerset Tab
Opening a Saved Answerset
Saving an Answerset to a File
Saving as XML
Copying an Answerset to Notepad
Printing an Answerset
Using Print Preview
Cancelling Print Jobs
Sorting an Answerset
Filtering the Answerset
Grouping the Answerset
Setting Answerset Options
Setting Data Format Options
Changing the Font for the Entire Window
Zooming the Answerset Window
Charting Answerset data
Working with Charts
Formatting an Answerset
Formatting a Block of Cells
Formatting a Single Cell
Formatting a Single Row or Column
Formatting Multiple Rows or Columns
Formatting the Entire Spreadsheet
Displaying Commas to Mark Thousand Separators
Displaying Numbers in Scientific Notation
Displaying Decimal Places
Exporting a Resultset
Exporting Results
Single-Clicking to Display the Export File
Saving Multiple Answersets
Exporting to Access - Formats and Data Types
Setting Export/Import Options
Setting Export Options
Setting Import Options
Understanding Large Object Support
Using Answerset Shortcut Menus
Displaying the Shortcut Menu
Chapter 4 The History Window
Introduction to the History Window
The Columns of the History Window
Using the History Window
Opening the History Window
Closing the History Window
Viewing the Result Message
Viewing DBS Error Messages
Viewing the History Rows
Rearranging History Columns
Filtering the History Rows
Copying SQL from Previous History Record to the Query Window
Copying SQL from Next History Record to the Query Window
Selecting All History Rows
Sorting the History Records
Finding a Text String in the History Table
Cleaning up the History table
Magnifying the History Window
Setting History Window Options
Editing History Records
Displaying and Navigating the Edit History Dialog Box
Editing a History Record
Compacting History
Adding or Change a Note in a History Record
Saving, Copying, and Printing History
Saving History Rows
Copying Rows to the Clipboard
Copying Rows to Notepad
Printing the Contents of the History Window
Cancelling Print Jobs
Storing History Files
Changing the Location of History Files
The History Window Shortcut Menu
Displaying the Shortcut Menu
Appendix A Startup Parameters and Default Preferences
Startup Parameters
Default Preferences (Options)
Miscellaneous and General Default Preference Settings
Query Default Preference Settings
Code Editor Tab Default Preference Settings
Data Format Tab Default Preference Settings
Answerset Tab Default Preference Settings
Export/Import Tab Default Preference Settings
History Tab Default Preferences and Descriptions
Database Tree Default Preferences and Descriptions
File Paths Tab Default Preference Settings
Page Setup Default Preferences and Settings
Appendix B Menus, Toolbars and Shortcuts
Using Toolbars and Buttons
The Main Toolbar
The Answerset Toolbar
The Query Toolbar
Toolbar Button Descriptions
Customizing Menus and Toolbars
Adding a Command to a Menu or Toolbar
Menu Commands Only
Removing a Command from a Menu or Toolbar
Moving a Command
Adding or Removing a Break Between Commands
Changing the Name for a Command
Assigning or Changing a Keyboard Shortcut
Changing Menu Behavior
Showing Recently Used Commands First
Resetting the Default Menu Bar
Hiding the Toolbars
Showing or Hiding Toolbar Screen Tips
Adding, Removing, Renaming, or Resetting a Toolbar
General Command Shortcut Keys
Query Specific Shortcut Keys
Window Control Shortcut Keys
Answer/History Specific Shortcut Keys
Appendix C Configuration Files
UserOptions.config
Toolbars.config
DataSources.config
DockMgr.config
Vendors.config
Glossary

Back to home page