Category
主题
Book
Installation Guide > About Setting Report Properties
You can set properties for the report, a band, or a control in this page. ... You can define additional properties, based on the item selected from a set of links near the bottom of the control.
Release Notes > Set Code Regions
You can define regions in your code that can be expanded or collapsed for easier navigation. ... To add a code region ... Enter the following on the line above the beginning of the statement: ... -- region region_name
Installation Guide > Create Cross-Connection Queries
Use the Cross-Connection Query Builder or the Cross-Connection Editor to create a query that combines data from multiple, dissimilar databases. ... For example, you can create a query that joins managers from a SQL Server database to their employees in an Oracle database.
Release Notes > Automation and Executing Scripts
In this tutorial, you will build a script that uses the Execute Script activity to run a small SQL script prior to executing other database activities. ... In this tutorial you will learn: ... An Import Wizard template (configured to import a table into the sample database)
Release Notes > Create SQL Server Connections
You can create a new connection, or connect to an existing connection from the Create New Connection window. ... To be able to utilize majority of Toad functionality please grant VIEW DEFINITION on the SQL Azure databases you want to work with.
Installation Guide > Search for Objects
You can quickly locate an object rather than browsing through a list of objects in the Database Explorer orObject Explorer. ... Names of objects for a string. ... Text in objects that include source code, which typically includes procedures, functions, triggers, data types, and views.
Release Notes > Execute SQL
Use one of the following methods to execute SQL: ... To execute all statements, in order, one at a time, click or press F5. ... To execute the current statement, click or press F9. ... To execute the code within a code Region
Installation Guide > Creating New Language Templates
You can create templates for additional languages that you frequently edit. ... Create a new XML file that contains the following code: ... <? ... xmlversion="1.0" encoding="utf-8"?> ... </CodeTemplate>
Installation Guide > Use System Automation Activities
You can use the following activities in automation scripts. ... Tip: You can save an activity and its settings as a template to reuse in other scripts. ... Right-click the activity in the design window and select Save As Template.
Installation Guide > Using Variables in Automation
Automation variables are a powerful tool that can greatly extend your scripts. ... Variables can add flexibility and customization. ... Variables can be used in almost every Automation activity. ... See Automation and Variables for a tutorial on how to use variables in Automation.
Installation Guide > Grid Options
Review the following for additional information: ... Displays a panel that allows you to group data columns. ... Automatically resizes data columns to maximize the amount of data that displays. ... Maximum rows to process
Installation Guide > Get a Published Toad Document
With Toad you can edit a Toad document stored in Toad Intelligence Central (TIC) and then re-publish the Toad document back to the same TIC instance. ... To edit a Toad document stored in TIC, you must have Manage privileges to the object.
Installation Guide > Publish Generic Files to TIC
This allows you to share not only scripts and Toad documents but also their supporting files. ... You can also use this method to publish Toad documents as generic files. ... However, the best way to publish a Toad document is to open the document and click Publish File in the Wizard bar.
Release Notes > User Authentication in Intelligence Central
Toad Intelligence Central (TIC) allows users to access remote databases and other remote sources that typically require a user login ID. ... To facilitate this, each data source connection in TIC must have a login ID to use when accessing its remote data source.
Release Notes > Complete SQL Statements Automatically
Code completion (autocompletion) assists you when entering SQL by automatically displaying a list of objects from which you can select in order to complete parts of your SQL statement. ... Code completion is available in the SQL Editor, as well as other editor windows, such as the Query tab in the Query Builder.
Release Notes > Object Explorer
You can view database objects for the current connection with the Object Explorer. ... This feature is useful for dragging and dropping database objects into an open Editor, Query Builder, or other document window.
Release Notes > Advanced Job Options
Review the following for additional information: Maximum number of threads ... Specify the maximum number of total concurrent threads to use on target instances to run the jobs. ... Default: 3 ... Maximum appointments
Installation Guide > Troubleshoot Publishing to Toad Intelligence Central
Use this section to troubleshoot publishing errors. ... This error may occur if the connection's authentication token is expired. ... Solution: In the Publishing dialog, click the Authentication link, then click Reauthorize to re-enter your credentials and grant access to Toad.
Installation Guide > System Requirements
Before installing Toad, ensure that your client system meets the following minimum hardware and software requirements: ... These features start processes (mysqld.exe, hubproxy.exe) which persist for the Toad session.
Installation Guide > Troubleshoot Excel Issues
Review the following to help troubleshoot and solve issues involving Excel files. ... Tables are limited to 256 columns and 65536 rows. ... This is a known limitation with Excel worksheets. ... Column names longer than 64 characters are truncated and the remaining characters display as null.
Installation Guide > Visualize Data
The Data Visualization tool helps you to quickly extract important information from large data sets by providing a way to visually analyze the data. ... Data Visualization creates a multi-layered, interactive graphic report by converting columns to dimensions or measurements.
Release Notes > Automate Toad Pivot Grids
This tutorial demonstrates how to create a Toad Pivot Grid file and how to use Automation to refresh the pivot grid and generate a report. ... In this tutorial you will learn: ... A pivot grid is a great way to display a summary of your data.
Installation Guide > Change Passwords for Intelligence Central Objects
If your Windows Authentication or other data source user account password changes, you may need to update the password in objects that were published from that data source to Intelligence Central.
Installation Guide > Execute Automation Scripts
You can execute automation scripts on demand from the Automation window or the Project Manager. ... You can also schedule scripts to run on a recurring basis at a specific time. ... For example, schedule a script that performs long-running tasks to run when database activity is light.
Installation Guide > View Result Sets
The Result Sets tab displays a data grid for executed SQL statements and scripts that return data. ... You can easily review all (or the selected Result sets) in one Result Sets tab. ... Left-click and hold Shift or Ctrl to select more than one Result sets of your script.
新产品关联性