OpenLink Virtuoso Universal Server: Documentation - Function Index

integer __any_grants (in tablename varchar);

abs (in num any);

acos (in x double precision);

boolean and ( val1 boolean, val2 boolean, ... , valN boolean);

sequence append ( seq1 sequence, seq2 sequence, ... , seqN sequence);

aref ( arg any, nth integer);

integer ascii ( arg any);

aset (in arg any, in nth integer, in new_elem any);

asin (in x double precision);

null assign ( var_name string, var_value any);

atan (in x double precision);

atan2 (in x double precision, in y double precision);

atof (in arg string);

atoi (in arg string);

varchar att_local_name (in dsn varchar, in table varchar);

number avg ( arg1 any, arg2 any, ... , argN any);

backup (in file varchar);

backup_close ();

backup_context_clear ();

backup_flush ();

int backup_online (in file_prefix varchar, in pages integer, [in timeout integer], [in dirs any]);

backup_prepare (in file varchar);

backup_row (in row any);

caddr_t bif_arg (caddr_t * qst , state_slot_t ** args , int nth , char * func );

caddr_t bif_array_arg (caddr_t * qst , state_slot_t ** args , int nth , char * func );

caddr_t bif_array_or_null_arg (caddr_t * qst , state_slot_t ** args , int nth , char * func );

caddr_t bif_bin_arg (caddr_t * qst , state_slot_t ** args , int nth , char * func );

caddr_t bif_double_arg (caddr_t * qst , state_slot_t ** args , int nth , char * func );

caddr_t bif_entity_arg (caddr_t * qst , state_slot_t ** args , int nth , char * func );

caddr_t bif_float_arg (caddr_t * qst , state_slot_t ** args , int nth , char * func );

caddr_t bif_long_arg (caddr_t * qst , state_slot_t ** args , int nth , char * func );

caddr_t bif_long_or_char_arg (caddr_t * qst , state_slot_t ** args , int nth , char * func );

caddr_t bif_string_arg (state_slot_t ** args , int nth , char * func );

caddr_t bif_string_or_null_arg (caddr_t * qst , state_slot_t ** args , int nth , char * func );

caddr_t bif_string_or_wide_or_null_arg (caddr_t * qst , state_slot_t ** args , int nth , char * func );

caddr_t bif_strses_arg (caddr_t * qst , state_slot_t ** args , int nth , char * func );

bit_and (in n1 integer, in n2 integer);

bit_not (in n1 integer);

bit_or (in n1 integer, in n2 integer);

bit_shift (in value integer, in distance integer);

bit_xor (in n1 integer, in n2 integer);

varchar blob_to_string (in blobany);

varchar blob_to_string_output (in blobany);

any bookmark (in cursor CURSOR);

boolean boolean ( obj any);

BPEL.BPEL.compile_script (in scp_id int, in vdir varchar (default null), in opts any (default null), in no_check int (default 0));

BPEL.BPEL.copy_script (in scp_id int);

BPEL.BPEL.get_partner_links (in scp_id int);

BPEL.BPEL.getVariableData (in var_name varchar, in part varchar, in query varchar);

BPEL.BPEL.import_script (in base_uri varchar, in base_name varchar, in scp_id int);

BPEL.BPEL.instance_delete (in id int);

BPEL.BPEL.plink_get_option (in script varchar, in plink varchar, in opt varchar);

BPEL.BPEL.plink_set_option (in script varchar, in plink varchar, in opt varchar, in val any);

BPEL.BPEL.purge_instance (in completed_before datetime, in make_archive int (default 1));

BPEL.BPEL.script_delete (in script varchar, in delete_instances int);

BPEL.BPEL.script_obsolete (in script varchar);

BPEL.BPEL.script_source_update (in scp_id int, in url varchar, in content any);

BPEL.BPEL.script_upload (in name varchar, in url varchar, in content any);

BPEL.BPEL.setVariableData (in var_name varchar, in value any, in part varchar, in query varchar);

BPEL.BPEL.wsdl_upload (in scp_id int, in url varchar, in content any, in pl varchar default 'wsdl');

ceiling (in x double precision);

integer ceiling ( num number);

cfg_item_count (in path varchar, in section varchar);

cfg_item_name (in path varchar, in section varchar, in item_index integer);

cfg_item_value (in path varchar, in section varchar, in item_name varchar);

cfg_section_count (in path varchar);

cfg_section_name (in path varchar, in index integer);

cfg_write (in path varchar, in section varchar, in item_name varchar, in item_value varchar);

charset_define (in name varchar, in charset_string any, in aliases any);

any charset_recode (in src_string varchar/nvarchar, in src_charset varchar, in dst_charset varchar);

any charsets_list (in gen_res_set integer);

integer checkpoint_interval (in minutes integer);

varchar chr (in chr_codelong);

varchar client_attr (in attr varchar);

collation_define (in COLLATION_NAME varchar, in FILE_PATH varchar, in ADD_TYPE integer);

varchar complete_table_name (in tablename varchar, in mode integer);

composite obj composite (in x any, ... );

integer composite_ref (in c any, in nth integer);

concat ( str1 varchar, str2 varchar, ... , strn varchar);

string concat ( strg1 string, strg2 string, ... , strgN string);

string concatenate (in arg_1 any, ... );

any connection_get (in name varchar);

connection_id ();

integer connection_is_dirty ();

connection_set (in name varchar, in value any);

any connection_vars ();

connection_vars_set (in var_array any);

boolean contains ( column varchar, expression varchar, [opt_or_valueinteger]);

boolean contains ( haystack string, needle string);

numeric CORR (in expr1 any, in expr2 any);

cos (in x double precision);

cot (in x double precision);

integer count ( seq any);

cov_load (in fname varchar);

cov_report (in fname varchar, in outdir varchar);

cov_store (in fname varchar, in add_comments integer);

numeric COVAR_POP (in expr1 any, in expr2 any);

numeric COVAR_SAMP (in expr1 any, in expr2 any);

attribute create-attribute ( attrname string, attrvalue string);

entity create-comment ( comment-text string);

node create-element ( head sequence, child1 any, child2 any, ... , childN any);

entity create-pi ( piname string); ( pivalue string);

XMLType createXML (in src any, [in schema_uri any], [in validated any], [in wellformed any]);

datetime curdate ();

datetime curdatetime ();

node-set current

current_charset ();

time curtime ();

dateadd (in unit string, in number integer, in date datetime);

datediff (in unit string, in date1 datetime, in date2 datetime);

datestring (in date datetime);

datestring_gmt (in date datetime);

datestring_GMT (in dt datetime);

integer DAV_ADD_GROUP (in gid varchar, in auth_uid varchar, in auth_pwd varchar);

integer DAV_ADD_USER (in uid varchar, in pwd varchar, in gid varchar, in permis varchar, in disable integer, in home varchar, in full_name varchar, in email varchar, in uid varchar, in auth_uid varchar, in auth_pwd varchar);

integer DAV_COL_CREATE (in path varchar, in permissions varchar, in uname varchar, in gname varchar, in auth_uname varchar, in auth_pwd varchar);

integer DAV_COPY (in path varchar, in destination varchar, in overwrite integer, in permissions varchar, in uname varchar, in gname varchar, in auth_uname varchar, in auth_pwd varchar);

integer DAV_DELETE (in path varchar, in silent integer, in auth_uname varchar, in auth_pwd varchar);

varchar DAV_DELETE_GROUP (in gid varchar, in auth_uid varchar, in auth_pwd varchar);

varchar DAV_DELETE_USER (in uid varchar, in auth_uid varchar, in auth_pwd varchar);

any DAV_DIR_LIST (in path varchar, in recursive integer, in auth_uid varchar, in auth_pwd varchar);

WS.WS. DAV_EXP (in host varchar, in url varchar, in root varchar, in dst varchar);

varchar DAV_HOME_DIR (in uid varchar);

integer DAV_IS_LOCKED (in id any, in type char(1), in owned_tokens any := 1);

integer DAV_LIST_LOCKS (in id any, in type char(1));

integer DAV_LOCK (in path varchar, in locktype varchar, in scope varchar, in token varchar, in owner_name varchar, in owned_tokens varchar, in depth varchar, in timeout_sec integer, in auth_uname varchar, in auth_pwd varchar);

varchar DAV_MOVE (in path varchar, in destination varchar, in overwrite integer, in auth_uname varchar, in auth_pwd varchar);

varchar DAV_PROP_REMOVE (in path varchar, in propname varchar, in silent integer, in auth_uname varchar, in auth_pwd varchar);

integer DAV_PROP_SET (in path varchar, in propname varchar, in propvalue any, in auth_uname varchar, in auth_pwd varchar);

varchar DAV_RES_UPLOAD (in path varchar, in content any, in type varchar, in permissions varchar, in uname varchar, in gname varchar, in auth_uname varchar, in auth_pwd varchar);

integer DAV_SEARCH_ID (in path varchar, in what char(1));

varchar DAV_SEARCH_PATH (in id integer, in what char(1));

any DAV_UNLOCK (in path varchar, in token varchar, in auth_uname varchar, in auth_pwd varchar);

dayname (in dt datetime);

dayofmonth (in dt datetime);

dayofmonth (in dt datetime);

dayofweek (in dt datetime);

dayofweek (in dt datetime);

dayofyear (in dt datetime);

dayofyear (in dt datetime);

DB.DBA.RDF_64BIT_UPGRADE

DB.DBA.RDF_AUDIT_METADATA ([in audit_mode integer], [in str_value varchar], [in graph_iri varchar]);

varchar DB.DBA.RDF_BACKUP_METADATA (in save_to_file integer := 0); (in backup_name varchar := null);

DB.DBA.RDF_CONVERT_RDFXML_TO_TTL (in strg varchar, in base varchar, inout ttl_ses any);

DB.DBA.RDF_LANGMATCHES (in r varchar, in t varchar);

DB.DBA.RDF_LOAD_RDFXML (in rdfxml_text varchar, in omt_top_rdf varchar, in graph_uri varchar);

DB.DBA.RDF_LOAD_RDFXML_MT (in strg varchar, in base varchar, in graph varchar, [in log_mode integer], [in threads integer]);

DB.DBA.RDF_QUAD_URI (in g_uri varchar, in s_uri varchar, in p_uri varchar, in o_uri varchar);

DB.DBA.RDF_QUAD_URI_L (in g_uri varchar, in s_uri varchar, in p_uri varchar, in o_lit any);

DB.DBA.RDF_QUAD_URI_L_TYPED (in g_uri varchar, in s_uri varchar, in p_uri varchar, in o_lit any, in dt any, in lang varchar);

DB.DBA.RDF_REGEX (in s varchar, in p varchar, in call varchar := null);

DB.DBA.RDF_RESTORE_METADATA (in read_from_file integer, in backup_name varchar);

DB.DBA.RDF_TRIPLES_TO_RDF_XML_TEXT (inout triples any, in print_top_level any, inout ses any);

DB.DBA.RDF_TRIPLES_TO_TTL (inout triples any, inout ses any);

DB.DBA.RDF_TTL2HASH (in strg any, in base varchar, in graph varchar);

DB.DBA.SPARQL_EVAL (in query varchar, in dflt_graph varchar, in maxrows integer);

DB.DBA.SPARQL_EVAL_TO_ARRAY (in query varchar, in dflt_graph varchar, in maxrows integer);

DB.DBA.SPARQL_REXEC (in service varchar, in query varchar, in dflt_graph varchar, in named_graphs any, in req_hdr any, in maxrows integer, in bnode_dict any);

DB.DBA.SPARQL_REXEC_TO_ARRAY (in service varchar, in query varchar, in dflt_graph varchar, in named_graphs any, in req_hdr any, in maxrows integer, in bnode_dict any);

DB.DBA.SPARQL_REXEC_WITH_META (in service varchar, in query varchar, in dflt_graph varchar, in named_graphs any, in req_hdr any, in maxrows integer, in bnode_dict any, out metadata any, out resultset any);

DB.DBA.TTLP (in strg any, in base varchar, in graph varchar, in flags integer);

DB.DBA.TTLP_MT (in strg any, in base varchar, [in graph varchar], [in flags integer], [in log_mode integer], [in threads integer]);

DB.DBA.VACUUM (in table_name varchar (default %), in index_name varchar (default %));

dbg_obj_print (in arg1 any, ... );

dbg_printf (in format varchar, in arg1 any, ... , in argn any);

dbname

decode_base64 (in str varchar);

degrees (in x double precision);

delay (in n_seconds integer);

binary string deserialize (in str varchar);

dictionary dict_duplicate (in dict dictionary);

any dict_get (in dict dictionary, in key any, [in default_value any]);

vector dict_list_keys (inout dict dictionary, in destructive any);

dictionary dict_new ([in size integer]);

int dict_put (inout dict dictionary, in key any, in value any);

int dict_remove (inout dict dictionary, inout key any);

vector dict_to_vector (inout dict dictionary, in destructive any);

disconnect_user (in username_patternstring);

sequence distinct ( input sequence);

node-set doc ( document_uri varchar);

node-set document ( document_uri varchar, [base_uri varchar], [parser_mode integer], [content_encoding varchar], [content_language varchar], [dtd_validator_config varchar]);

node-set document-literal ( document_text varchar, [cache_uri varchar], [parser_mode integer], [content_encoding varchar], [content_language varchar], [dtd_validator_config varchar]);

varchar dsig_template_ext (in xdoc any, in tmpl varchar, in wss_ver any, in ns-n varchar, in elm-n varchar, in ... varchar);

dt_set_tz (in dt datetime, in tz integer);

dv_type_title ( internal_type integer);

array dvector ( elt1 , .... , elt-n );

either (in cond any, in arg1 any, in arg2 any);

encodedlang_handler_t * elh_get_handler (encoding_handler_t * encoding , language_handler_t * language );

int elh_load_handler (encodedlang_handler_t * new_handler );

boolean empty ( seq any);

encode_base64 (in str varchar);

end_result ();

boolean ends-with ( strg string, suffix string);

equ ( arg1 any, arg2 any);

boolean every ( varname string, test_set sequence, test_expn boolean);

sequence except ( set1 sequence, set2 sequence);

exec (in str varchar, out state varchar, out message varchar, in params any, in maxrows integer, out metadata vector, out rows vector, out cursor_handle long);

exec_close (in cursor_handle long);

exec_metadata (in str varchar, out state varchar, out message varchar, out metadata vector);

integer retcode exec_next (in cursor_handle long, out sql_state varchar, out sql_error varchar, out row_array vector);

any exec_result (in res_values_array any);

exec_result_names (in res_names_array any);

exec_score (in str varchar, out state varchar, out message varchar);

exp (in x double precision);

explain (in textvarchar, [in cursor_type integer]);

boolea