Dbvisualizer format sql how to#
Dbvisualizer format sql driver#

Stepping back from the example it is easy to see the that the scenario is a common one: a join between the manager's customer list and order information. The goal is to use a data service to obtain order information for that specific set of customers. A sales manager has a consolidated list of all government customers in European countries. If more than one column is specified, an exception is thrown.Ī scenario: a data service contains consolidated information on all recent customer orders. In the current implementation only a single table column can be passed as a table parameter. The table parameter is specified through the same mechanism as a a parameter a question mark ('?') is used in place of the appropriate table name. WHERE id_cust.id_cust_num = cust.CUSTOMER_ID SELECT cust.CUSTOMER_ID, cust.FIRST_NAME, cust.LAST_NAMEįROM ? as id_cust(id_cust_num), as cust ,

Dbvisualizer format sql driver#

The AquaLogic Data Services Platform JDBC driver implements the following interfaces from java.sql package specified in JDK 1.4x: DDL (Data Definition Language) statements are also not supported. INSERT, UPDATE, and DELETE statements are not supported. The AquaLogic Data Services Platform JDBC driver provides SQL-92 support for the SELECT statement. This section outlines the SQL-92 support in the AquaLogic Data Services Platform JDBC driver. SQL Support in AquaLogic Data Services Platform For more information about using database functions with AquaLogic Data Services Platform, refer to Creating and Working with XQuery Function Libraries in Data Services Developer's Guide. Using Custom Database Functions through AquaLogic Data Services Platformīuilt-in or custom functions in your database can be made available through data services once the function has been registered with AquaLogic Data Services Platform through a library. Techniques for publishing data services as SQL are described in Publishing Data Services Functions for SQL Use in the Data Services Developer's Guide.įor details on accessing the AquaLogic Data Services Platform JDBC driver, and information on the relationship between data services artifacts and JDBC, see About the AquaLogic Data Services Platform JDBC Driver. Once deployed, the newly created SQL objects are available to your application through standard JDBC. Build and deploy your AquaLogic Data Services Platform application.Publish data service functions to a special schema that models them as SQL objects.

Dbvisualizer format sql how to#

This chapter explains how to use SQL to access data services as well as how to set up and use the AquaLogic Data Services Platform JDBC driver. You can use the JDBC driver to execute SQL92 SELECT queries, or stored procedures over AquaLogic Data Services Platform applications. The driver implements the java.sql.* interface in JDK 1.4x to provide access to an AquaLogic Data Services Platform server through the JDBC interface. SQL access is provided through the AquaLogic Data Services Platform JDBC driver. Application developers also can use a standalone Query Plan Viewer utility which supports both XQuery and SQL.īEA AquaLogic Data Services Platform supports table parameters, an extension to SQL-92. But the ability to handle SQL is also useful in other contexts.įor example, it is useful to be able to run ad hoc SQL queries against data services using tools such as DbVisualizer. This is necessary in the case of many reporting tools such as Crystal Reports, Hyperion, and Business Objects. This script outputs the product breadcrumb required for edocs documentation.Īpplications can access data services through SQL.