GENERATE_DDL_FOR_WRAPPER

<< Click to Display Table of Contents >>

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

GENERATE_DDL_FOR_WRAPPER

Previous pageReturn to chapter overviewNext page

Generates DDL for named data wrapper. See CREATE LOCAL DATA WRAPPER or CREATE FOREIGN DATA WRAPPER for details.

Syntax

SYS_BOOT.MGMT.GENERATE_DDL_FOR_WRAPPER(wrapper_name);

 

where wrapper_name is name of wrapper, such as "ECDA" in the example below.

CREATE OR REPLACE FOREIGN DATA WRAPPER ECDA LIBRARY 'class com.sqlstream.aspen.namespace.common.CommonDataWrapper''

'LANGUAGE JAVA;

 

5_2_indicator

Version 5.3 Feature

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

Example

SELECT STATEMENT FROM TABLE (SYS_BOOT.MGMT.GENERATE_DDL_FOR_WRAPPER('ECDA'));

'STATEMENT'

'CREATE OR REPLACE FOREIGN DATA WRAPPER ECDA LIBRARY 'class com.sqlstream.aspen.namespace.common.CommonDataWrapper''

'LANGUAGE JAVA;'