New Features in version 5.1.x
Version 5.1.7
New Features in version 5.0.x
Toad Workbook
report building process.
your database query and refine the result set. The result steps that you create using SQL Editor or Query
Builder is used by all steps of the workflow. Once you are happy with your result you can output it to several
locations at once or create reports in various formats.
work with them later and share reports easily using email.
You start by building your result set in Query Builder or Editor. Modify and refine your results using great Toad
features like Transformation & Cleanse, Pivot Grid or Dimensional View. Output your results easily with a click
to your local storage, TIC or present them as a PDF report or Excel or CSV spreadsheet.
your workflow you will be asked to save your result set. After the result set is saved, it can be dragged into
another Query Builder to join the two result sets.
Query Development
Easily Specify the Number of Rows to Fetch
You can now specify the number of rows to initially retrieve when executing a query in the SQL Editor or the
Query Builder. The query retrieves the specified number of records and then pauses (Oracle) or stops (other
platforms). When you scroll through the Results grid, additional records are retrieved on demand (Oracle) or
through re-execution (other platforms).
Data Management
Data Profiling
You can now specify default values for some options used in the Data Profiling tool. The default values are used
in new Data Profiling sessions. You can override the default values at the session level.
Automation
New Run Mode Variable
A new variable has been added to Automation: the Run mode variable. This string variable is created by the
script and can be found in the script Settings. The value assigned to this variable is either Test or Production,
depending on the environment selected in the script Settings at the time the script is executed.
FTP Activity
You can now instruct the FTP activity to retry the FTP connection if it fails. Specify the number of retries and
a wait time.
Copy File Activity
You can now instruct the Copy File activity to retry the copy action if an error or timeout occurs. Specify the
number of retries and a wait time.
Run Program Activity
You can now use the Root path variable (ROOT_PATH) in the Program and Run directory fields in the Run
.
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center