GENERATE_DDL_FOR_JAR

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks > Functions > Built-in Functions > General Management Functions >

GENERATE_DDL_FOR_JAR

Previous pageReturn to chapter overviewNext page

Returns a create statement for a named jar.

Syntax

SELECT STATEMENT FROM TABLE(SYS_BOOT.MGMT.GENERATE_DDL_FOR_JAR(catalog_name [optional],<schema_name>,<jar_name>);

 

where <schema_name> is the name of the schema in which the jar was created and <jar_name> is the name of the jar.

'CREATE OR REPLACE JAR "buses"."GeoIp"'

'LIBRARY 'file:plugin/geoip/geoip.jar''

'OPTIONS(0);'

 

5_2_indicator

Version 5.3 Feature

As of version 5.3, you no longer need to use the preface SYS_BOOT.MGMT.

Example

You can implement this function using the following code:

SELECT STATEMENT FROM TABLE(SYS_BOOT.MGMT.GENERATE_DDL_FOR_JAR('buses', 'GeoIp'));

'STATEMENT'

'CREATE OR REPLACE JAR "buses"."GeoIp"'

'LIBRARY 'file:plugin/geoip/geoip.jar''

'OPTIONS(0);'