Toad Data Point 5.3 - User Guide

立即与支持人员聊天

获得即时帮助
完成注册

登录

请求定价

联系销售人员

Welcome to Toad Data Point Understand Toad's Workflow

Create ODBC Connections Create Oracle Connections Create SQL Server Connections Understand Toad Connections Troubleshoot SQL Server Connections

Understand

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.

请选择您的产品：

为向您提供更好的服务，请填写'Purpose of your Chat'（联系目的）：

针对您的问题建议的解决方案

Toad Data Point 5.3 - User Guide

Considerations and Limitations when Transforming Data