Chapter 2 Using OLE DB Provider for Teradata - OLE DB Provider for Teradata

OLE DB Provider for Teradata User Guide

Product
OLE DB Provider for Teradata
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2498
Product Category
Teradata Tools and Utilities

This chapter describes how to design an application program that interfaces with OLE DB Provider for Teradata to access and use a Teradata Data Warehouse.

For installation instructions, see Teradata Tools and Utilities for Microsoft Windows Installation Guide, B035-2407-mmyx.

 

This chapter includes the following topics:

  • Connecting to Teradata Database
  • Connecting Directly to Teradata Database
  • Single Sign On
  • Password Encryption
  • Connecting Using Teradata Connection Dialog
  • Connecting Using IDBPromptInitialize Interface
  • Connecting Using PromptDataSource
  • Connecting to a Data Source Using the PromptFileName Method
  • Setting Provider String Attributes
  • Changing Data
  • Comparing DML with IRowsetChange/IRowsetUpdate
  • Large Objects (LOBs)
  • User-Defined Functions (UDFs)
  • User-Defined Types and User-Defined Methods
  • BIGINT and Large DECIMALs