www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Virtuoso Functions Guide

Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Phrases
RDF data
db.dba.rdf_64bit_upg...
db.dba.rdf_audit_met...
db.dba.rdf_backup_me...
db.dba.rdf_convert_r...
db.dba.rdf_datatype_...
db.dba.rdf_graph_col...
db.dba.rdf_graph_dif...
db.dba.rdf_graph_gro...
db.dba.rdf_graph_gro...
db.dba.rdf_langmatch...
db.dba.rdf_load_rdfa
db.dba.rdf_load_rdfx...
db.dba.rdf_load_rdfx...
db.dba.rdf_quad_uri
db.dba.rdf_quad_uri_...
db.dba.rdf_quad_uri_...
db.dba.rdf_regex
db.dba.rdf_restore_m...
db.dba.rdf_suo_apply...
db.dba.rdf_suo_diff_...
db.dba.rdf_triples_t...
db.dba.rdf_triples_t...
db.dba.rdf_ttl2hash
db.dba.rdf_void_stor...
db.dba.sparql_eval
db.dba.sparql_eval_t...
db.dba.sparql_rdb2rd...
db.dba.sparql_rdb2rd...
db.dba.sparql_rexec
db.dba.sparql_rexec_...
db.dba.sparql_rexec_...
db.dba.sparql_select...
db.dba.ttlp
db.dba.ttlp_mt
db.dba.ttlp_mt_local...
group_concat
isref
sample
__xml_get_ns_prefix
__xml_get_ns_uri
http_nt_triple
http_ttl_triple
iri_split
ld_dir
rdfs_rule_set
sparql_to_sql_text
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
VAD
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web & Internet
XML
XPATH & XQUERY

Functions Index

DB.DBA.SPARQL_RDB2RDF_CODEGEN

Creates an SQL text for a given table and an operation specified by an opcode
DB.DBA.SPARQL_RDB2RDF_CODEGEN (in table_name varchar, in opcode integer);
Description

The function creates an SQL text for a given table and an operation specified by an opcode.

Parameters
table_name – The name of the table.
opcode – Currently supported opcodes are:
  • 0: debugging dump of internal state of code generator, it can be requested by the help-desk.
  • 1: text of procedure that makes an initial RDF dump of triples, created from the specified table. It is used if the table is not empty when triggers are added, so existing data should be dumped as a batch before being continuously edited by triggers.
  • 2: text of AFTER INSERT trigger.
  • 3: text of AFTER UPDATE trigger.
  • 4: text of BEFORE DELETE trigger.
Return Types

string session or vector

See Also

RDB2RDF Triggers

DB.DBA.SPARQL_RDB2RDF_LIST_TABLES