Introduction

IBM® InfoSphere® DataStage® provides several ways to access Sybase databases. The following topics provide an introduction to the stages that access Sybase databases. Later topics cover installation instructions and configuration information.

With the InfoSphere DataStage, you can load tables in Sybase databases and read data from tables in Sybase databases. This guide describes how to use

• Sybase OC stages
• Sybase BCP stages
• Sybase Enterprise stages
• Sybase IQ12 Load stages

in the InfoSphere DataStage server jobs.

These connectivity stages are installed automatically when you install the InfoSphere DataStage. They appear in the Database category on the server job palette.

Although these topics contains several stages specifically designed to access Sybase databases, you can also access them by using the following stages:

• Dynamic Relational Stage (DRS)

  Use this stage to create a job that requires one relational database at design time and another at runtime. For more information about this stage, see the Connectivity Guide for the Dynamic Relational Stage.

• Stored Procedure (STP)

  Use this stage to include Sybase stored procedures as part of your InfoSphere DataStage job. For more information about this stage, see the Connectivity Guide for the Dynamic Relational Stage.