Toad Data Point 5.3 - User Guide

Converse agora com nosso suporte

Determine the Best Method to Locate Objects Object Explorer Filter Databases and Objects Understand a Table Using the Database Explorer Search for Objects Create an Database Diagram to Use as a Query Template Browse Data in Related Tables

Query

Tutorial: Build a Query Visually Create Cross-Connection Queries Reverse Engineer Queries Build a Subquery Edit SQL Editor Shortcut Keys View Result Sets Compare Differences in Data Export Data with One Click Export Share Excel Linked Queries

Report

Tutorial: Create a Toad Data Report Manage Reports

About Managing Reports DB2 Reports MySQL Reports ODBC Reports Oracle Reports SQL Server Reports

Publish and Share Reports

Automate

Getting Started with Automation Tutorial: Automate Excel Reports Automate Tasks Use Database Automation Activities Use File Automation Activities Use System Automation Activities Use Variables In Automation Execute/Schedule Automation Scripts

Considerations and Limitations when Transforming Data

Review the following considerations and limitations when using the Transform and Cleanse tool.

Consideration/Limitation	Description
ODBC connections: Query using bind variable is not supported	When using an ODBC connection, you cannot send a query that contains a bind variable to the Transform and Cleanse tool. Workaround: Use a value instead of a bind variable in your query before sending the query or data grid results to the Transform and Cleanse tool. This limitation applies to ODBC connections only.

Consideration/Limitation

Description

ODBC connections: Query using bind variable is not supported

When using an ODBC connection, you cannot send a query that contains a bind variable to the Transform and Cleanse tool.

Workaround: Use a value instead of a bind variable in your query before sending the query or data grid results to the Transform and Cleanse tool. This limitation applies to ODBC connections only.

Selecione seu produto:

Para podermos atendê-lo melhor, informe o Propósito de seu chat:

Soluções recomendadas para seu problema

Toad Data Point 5.3 - User Guide

Considerations and Limitations when Transforming Data