Skip to main content
Skip table of contents

Direct Query Procedure native()

The JDBC translator provides a procedure to execute any ad-hoc SQL query directly against the source without CData Virtuality Server parsing or resolving. Since the metadata of this procedure’s results are not known to CData Virtuality Server, they are returned as an object array. ARRAYTABLE can be used construct tabular output for consumption by client applications.

Select Examples

SQL
SELECT x.* FROM (call jdbc_source.native('select * from g1')) w,
ARRAYTABLE(w.tuple COLUMNS "e1" integer , "e2" string) AS x ;;
 
SELECT x.* FROM (call jdbc_source.native('select ? where 1=?','2',(select 1))) x ;;
 
SELECT x.* FROM (call jdbc_source.native(
    "request" => 'select ? where 1=?',
    "variable" => array('2',(select 1)))
) x ;;

Insert Example

SQL
SELECT x.* FROM (call jdbc_source.native('insert into g1 (e1,e2) values (?, ?)', 112, 'foo')) w,
ARRAYTABLE(w.tuple COLUMNS "update_count" integer) AS x

Update Example

SQL
SELECT x.* FROM (call jdbc_source.native('update g1 set e2=? where e1 = ?','blah', 112)) w,
ARRAYTABLE(w.tuple COLUMNS "update_count" integer) AS x

Delete Example

SQL
SELECT x.* FROM (call jdbc_source.native('delete from g1 where e1 = ?', 112)) w,
ARRAYTABLE(w.tuple COLUMNS "update_count" integer) AS x
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.