Appendix A Target Types

Sybase Targets

All Sybase targets use the Sybase JDBC driver called jConnect. Because Sybase jConnect is provided with Application Integrator and Jaguar, you do not need to register it with the Component Builder.

This section contains information about the following Sybase targets that are supported in the Component Builder:

Adaptive Server Anywhere

Components that invoke Sybase Adaptive Server Anywhere (ASA) stored procedures use connections of the type Sybase ASA. You must provide the following values to create a Sybase ASA connection

Table 3-1: Sybase ASA connection information
Information required	Valid values
Host Name	Name of the machine running ASA.
Port Number	Port number that ASA is listening on.
Database	Database the connection accesses. This database is optional. If you do not specify a value, the connection will access the default database for the specified user name.
User Name	User name for ASA.
Password	User password for ASA.

For Sybase ASA, methods can be created automatically and can use any of the following statement types:

Callable Statement
Prepared Statement
Statement

Sybase ASA does not return information about whether parameters can accept null values when methods are created automatically. Method parameters for ASA stored procedures are set to not nullable by default.

Adaptive Server Enterprise

Components that invoke Sybase Adaptive Server Enterprise (ASE) stored procedures use connections of the type Sybase ASE. You must provide the following values to create a Sybase ASE connection

Table 3-2: Sybase ASE connection information
Information required	Valid values
Host Name	Name of the machine running ASE.
Port Number	Port number that ASE is listening on.
Database	Database containing the target stored procedure. This value is optional. If it is not specified, the connection accesses the default database for the specified user name.
User Name	User name for ASE.
Password	User password for ASE.

For Sybase ASE, methods can be created automatically and can use any of the following statement types:

Callable Statement
Prepared Statement
Statement

Sybase ASE does not return information about whether parameters can accept null values when methods are created automatically. Method parameters for ASE stored procedures are set to not nullable by default.

DirectConnect

Sybase DirectConnect gateways provide access to heterogeneous data sources. This section includes information on creating Application Integrator components that access procedures through DirectConnect.

Components that access DirectConnect use connections of the type Sybase DirectConnect. The following values are needed to create a connection:

Table 3-3: Sybase DirectConnect connection information
Information required	Valid values
Host Name	Name of the host machine running DirectConnect.
Port Number	Port number DirectConnect is listening on.
Service Name	Name of the DirectConnect service that the connection accesses. When the connection is created, the Component Builder sets the jConnect SERVICENAME property to the value you specify.
User Name	User name for DirectConnect.
Password	User password for DirectConnect.

Currently, you must manually create methods for DirectConnect target stored procedures. When you create methods manually, the best source of information for defining the method correctly is the source code for the target stored procedures.