Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: TutorialThe HCL OneDB™ Guide to SQL: Tutorial shows how to use basic and advanced structured query language (SQL) to access and manipulate the data in your databases. It discusses the data manipulation language (DML) statements as well as triggers and stored procedure language (SPL) routines, which DML statements often use.
Access and modify data in an external database
Restrictions for remote database access
Access external database objects

Access external database objects

To access external database objects:

You must hold appropriate access permissions on these objects.
Both databases must be set to the same locale.

Important: Distributed transactions cannot access objects in a database of another HCL OneDB™ server instance unless both server instances support either a TCP/IP or an IPCSTR connection, as defined in their DBSERVERNAME or DBSERVERALIASES configuration parameters and in the sqlhosts information. This connection-type requirement applies to any communication between HCL OneDB database server instances, even if both database servers reside on the same computer.