You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for Sybase


1 to 20 of 229 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Gateway for Sybase User's Guide, 11g Release 1 (11.1)

Database Gateway for Sybase User's Guide - Contents

ContentsDatabase Gateways 2 Sybase Gateway Features and Restrictions 2.1 Using the Pass-Through Feature 2.2 … Sybase 2.3.1 Chained Mode 2.3.2 Column Definitions 2.3.3 Naming Rules 2.3.3.1 Rules for Naming Objects … Feature 2.4.6 Sybase NCHAR and NVARCHAR Data Types 2.4.7 SQL Syntax 2.4.7.1 WHERE CURRENT OF Clause … Links 2.5 Known Problems

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Sybase

Multiple Sybase Databases Example: Accessing Sybase Datacreated, you can verify the connection to the new Sybase databases, as in the following: SQL> SELECT

Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX PA-RISC (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Sybase

3.8.5 Multiple Sybase Databases Example: Accessing Sybase Datacreated you can verify the connection to the new Sybase databases, as in the following: SQL> SELECT

Database Gateway for Sybase User's Guide, 11g Release 1 (11.1)

Data Dictionary

C.1.1 Sybase System TablesSybase data dictionary information is stored in the Sybase database as Sybase system tables. All … Sybase system tables have names prefixed with \"sys\". The Sybase system tables define the structure … of a database. When you change data definitions, Sybase reads and modifies the Sybase

Database Concepts, 11g Release 1 (11.1)

Information Integration

Oracle Database GatewaysDatabase Gateways to many sources, including Sybase, DB2, Informix, and Microsoft SQL Server. See

Database Administrator's Guide, 11g Release 1 (11.1)

Distributed Database Architecture

Heterogeneous Distributed Database Systemsinclude a Sybase database in an Oracle Database distributed system, then you need to obtain a Sybase

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Sybase

Multiple Sybase Databases Example: Configuring the GatewayChoose One System ID for Each Sybase Database A separate instance of the gateway is needed for each … Sybase database. Each instance needs its own gateway System ID (SID). For this example, the gateway … SIDs are chosen for the instances that access the Sybase databases: dg4sybs2 for the gateway … : HS_FDS_CONNECT_INFO=204.179.79.15:5000/db3

Database Gateway for Sybase User's Guide, 11g Release 1 (11.1)

Sybase Gateway Features and Restrictions

2 Sybase Gateway Features and RestrictionsAfter the gateway is installed and configured, you can use the gateway to access Sybase data, pass … Sybase commands from applications to the Sybase database, perform distributed queries, and copy data … Procedures and Functions Database Compatibility Issues for Sybase Known Restrictions Known Problems

Database Gateway for Sybase User's Guide, 11g Release 1 (11.1)

Sybase Gateway Features and Restrictions

2.4.6 Sybase NCHAR and NVARCHAR Data TypesThe gateway cannot select a column defined with a Sybase NCHAR or NVARCHAR data type.

Database Gateway for Sybase User's Guide, 11g Release 1 (11.1)

Case Studies

3.8 Case 3: Joining Sybase TablesCase 3 demonstrates the following: Joins between Sybase tables Subselects The query retrieves … information from three Sybase tables and relates the employees to their department name and salary grade

Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX PA-RISC (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64, 11g Release 1 (11.1)

Installing Oracle Database Gateway for Sybase

2 Installing Oracle Database Gateway for Sybaseprocedure for Oracle Database Gateway for Sybase. To install the gateway, follow these steps … Requirements for Oracle Database Gateway for Sybase\" Run the Oracle Universal Installer. See \"Step Through … depend on your platform. See Table 2-3 for a description of the installation procedure of Oracle Database Gateway for Sybase

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Sybase

Create Sybase Views for Data Dictionary Supportinstalled. You must run this script on each Sybase database that you want to access through the … ] -e -i dg4sybs_cvw.sql where sa_user and sa_pwd are the Sybase system administrator user ID and password respectively.

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Installing Oracle Database Gateway for Sybase

2 Installing Oracle Database Gateway for Sybaseprocedure for Oracle Database Gateway for Sybase. To install the gateway, follow these steps … Requirements for Oracle Database Gateway for Sybase\". Run the Oracle Universal Installer. See \"Step … they appear depend on your platform. See Table 2-2 for a description of the installation procedure of Oracle Database Gateway for Sybase.

Database Gateway for Sybase User's Guide, 11g Release 1 (11.1)

Sybase Gateway Features and Restrictions

2.5.3 Sybase IMAGE and TEXT Data Typecannot be used in a SQL statement that accesses a column defined as Sybase data type IMAGE or TEXT … . You cannot use SQL*Plus to select data from a column defined as Sybase data type IMAGE or TEXT when … Interface to access such data in a Sybase database. IMAGE and TEXT data cannot be read through pass

Database Gateway for Sybase User's Guide, 11g Release 1 (11.1)

Sybase Gateway Features and Restrictions

2.3 Database Compatibility Issues for SybaseSybase and Oracle databases function differently in some areas, causing compatibility problems. The

Database Gateway for Sybase User's Guide, 11g Release 1 (11.1)

Supported SQL Syntax and Functions

B.2.1 Functions Not Supported by SybaseOracle SQL functions with no equivalent function in Sybase are not supported in DELETE, INSERT, or

Database Gateway for Sybase User's Guide, 11g Release 1 (11.1)

Data Dictionary

C.1.3 Direct Queries to Sybase TablesQueries issued directly to individual Sybase system tables are allowed but they return different … results because the Sybase system table column names differ from those of the data dictionary view … . Also, certain columns in an Sybase system table cannot be used in data dictionary processing.

Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX PA-RISC (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Sybase

3 Configuring Oracle Database Gateway for SybaseSybase: Configure the Gateway Initialization Parameter File Configure Oracle Net for the Gateway … Create Sybase Views for Data Dictionary Support Encrypt Gateway Initialization Parameter Values Configure the Gateway to Access Multiple Sybase Databases

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Sybase

3 Configuring Oracle Database Gateway for SybaseSybase: Configure the Gateway Initialization Parameter File Configure Oracle Net for the Gateway … Create Sybase Views for Data Dictionary Support Encrypt Gateway Initialization Parameter Values Configure the Gateway to Access Multiple Sybase Databases

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Initialization Parameters

Oracle Database Gateway for Sybase Initialization ParametersGateway for Sybase. They are as follows: HS_CALL_NAME HS_DB_DOMAIN HS_DB_INTERNAL_NAME HS_DB_NAME