For Sybase procedures, use the query below in passthru mode against the Sybase server.
对于Sybase过程,按passthru模式对Sybase服务器使用以下查询。
Note: There are many more records in the result set for sp_tables on this Sybase server in this database.
注意:在该Sybase服务器上的数据库中,sp_tables 的结果集中还有许许多多的记录。
The administrator needs to edit the xa_config file, grant privileges to the user for use of the Sybase LRM, and configure the server for distributed transaction management.
管理员需要编辑xa_config文件,将特权授予使用SybaseLRM的用户,并为分布式事务管理配置服务器。
Remember, the Sybase database name where the stored procedure was located is part of the WebSphere Information Integrator server definition.
记住,存储过程所在的Sybase数据库的名称是DB 2 II服务器定义的一部分。
For instance, the name of the database, its type and version (for example, Oracle 8, Sybase 11.9) are registered in the Information Integrator catalogs when a server is created.
例如,创建服务器时,数据库的名称、类型和版本(如oracle8、Sybase 11.9)都会在Information Integrator编目中注册。
S Sybase12_5: 'Sybase12_5' is the entry in the local Sybase interfaces file for the Sybase ase server we are connecting to.
s Sybase12_5:Sybase12_5是本地sybase接口文件中关于我们要连接到的Sybasease服务器的条目。
We will use isql (which comes with Open Client) to connect to the Sybase ASE server, which is on a system called viper.
我们将使用isql (OpenClient 自带)来连接到SybaseASE服务器,该服务器位于一个名为 viper 的系统上。
NODE 'Sybase 12_5' -- This matches the name of the Sybase ASE server in the interfaces/sql.ini file here on the WebSphere Information Integrator system.
NODE'Sybase12_5'—— 该名称与 DB2II系统上 /sql.ini接口文件中的 SybaseASE服务器的名称相匹配。
The Sybase Open Client has been configured to connect to the Sybase ase server that has the stored procedure we wish to access.
SybaseOpenClient已经配置为连接到我们要访问的存储过程所在的Sybasease服务器。
D DJ: 'DJ' is the name of the database on the Sybase ase server that we are accessing.
—ddj:' dj '是Sybasease服务器上我们要访问的数据库的名称。
Version 12.5 — This is the version of the Sybase ase server.
VERSION 12.5——sybasease服务器的版本。
You must create a server definition in the federated Q Apply server for each Oracle or Sybase database that will be a replication target.
您必须在联邦QApply服务器中,为将成为复制目标的每个Oracle或Sybase数据库创建一个服务器定义。
The join on the MSSQL server source will begin when the one on the Sybase source is complete and has delivered its entire result set to the federated server.
当sybase数据源上的连接执行完毕并且已经将整个结果集提交给联邦服务器时,MSSQLServer数据源上的连接开始执行。
where 'sybase12_5' is the name of the Sybase ASE server in the interfaces file that is also on that server.
添加一个名为 'local'的服务器,其中'sybase12_5'是SybaseASE服务器在接口文件中的名称,该接口文件也位于那台服务器上。
Story Server stores content and graphic elements in a Sybase database, and as visitors request a page the content is "poured" on the fly into design templates.
StoryServer在Sybase数据库里存储内容和图像元素,当访问者请求一个页面时内容能快速填充到设计的模板里。
Sybase and Microsoft SQL Server procedures that return a result set always return 0 as the integer return status, the actual status value is ignored.
返回结果集的Sybase 过程总是返回0作为整数返回状态,实际的返回状态值被忽略。
This is not necessary (and not even supported) for Sybase, Microsoft SQL Server, DB2(LUW, z/OS, iSeries) procedures.
对于Sybase过程,这是不必要的(也不支持)。
IFILE 'c: \ Sybase \ ini \ sql.ini' — We specify the location of the interfaces file via this Server option.
IFILE'c: \Sybase \ini \ sql .ini '——我们通过该Server选项来指定接口文件的位置。
Use of native DB2-like operator, where possible, for Sybase and SQL Server translations for improved performance.
尽可能为Sybase和SQLServer转换使用本地类DB 2操作符,以提高性能。
For example, we have a table that is declared as follows in Sybase or SQL Server database.
例如,我们有一个表,它在Sybase或SQLServer数据库中的声明如下。
Initially, this capability is available for remote Oracle and Sybase databases, with support for others (including MS SQL Server and DB2) to follow.
一开始,该功能只能用于远程Oracle和Sybase数据库,随后陆续支持其它数据源(包括MSSQLServer和DB2)。
Initially, this capability is available for remote Oracle and Sybase databases, with support for others (including MS SQL Server and DB2) to follow.
一开始,该功能只能用于远程Oracle和Sybase数据库,随后陆续支持其它数据源(包括MSSQLServer和DB2)。
应用推荐