Sybase
n. 赛贝斯公司(美国数据库产品公司)
2025-11-25 04:37 浏览次数 14
n. 赛贝斯公司(美国数据库产品公司)
setenv SYBASE安装目录
Sybase VLDB海量数据库系统
add SYBASE增加sybase服务名称
Sybase IQSybase IQ is a column-based, relational database software system used for business intelligence, data warehousing, and data mart Produced by Sybase In
Sybase Corporation赛贝斯公司
Oracle sybase数据库
Sybase Classic赛贝斯精英赛
Sybase ASA数据库
Sybase Inc赛贝斯软件有限公司
Sybase database users very frequently create stored procedures for many different purposes.
Sybase数据库用户常常出于不同的目的创建一些存储过程。
This could occur if the Sybase existing table definition specifies a column length that is too short for values in the column of the stored procedure's result set.
如果sybase现有表定义指定了一个列的长度,但是这个长度对于存储过程结果集中这一列的值来说太短了,就会发生这种错误。
To create an Oracle or Sybase wrapper, use one of the following methods.
为了创建Oracle或Sybase包装器,要使用下列方法之一。
To create a user mapping for Oracle and Sybase targets, use one of the following methods.
要为Oracle和Sybase目标创建用户映射,使用下列方法之一。
Figure 1 illustrates the WebSphere Information Integrator nickname, Sybase existing table and stored procedure relationship.
图1说明了DB 2 II昵称、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作为整数返回状态,实际的返回状态值被忽略。
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)都会在InformationIntegrator编目中注册。
If other WebSphere Information Integrator users will need to access the Sybase stored procedure, additional user mappings will be required for them.
如果其他DB 2 II用户需要访问sybase存储过程,则需要为他们进行附加的用户映射。
However, competitive vendors like Oracle, IBM and Sybase may argue developers want this level of power and configuration and they are provided it through the use of virtual machines.
然而,竞争厂商——像Oracle、IBM和Sybase——可能认为开发者想要得到这个级别的能力和配置,不过他们是通过使用虚拟机来提供的。
Note on this example of logging into Sybase ase.
关于这个登录到Sybasease的示例的注解。
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数据源上的连接开始执行。
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数据库创建一个服务器定义。
DJ — the Sybase database name where the stored procedure is defined.
dj——定义存储过程时所在的Sybase数据库的名称。
To create a server definition for an Oracle or Sybase data source.
为了为Oracle或Sybase数据源创建服务器定义,要。
Remember, the Sybase database name where the stored procedure was located is part of the WebSphere Information Integrator server definition.
记住,存储过程所在的Sybase数据库的名称是DB 2 II服务器定义的一部分。
The stock broker firm also has the following Sybase procedure defined.
这家股票经纪公司还定义了以下sybase过程。
Sybase cursor parameters are not supported.
不支持Sybase游标参数。
Since I knew SQL, I got to work on projects using Oracle and Sybase databases, which were growing much more popular in the world than our own database product.
因为我了解SQL,所以我测试了使用Oracle和Sybase数据库的项目,这些都比我们自己的数据库产品在市场上更受欢迎。
A nickname needs to be created for the Sybase existing table that USES the stored procedure.
要使用存储过程的Sybase现有表,则需要为之创建一个昵称。
Sp_tables is a Sybase ase Catalog Stored Procedure.
sp _ tables是一个Sybasease编目存储过程。
Federated procedure SYBSTOCKQUOTE is created for the remote Sybase procedure that takes the stock name and the date as an input parameter as.
对于以股票名称和日期作为输入参数的远程sybase过程,创建的联邦过程sybstockquote如下。
A Sybase existing table is created for the stored procedure.
为该存储过程创建了一个Sybase现有表。
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的用户,并为分布式事务管理配置服务器。
The solution had to work with Sybase at rollout, but be able to migrate to DB2 without any client-side code changes.
该解决方案必须在输出端使用Sybase,但能够迁移到DB 2而无需对客户机端的代码进行任何更改。
Note: There are many more records in the result set for sp_tables on this Sybase server in this database.
注意:在该Sybase服务器上的数据库中,sp_tables 的结果集中还有许许多多的记录。