Checks a table for grants. | |
Return the absolute value of a number | |
trigonometric functions | |
Returns false if a value of some argument is false, otherwise returns true. | |
Creates an sequence of all items from given sequences. | |
returns specific element of an array or string | |
Get ASCII value of a character | |
set array element | |
trigonometric functions | |
Creates a local variable and assign a value to it. | |
trigonometric functions | |
trigonometric functions | |
Convert a string to single precision float | |
Convert a string to an integer | |
Compose a fully qualified table name based on DSN and remote table name. | |
Returns average value of all its arguments. | |
Write data into transaction log format for backup purposes. Deprecated. | |
backup_close
();
|
Write data into transaction log format for backup purposes. Deprecated. |
Clears the backup context and marks all pages in checkpoint space as ready for online backup | |
backup_flush
();
|
Write data into transaction log format for backup purposes. Deprecated. |
perform online backup of database | |
Write data into transaction log format for backup purposes. Deprecated. | |
Write data into transaction log format for backup purposes. Deprecated. | |
Get parameters for built in function | |
Get parameters for built in function | |
Get parameters for built in function | |
Get parameters for built in function | |
Get parameters for built in function | |
Get parameters for built in function | |
Get parameters for built in function | |
Get parameters for built in function | |
Get parameters for built in function | |
Get parameters for built in function | |
Get parameters for built in function | |
caddr_t
bif_string_or_wide_or_null_arg
(caddr_t * qst
,
state_slot_t ** args
,
int nth
,
char * func
);
|
Get parameters for built in function |
Get parameters for built in function | |
Returns bitwise AND of two 32-bit integers. | |
Returns bitwise NOT of a 32-bit integer. | |
Returns bitwise OR of two 32-bit integers. | |
Returns the result of bitwise shift operation over two 32-bit integers. | |
Returns bitwise XOR (exclusive "or") of two 32-bit integers. | |
Convert a blob to string | |
Convert a blob to string session | |
Return the bookmark for current row of a scrollable cursor | |
Converts its argument to boolean | |
BPEL.BPEL.compile_script
(in scp_id int,
in vdir varchar (default null),
in opts any (default null),
in no_check int (default 0));
|
Compile a BPEL script source |
Makes a copy of an existing script | |
Returns a list of partner links used in the BPEL script | |
gets BPEL variable data within <bpelv:exec binding="SQL"> activity | |
Import a new BPEL process | |
delete a BPEL process instance | |
retrieving a partner link option | |
set value of a partner link option | |
removes old BPEL process instances | |
Remove a BPEL process | |
mark a BPEL script as obsoleted | |
Updates an existing script in BPEL repository | |
Upload a new BPEL script source | |
sets BPEL variable data within code invoked from <bpelv:exec binding="SQL"> activity | |
BPEL.BPEL.wsdl_upload
(in scp_id int,
in url varchar,
in content any,
in pl varchar default 'wsdl');
|
Uploads a WSDL description for a given BPEL script |
Round a number to positive infinity. | |
Returns the smallest integer that is not less than the argument. | |
return number of items in a section in configuration file | |
get nth item name from ini file | |
returns the value of an item from the ini file | |
get number of sections in an INI file | |
returns INI file section name | |
Writes the item=value to an INI file | |
Define a character set. | |
any
charset_recode
(in src_string varchar/nvarchar,
in src_charset varchar,
in dst_charset varchar);
|
Translate a string to another character set |
List known character set names and aliases. | |
Configure database checkpointing | |
Convert a long character code to a character or wide character | |
returns a varchar containing the requested information from the connection | |
define a new collation | |
Returns a fully qualified table name. | |
create a composite object | |
get member of a composite object | |
Concatenate strings | |
Returns the concatenation of its arguments. | |
concatenate strings | |
Get connection variable | |
connection_id
();
|
get connection identifier |
integer
connection_is_dirty
();
|
check if current session connection variables have been altered |
Associates a value to the name in the context of the present connection | |
any
connection_vars
();
|
Retrieve all connection variables |
set all connection variables | |
A text contains predicate | |
Returns true if the first argument string contains the second argument string, and otherwise returns false. | |
Returns the coefficient of correlation of a set of number pairs. | |
trigonometric functions | |
trigonometric functions | |
Returns the number of values in the sequence. | |
Load test coverage data from file. | |
Produce a text coverage report. | |
Writes a test coverage to a file. | |
Returns the population covariance of a set of number pairs. | |
Returns the sample covariance of a set of number pairs. | |
Creates a special "attribute descriptor" object. | |
Creates a "comment" XML tree entity. | |
Creates an element with specified name, attributes and children | |
Creates a "processing instruction" XML tree entity. | |
datetime
curdate
();
|
get current date and time |
datetime
curdatetime
();
|
get current date and time |
node-set
current
|
Returns a node-set that has the current node as its only member. |
current_charset
();
|
Get name of current charset. |
time
curtime
();
|
get current date and time |
arithmetic add to a date | |
get difference of 2 dates | |
convert a datetime from internal to external date-time representation | |
convert a datetime from internal to external date-time representation | |
convert a timestamp to external format string in GMT | |
Functions for manipulating an existing DAV collection or resource | |
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);
|
Functions for manipulating an existing DAV collection or resource |
integer
DAV_COL_CREATE
(in path varchar,
in permissions varchar,
in uname varchar,
in gname varchar,
in auth_uname varchar,
in auth_pwd varchar);
|
functions for adding, updating, deleting of DAV collections or resources |
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);
|
Functions for manipulating an existing DAV collection or resource |
integer
DAV_DELETE
(in path varchar,
in silent integer,
in auth_uname varchar,
in auth_pwd varchar);
|
functions for adding, updating, deleting of DAV collections or resources |
Functions for manipulating an existing DAV collection or resource | |
Functions for manipulating an existing DAV collection or resource | |
Functions for searching a DAV collection or resource | |
Export a retrieved Web site to another WebDAV enabled server | |
Functions for manipulating an existing DAV collection or resource | |
Operations on locks of DAV collections and resources | |
Operations on locks of DAV collections and resources | |
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);
|
Operations on locks of DAV collections and resources |
varchar
DAV_MOVE
(in path varchar,
in destination varchar,
in overwrite integer,
in auth_uname varchar,
in auth_pwd varchar);
|
Functions for manipulating an existing DAV collection or resource |
varchar
DAV_PROP_REMOVE
(in path varchar,
in propname varchar,
in silent integer,
in auth_uname varchar,
in auth_pwd varchar);
|
Functions for manipulating an existing DAV collection or resource |
integer
DAV_PROP_SET
(in path varchar,
in propname varchar,
in propvalue any,
in auth_uname varchar,
in auth_pwd varchar);
|
Functions for manipulating an existing DAV collection or resource |
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);
|
functions for adding, updating, deleting of DAV collections or resources |
Functions for searching a DAV collection or resource | |
Functions for searching a DAV collection or resource | |
Operations on locks of DAV collections and resources | |
decompose a datetime to its components | |
decompose a datetime to its components | |
get day of month from a datetime | |
decompose a datetime to its components | |
get day of week from a datetime | |
decompose a datetime to its components | |
get day of year from a datetime | |
Alters IRI_ID columns to get IRI_ID_8. | |
DB.DBA.RDF_AUDIT_METADATA
([in audit_mode integer],
[in str_value varchar],
[in graph_iri varchar]);
|
Fix RDF metadata corruption. |
varchar
DB.DBA.RDF_BACKUP_METADATA
(in save_to_file integer := 0);
(in backup_name varchar := null);
|
Makes a backup copy of RDF metadata (i.e., descriptions of RDF Views and the like). |
Converts rdf xml to ttl. | |
Returns 1 if language identifier r matches lang pattern t. | |
Parses the content of RDF/XML text as a sequence of separate RDF triples. | |
DB.DBA.RDF_LOAD_RDFXML_MT
(in strg varchar,
in base varchar,
in graph varchar,
[in log_mode integer],
[in threads integer]);
|
Parses the content of large RDF/XML text as a sequence of separate RDF triples. |
Performs simple insertion of a quad where object is a node. | |
Performs simple insertion of a quad where object is a literal value in 'SQL valmode'. | |
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);
|
Performs simple insertion of a quad where object is a literal value in 'SQL valmode' and can be specified datatype and language. |
Returns 1 if string s matches pattern p, 0 otherwise. | |
Restores RDF metadata (descriptions of RDF Views and the like) from previously saved backup. | |
Serializes vector of triples into a session, in RDF/XML syntax. | |
Serializes vector of triples into a session, in TURTLE syntax. | |
Returns a dict of triples in 'long valmode'. | |
Collects statistics for a given graph and saves it. | |
Local execution of SPARQL via SPARQL protocol, produces a result set of SQL values. | |
Local execution of SPARQL via SPARQL protocol, produces a vector of vectors of SQL values. | |
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);
|
Remote execution of SPARQL via SPARQL protocol, produces a result set of SQL values. |
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);
|
Remote execution of SPARQL via SPARQL protocol, produces a vector of vectors of SQL value. |
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);
|
Remote execution of SPARQL via SPARQL protocol. Fills in output parameters with metadata (like exec metadata) and a vector of vector s of 'long valmode' values. |
parses TTL (TURTLE or N3 resource) and places its triples into DB.DBA.RDF_QUAD. | |
DB.DBA.TTLP_MT
(in strg any,
in base varchar,
[in graph varchar],
[in flags integer],
[in log_mode integer],
[in threads integer]);
|
parses TTL (TURTLE or N3 resource) and places its triples into DB.DBA.RDF_QUAD on multiple threads. |
DB.DBA.TTLP_MT_LOCAL_FILE
(in path varchar,
in base varchar,
[in graph varchar],
[in flags integer],
[in log_mode integer],
[in threads integer]);
|
parses TTL (TURTLE or N3 resource) and places its triples into DB.DBA.RDF_QUAD on multiple threads. |
Compact the database | |
print to the Virtuoso system console | |
print formatted output onto the system console | |
get current catalog | |
base64-encode/decode a string | |
trigonometric functions | |
sleep for n seconds | |
convert any heterogeneous array or tree of arrays into a binary string and back | |
Creates a copy of the given dictionary. | |
Returns the dependent part that corresponds to the given key in the given dictionary. | |
Returns an array of all keys stored in the given dictionary. | |
Creates a new dictionary to store key-value pairs. | |
Adds a key-value pair to a dictionary | |
Removes the given key and associated dependent value from the given dictionary. | |
Returns a get_keyword style vector of all items stored in the given dictionary. | |
Disconnect client connections of a given user | |
Removes double entities from the input sequence | |
Returns data from XML doc other than the main source document. | |
node-set
document
(
document_uri varchar,
[base_uri varchar],
[parser_mode integer],
[content_encoding varchar],
[content_language varchar],
[dtd_validator_config varchar]);
|
Returns data from XML documents other than the main source document. |
node-set
document-literal
(
document_text varchar,
[cache_uri varchar],
[parser_mode integer],
[content_encoding varchar],
[content_language varchar],
[dtd_validator_config varchar]);
|
Parses given XML text and returns the resulting XML data. |
varchar
dsig_template_ext
(in xdoc any,
in tmpl varchar,
in wss_ver any,
in ns-n varchar,
in elm-n varchar,
in ... varchar);
|
Generates a Digital signature template based on a XML document. |
modifies the timezone component of a datetime | |
returns the internal type name of the argument | |
return an array of either long, float or double | |
conditionally return one of specified parameters | |
encodedlang_handler_t *
elh_get_handler
(encoding_handler_t * encoding
,
language_handler_t * language
);
|
get localization function handler |
load encoding handler into system | |
Returns true if given argument is an empty sequence, false if it is any single value or nonempty sequence. | |
base64-encode/decode a string | |
end_result
();
|
End the current result set. |
Returns true if the first argument string ends with the second argument string, and otherwise returns false. | |
comparison functions | |
Returns true if all items of given sequence matches given criterion. | |
Returns a difference of two sets | |
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);
|
dynamic execution of SQL returning state and result set |
Closes cursor created by exec() | |
Compiles a SQL statement and returns the metadata | |
integer retcode
exec_next
(in cursor_handle long,
out sql_state varchar,
out sql_error varchar,
out row_array vector);
|
Get next result from a result set |
Returns a result set row to the calling procedure context | |
Supplies column details for procedure result set output. | |
Compiles a SQL statement and returns the estimate time cost | |
calculate exponent | |
describe SQL statement compilation | |
boolean
false
|
Returns false. |
Delete a file from the file system | |
Returns list with content of file system directory | |
Creates a directory in the file system | |
Make a directory chain | |
get various OS statistics about a file | |
returns the contents of a file as a varchar | |
get contents of a file as a string output stream | |
Delete a file from the file system | |
Composes trees of shallow copies of given XML entities. | |
alter default foreign key checking behavior | |
Round a number to negative infinity. | |
Returns the largest integer that is not greater than the argument. | |
node()*
fn:collection
([uri anyURI],
[base_uri string],
[recursive_mode int],
[parser_mode int],
[encoding string],
[language string],
[dtd_config string]);
|
Returns parsed documents contained in given collections. |
Repeats some calculation for every item of a given sequence | |
integer
ftp_get
(in server varchar,
in user varchar,
in pass varchar,
in remote_file_name varchar,
in local_file_name varchar,
[in is_pasv integer]);
|
FTP get command; Virtuoso FTP client |
any
ftp_ls
(in server varchar,
in user varchar,
in pass varchar,
in remote_dir_name varchar,
[in is_pasv integer]);
|
FTP dir command; Virtuoso FTP client |
integer
ftp_put
(in server varchar,
in user varchar,
in pass varchar,
in local_file_name varchar,
in remote_file_name varchar,
[in is_pasv integer]);
|
FTP put command; Virtuoso FTP client |
Returns true if XPATH extension function with the requested name is defined in the XPATH Processor, otherwise returns false. | |
return an array of either long, float or double | |
Returns a string that uniquely identifies the node. | |
integer or string
get_certificate_info
(in typeinteger,
in cert_or_key_namevarchar,
in in_formatint,
in passwdvarchar,
in ext_oidvarchar);
|
Returns information about the current client X509 certificate |
Find a value in keyword vector | |
get_keyword_ucase
(
keyword anything,
searched_array vector,
[default anything],
[no_copy integer]);
|
Find a value in keyword vector (search uppercase) |
timestamp
get_timestamp
();
|
returns the timestamp of the current transaction |
getdate
();
|
returns the current transaction timestamp, alias of now |
comparison functions | |
comparison functions | |
Compress data using gzip algorithm | |
returns the contents of a gzipped file | |
Uncompress a string using gzip algorithm | |
decompose a datetime to its components | |
get hour from a datetime | |
Returns URL that represents the given DOI | |
write to HTTP client or a string output stream | |
integer
http_acl_get
(in list_name varchar,
in source_ip varchar,
[in destination_ip_or_host varchar],
[in object_id integer],
[in read_write_flag integer]);
|
Test conditions against web server ACL's |
integer
http_acl_remove
(in list_name varchar,
in order integer,
in client_ip varchar,
in flag integer);
|
Removes conditions against web server ACL's |
integer
http_acl_set
(in list_name varchar,
in order integer,
in client_ip varchar,
in flag integer,
[in destination_ip_or_host varchar],
[in object_id integer],
[in read_write_flag integer],
in rate integer);
|
Set conditions against web server ACL's |
string
http_body_read
();
|
Reads the HTTP body from the client HTTP connection and returns it as a string. |
varchar
http_client
(in url varchar,
[in uid varchar],
[in pwd varchar],
[in http_method varchar],
[in http_headers varchar],
[in body varchar],
[in cert_file varchar],
[in cert_pwd varchar],
[in timeout varchar],
[in proxy varchar]);
|
returns a varchar containing the body of the request uri |
varchar
http_client_ext
(in url varchar,
[in uid varchar],
[in pwd varchar],
[in http_method varchar],
[in http_headers varchar],
[in body varchar],
[in cert_file varchar],
[in cert_pwd varchar],
inout headers any,
[in timeout varchar],
[in proxy varchar]);
|
returns a varchar containing the body of the request uri |
Returns the IP address of the calling client. | |
set WebDAV HTTP request logging | |
Enable / Disable "Content-Encoding: gzip" for HTTP server | |
Send a file to the HTTP client | |
Flush internal HTTP stream and disconnect client; Flush HTTP stream and try sending data in chunked mode. | |
varchar
http_get
(in target_uri varchar,
[out return_header any],
[in http_method varchar],
[in request_header varchar],
[in request_body varchar],
[in proxy varchar]);
|
returns a varchar containing the body of the request uri |
Specifies non-default HTTP response headers | |
varchar
http_header_get
();
|
returns header of current HTTP request |
Kill VSP process whose details match parameter inputs | |
Starts, stops and retrieves the state of a user-defined HTTP listener | |
get values from HTTP virtual host path mapping table | |
http_map_table
(in logical_path varchar,
in physical_path varchar,
in vhost varchar,
in listen_host varchar,
[in stored_in_dav integer],
[in is_browseable integer],
[in default_page varchar],
[in security_restriction varchar],
[in authentication varchar],
[in auth_function varchar],
[in postprocess_function varchar],
[in execute_vsp_as varchar],
[in execute_soap_as varchar],
[in have_persistent_session_variables integer],
[in soap_options any],
[in auth_options any]);
|
Update internal HTTP mapping table |
returns value of a HTML form parameter in VSP context | |
http_path
();
|
returns the absolute path to the logical path location of the current http request |
http_pending_req
();
|
return array describing running VSP threads |
returns the physical path location of the requested URL | |
proxy request to another host and return content to calling client | |
Access to the HTTP request line | |
any
http_request_header
([in array any],
[in field_name varchar],
[in attr-name varchar],
[in default_value varchar]);
|
returns array of HTTP request header lines |
set the status sent to the client in an HTTP response | |
Clears output written to a string output or to an HTTP | |
varchar
http_root
();
|
Returns the absolute path of the server root directory. |
write to HTTP client or string output stream with URL escapes | |
write to HTTP client or string output stream with HTML escapes | |
applies an XSLT stylesheet to the output of a VSP page | |
Returns an entities whose ID attributes are in the given list | |
integer
identity_value
();
|
returns the last assigned identity column value |
If the boolean value is true then calculates one expression, otherwise calculates another expression. | |
This function automatically creates the SQL Type wrappers based on the CLR Reflection API. | |
Creates SQL wrapper types of selected Java classes | |
returns its argument with the first letter capitalized | |
returns the integer standard SQL type of its argument | |
returns internal integer datatype of its argument | |
returns the internal type name of the argument | |
Returns an intersect of two sets | |
Returns true if the given entity is after the second given entity in document order, otherwise returns false. | |
Returns true if the given entity is before the second given entity in document order, otherwise returns false. | |
Check for a valid array | |
returns true if its argument is of type varbinary | |
returns true if its argument is of type long varchar | |
returns true is argument is a double | |
returns true if its argument is an XML entity | |
returns true if its argument is a float | |
returns true if its argument is of type integer | |
returns true if its argument is NULL | |
returns true if argument is of numeric type | |
returns true if its argument is of type varchar | |
returns true if argument is numeric zero | |
java_call_method
(in class_name varchar,
in instance_obj varchar,
in method_name varchar,
in method_ret_sig varchar,
[ arg1, ... ]);
|
|
java_get_property
(in class_name varchar,
in instance_obj varchar,
in field_name varchar,
in field_ret_type_sig varchar);
|
Gets a property value from a Java class instance. |
Declares a Java class to a Java VM | |
Creates and instance of a Java class. | |
java_set_property
(in class_name varchar,
in instance_obj any,
in field_name varchar,
in field_ret_type_sig varchar,
in field_new_value any);
|
Sets a Java class property |
java_vm_detach
();
|
Detaches the current Virtuoso working thread from the Java VM. |
Creates XML description of Java class | |
This XSLT 1.0 function is not implemented in the current version of Virtuoso. | |
Get an estimate of row count for a given set of leading index key parts | |
Returns true if the language of context node matches given language name. | |
number
last
|
Returns the context size from expression evaluation context. |
Converts string argument to lower case | |
int
ldap_add
(in server_url varchar,
in try_tls integer,
in data varchar,
in username varchar,
in password varchar);
|
Adds a new entry to an LDAP directory. |
int
ldap_delete
(in server_url varchar,
in try_tls integer,
in entrydn varchar,
in username varchar,
in password varchar);
|
Remove a leaf entry in the LDAP Directory Information Tree. |
int
ldap_modify
(in server_url varchar,
in try_tls integer,
in data varchar,
in username varchar,
in password varchar);
|
Modifies an existing LDAP directory. |
any
ldap_search
(in server_url varchar,
in try_tls integer,
in base varchar,
in filter varchar,
in username varchar,
in password varchar);
|
Search in an LDAP server. |
returns substring taken from left of string argument | |
Get length of argument | |
any
let
(
var1name string,
var1value sequence,
var2name string,
var2value sequence,
...
,
varNname string,
varNvalue sequence,
retval any);
|
Creates temporary variables and calculates an expression that uses these variables |
Export retrieved web site to the local file system | |
Returns language handler | |
Loads given handler in global table of the server | |
Selects the first item of every argument sequence and returns the sequence of the selected items | |
Returns the local part of the expanded name of the argument. | |
returns the starting position of the first occurrence of an substring in a string | |
calculate natural logarithm of an expression | |
Calculate 10-based logarithms | |
controls transaction logging and in-statement autocommit | |
inserts statements into the roll forward log | |
returns a lower case version of its argument | |
comparison functions | |
comparison functions | |
removes specific characters from a string | |
return an array of either long, float or double | |
returns a new array | |
make a string | |
Returns maximum value among all its arguments. | |
returns the md5 checksum of its argument | |
returns the md5 checksum given an initialized md5 context | |
new md5 checksum context
md5_init
|
returns the string serialization of a new md5 context |
returns the updated md5 context serialized as varchar | |
used to compose multipart/mixed MIME message body | |
any
mime_part
(in content_type varchar,
in content_disposition varchar,
in transfer_encoding varchar,
in data varchar);
|
used to compose a MIME message body part. |
parses MIME messages into an array structure | |
Returns minimum value among all its arguments. | |
decompose a datetime to its components | |
get minute from a datetime | |
returns the modulus of its arguments | |
decompose a datetime to its components | |
get number of month from a datetime | |
decompose a datetime to its components | |
get name of month from a datetime | |
Get number of milliseconds from system epoch | |
connects Virtuoso server to MS DTC. | |
returns timeout of distributed transaction in milliseconds. | |
sets timeout of distributed transaction. | |
checks status of current transaction or server. | |
Returns the expanded name of the argument. | |
Returns portion of dotted name such as a fully qualified table name. | |
Returns the namespace URI of the extended name of the given node | |
comparison functions | |
array
nntp_auth_get
(in server varchar,
in user varchar,
in password varchar,
in command varchar,
in group varchar,
[in first_message integer],
[in last_message integer]);
|
returns information about an NNTP server with authorization |
Post message to NNTP server with authorization | |
array
nntp_get
(in server varchar,
in command varchar,
in group varchar,
[in first_message integer],
[in last_message integer]);
|
Returns information about an NNTP server. |
Post message to NNTP server | |
Returns the argument string with whitespace normalized. | |
Returns true if its argument is false, and false otherwise. | |
now
();
|
returns the current transaction timestamp |
Converts its argument to a number. | |
Returns true if a value of some argument is true, otherwise returns false. | |
changes the file access mode of a file | |
changes the owning group/user of a file | |
converts a PEM file to an array of PEM strings | |
pi
();
|
trigonometric functions |
Makes an array of line/count information based on current coverage. | |
Used to load a coverage of a single procedure record as an array. | |
array
pop3_get
(in host varchar,
in user varchar,
in password varchar,
in buffer_size integer,
[in command varchar],
[in exclude_uidl_list vector]);
|
get messages from a POP3 server |
position
(
element any,
array any,
start_index integer (optional, default 1),
step integer (optional, default 1));
|
returns the index of an element within an array or string |
number
position
|
Returns the context position from expression evaluation context. |
return value of expression raised to specified power. | |
any
processXQuery
(
module_uri string,
[context entity],
[index integer],
[param1_name string],
[param1_value any],
...
[paramN_name string],
[paramN_value any]);
|
Calls an XQuery module from XPath expression, e.g. from some XSLT or BPEL code. |
entity
processXSLT
(
stylesheet_uri string,
[source entity],
[param1_name string],
[param1_value any],
...
[paramN_name string],
[paramN_value any]);
|
Applies stylesheet to given XML entity and returns the result. |
Executes XSQL page and returns the result. | |
Control virtuoso profiling | |
Adds a profiling sample to a profile being accumulated. | |
Calculates all given expressions and returns the result produced by the last one. | |
decompose a datetime to its components | |
get number of quarter of year from a datetime | |
Returns an quoted identifier. | |
trigonometric functions | |
initializes the random number generator | |
Closes cursor created by rexecute() | |
integer
regexp_instr
(in source_string varchar,
in pattern varchar,
[in start_position integer],
[in occurrence integer],
[in return_option integer],
[in match_parameter integer]);
|
Returns the first position of the occurrence of a regular-expression pattern in a given string. |
Allows a like comparison using regular-expression. | |
returns a substring matching the regular expression to the supplied string | |
returns substrings that match the regular expression in supplied string after an offset | |
varchar
regexp_replace
(in source_string any,
in pattern any,
[in replace_string varchar],
[in position integer],
[in occurrence any],
[in match_parameter integer]);
|
Replaces occurrence(s) of the matching pattern in the source_string with a specified replace_string. |
(varchar|nvarchar)
regexp_substr
(in pattern (varchar|nvarchar),
in str (varchar|nvarchar),
in offset integer);
|
returns a single captured substring from matched substring |
Returns a current value of a registry setting | |
vector
registry_get_all
();
|
Returns a vector of all registry settings |
The function checks if a given registry variable is read-only or protected from occasional changes. | |
Remove a variable from registry | |
Associates a value to the name in the Database registry | |
Evaluates the average of the independent variable (expr2) of the regression line. | |
Evaluates the average of the independent variable (expr1) of the regression line. | |
Returns the number of non-null numbers used to fit the regression line. | |
Returns the y-intercept of the regression line. | |
Returns the coefficient of determination (R-squared) of the regression line. | |
Returns the slope of the line. | |
Auxiliary function used to compute various diagnostic statistics. | |
Auxiliary function used to compute various diagnostic statistics. | |
Auxiliary function used to compute various diagnostic statistics. | |
returns a new string consisting of its string argument repeated a given number of times | |
None
REPL_ADD_CR
(in tbl varchar,
in name_suffix varchar,
in type char,
in order integer,
in class varchar,
in col varchar);
|
Creates conflict resolver for bi-directional transactional replication |
Creates conflict resolver for bi-directional replication in DAV | |
None
REPL_ADD_SNAPSHOT_CR
(in tbl varchar,
in name_suffix varchar,
in type char,
in order integer,
in class varchar,
in col varchar);
|
Creates conflict resolver for bi-directional replication |
Create bi-directional snapshot publication | |
Create bi-directional snapshot subscription to an existing publication. | |
terminates communication with a replication publisher | |
Drop bi-directional snapshot publication | |
Drops a subscription to a bi-directional snapshot publication | |
grant privileges for subscription to a publication | |
create initial subscription state | |
None
REPL_INIT_SNAPSHOT
(in server varchar,
in item varchar,
in type integer,
[in how_many integer]);
|
Initializes a bi-directional snapshot publication |
create new publication log | |
REPL_PUB_ADD
(in publication varchar,
in item varchar,
in type integer,
in mode integer,
in procedure_replication_options integer);
|
add item to a publication |
REPL_PUB_INIT_IMAGE
(in publication varchar,
in image_file_path varchar,
in bytes_per_file integer);
|
create initial image of publication on publisher |
remove item from publication. | |
REPL_PUBLISH
(in publication varchar,
in log_path varchar,
[in is_updateable integer],
[in sync_user varchar]);
|
create publication on publisher |
purges transactional replication logs for specified account | |
revoke privileges for subscription | |
REPL_SCHED_INIT
();
|
adds scheduled job to synchronize subscriptions |
defines a server that will participate in replication | |
Return bi-directional snapshot replication server name for specified DSN | |
rename the publishing server instance | |
Define bi-directional snapshot replication server name | |
REPL_STAT
();
|
retrieve status of all subscriptions and publications |
returns status of a published or subscribed publication | |
REPL_SUBSCRIBE
(in server_name varchar,
in publication varchar,
in dav_user varchar,
in dav_group varchar,
in replication_user varchar,
in replication_password varchar,
[in sync_user varchar]);
|
add a subscription |
starts the syncing process against an existing subscription | |
repl_sync_all
();
|
synchronize all subscriptions |
adds a SQL statement to the log of the replication | |
repl_this_server
();
|
returns calling servers name |
drop publication on publisher | |
drop subscription | |
Updates a bi-directional snapshot publication | |
This replaces every occurrence of the second argument in the first argument with the third argument. | |
Searches for an substring and replace its occurrences with other substring. | |
starts the roll forward of the given log | |
Sends one row of results to the calling client. | |
rexecute
(in dsn varchar,
in sql_stmt varchar,
out sql_state varchar,
out error_message varchar,
in in_params vector,
out num_cols integer,
out stmt_meta vector,
out result_set vector,
out cursor_handle long);
|
execute a SQL statement on a remote DSN |
get n rightmost characters of a string | |
rmoreresults
(in cursor_handle long,
out sql_state varchar,
out sql_error varchar,
out num_cols integer,
out stmt_meta vector);
|
move to next result set of rexecute() |
returns a random number between 0 and n - 1 inclusive | |
integer retcode
rnext
(in cursor_handle long,
out row_array vector,
out sql_state varchar,
out sql_error varchar);
|
Get next result from a remote result set |
Returns the integer that is the nearest to the argument. | |
integer
row_count
();
|
returns number of rows affected by the previous DML statement in a procedure body |
execute a SQL statement on a remote DSN, provides a result set where applicable. | |
trims given characters from right of given string | |
search_excerpt
(in hit_words any,
in text varchar,
[in within_first int],
[in max_excerpt int],
[in total int],
[in html_hit_tag varchar]);
|
Returns excerpts with hit words from text |
decompose a datetime to its components | |
get second from a datetime | |
vector
sequence_get_all
();
|
Returns a vector of states of all sequence objects |
Returns the current state of the specified sequence and increments it by one. | |
Removes a sequence object | |
Sets and returns the state of a sequence object. | |
convert any heterogeneous array or tree of arrays into a binary string and back | |
Serializes a value of its argument following the rules of the host RDBMS. | |
Converts argument to its UTF-8 string representation. | |
WS.WS.
SERV_QUEUE_TOP
(in target varchar,
in WebDAV_collection varchar,
in update integer,
in debug integer,
in function_hook varchar,
in data any);
|
Retrieve target website and store within Virtuoso |
server_root
();
|
Returns server working directory. |
Opens a TCP session and returns its handle. | |
Disconnections a TCP session. | |
varchar
ses_read_line
([in ses any],
[in throw_exception_on_eof integer],
[in binary_modeinteger ]);
|
Read a line of character data from a TCP session. |
Write character data to an open TCP session. | |
sets the sequence starting value for an identity column | |
sets the affected rows counter in the current context or in the context of the caller | |
sets the current user for execution | |
Returns a shallow copy of the given XML entity | |
returns -1, 0, or 1 depending on the sign of its numerical | |
Signal an exception in the calling procedure | |
trigonometric functions | |
Creates inverse mapping for the mentioned functions (as described in the doc section SQL Inverse Functions). | |
Creates a key mapping function & table (as described in the doc section SQL Inverse Functions). | |
Reverses the effect of sinv_create_inverse procedure. | |
varchar
smime_sign
(in msg_text varchar,
in signer_cert varchar,
[in private_key varchar],
[in private_key_pass varchar],
[in signer_CA_certs any],
[in flags integer]);
|
Converts a MIME message to a signed S/MIME message |
varchar
smime_verify
(in msg_text varchar,
in certs any,
[out signer_certs any],
[in flags integer]);
|
Verifies signature of signed MIME message |
send message to SMTP server | |
Converts an XML entity to an SQL value given the desired SQL type. | |
any
soap_call
(in host string,
in path string,
in methodURI string,
in methodName string,
in params array of (ParamName, Value),
in version integer,
in certificate varchar,
in password varchar,
in SOAPAction varchar);
|
calls a function from a SOAP server and returns the result. value; deprecated, use SOAP_CLIENT () instead |
soap_client
(in url varchar,
in operation varchar,
in target_namespace varchar default null,
in parameters any default null,
in headers any default null,
in soap_action varchar default '',
in attachments any default null,
in ticket any default null,
in passwd varchar default null,
in user_name varchar default null,
in user_password varchar default null,
in auth_type varchar default 'none',
in security_type varchar default null,
in debug integer default 0,
in template varchar default null,
in style integer default 0,
in version integer default 11,
in direction integer default 0,
in http_header varchar default null,
in security_schema any default null,
in time_out int default 100);
|
Invoke a SOAP service and returns result value. |
varchar
soap_current_url
();
|
Returns URL used to access particular HTTP resource. |
define re-define or erase the complex datatype definition for SOAP calls | |
varchar
soap_make_error
(in soap_code varchar,
in sql_state varchar,
in error_message varchar,
[in soap_version integer],
[in do_uddi integer]);
|
Creates a SOAP error reply XML message based on its parameters. |
soap_print_box
(in value any,
in enclosing_tag varchar,
[in date_encoding_type|soap_version integer]);
|
Formats an SQL value and returns it as a generated XML fragment. |
Generate SDL document for a PL module and return it as a varchar. | |
varchar
soap_server
(in req_xml any,
[in soap_method varchar],
[in lines any],
[in soap_version long],
[in procedure_mappings any]);
|
Execute SOAP request and return XML reply as a varchar. |
Generate WSDL document for a PL module and return it as a varchar. | |
Returns true if at least one item of given sequence matches given criterion. | |
returns a new string of count spaces | |
converts escaped var=val pairs to a vector of strings | |
returns a formatted string | |
returns vector on a specified pattern. | |
returns a formatted string that is marked as an IRI string. | |
returns a formatted IRI string or null if any of the arguments except the first is null. | |
returns a formatted string or null if any of the arguments except the first is null. | |
Returns the value of a column from SQL result-set. | |
vector
sql_columns
(in dsn varchar,
in qualifier varchar,
in owner varchar,
in table_name varchar,
in column varchar);
|
get column information from table on a remote DSN |
Configures a remote DSN as in the DSN attribute string | |
sql_data_sources
();
|
get list of available DSNs |
Tries connecting using supplied connection string | |
vector
sql_get_installed_drivers
|
get column information from table on a remote DSN |
Gets the DSN's attributes list | |
return type information from a remote DSN | |
vector
sql_primary_keys
(in dsn varchar,
in qualifier varchar,
in owner varchar,
in table_name varchar);
|
get primary key information about a table on a remote DSN |
get procedures information for a remote DSN | |
removes a DSN from the ODBC registry | |
vector
sql_special_columns
(in dsn varchar,
in qualifier varchar,
in owner varchar,
in table_name varchar,
in scope integer,
in nullable integer);
|
get special column information from table on a remote DSN |
vector
sql_statistics
(in dsn varchar,
in qualifier varchar,
in owner varchar,
in table_name varchar,
in is_unique integer,
in detail integer);
|
retrieve statistics information on remote DSN |
vector
sql_tables
(in dsn varchar,
in qualifier varchar,
in owner varchar,
in table_name varchar,
in tabletype varchar);
|
get list of tables from remote DSN |
get list of available DSNs | |
Creates a new file DSN | |
integer
sql_write_private_profile_string
(in dsn varchar,
in type varchar,
in name varchar,
in value varchar);
|
Sets a DSN's attribute value |
calculate square root | |
Returns true if the first argument string starts with the second argument string, and otherwise returns false. | |
Returns statistics for a running server as a result set | |
Returns the standard deviation. | |
Returns the population standard deviation. | |
Returns the cumulative sample standard deviation. | |
case-insensitive substring search | |
strchr returns a zero-based index to the first occurrence of the character. | |
Returns a string value of its argument. | |
Returns the number of characters in the string. | |
make a string output stream | |
resets the state of the string_output object | |
compress a string_output with gzip algorithm | |
produce a string out of a string output stream | |
writes a varchar to a file | |
Convert a string to a datetime | |
converts string to a time | |
returns a zero-based index to the last occurrence of the char in str. | |
substring search | |
add scheduled job for periodic synchronization of a subscription | |
returns substring of a string or sub-vector of a vector | |
returns a substring of a string | |
Returns the substring of the first argument starting at the position specified in the second argument with length specified in the third argument. | |
Returns the substring of the first argument string that follows the first occurrence of the second argument string in the first argument string. | |
Returns the substring of the first argument string that precedes the first occurrence of the second argument string in the first argument string. | |
Returns sum of all its arguments | |
gathers common statistical information about the database. | |
Set virtuoso in lockdown state and back. | |
Return statistical information about the Virtuoso server. | |
Collects statistics on a table and its columns for use in SQL optimization | |
sys_stat_histogram
(in table_name varchar,
in column_name varchar,
in n_buckets integer,
[in prec integer]);
|
Collects a column value histogram for use in SQL optimization |
runs a shell command from SQL | |
Returns a value of the system property identified by the name | |
Drops policy function from table. | |
Sets policy function to table. | |
trigonometric functions | |
Returns fully qualified DNS name of the host associated with given IP address | |
Returns IP address by host domain name | |
Returns true if the text value of some node in the given node-set contains the text matching the given free-text query, otherwise returns false. | |
Invoke built-in version of HTML Tidy utility to fix typical errors in HTML text | |
Invoke built-in version of HTML Tidy utility to get list of errors in given input HTML text | |
decompose a datetime to its components | |
get timezone difference from a datetime | |
returns the unique file name within temporary directory of the operating system | |
Disable extra logging for Virtuoso server | |
Enable extra debug logging | |
void
trace_status
|
show current trace settings |
Performs char-by-char translation of given string | |
returns MD5 checksum of array argument | |
removes characters from both ends of string argument | |
boolean
true
|
Returns true |
Selects the first item of every argument sequence and returns the sequence of the selected items | |
poison current transaction forcing rollback | |
kill all pending transactions | |
returns upper case version of string argument | |
uddi_delete_binding | Causes one or more bindingTemplate structures to be deleted. |
uddi_delete_business | Remove one or more businessEntity structures. |
uddi_delete_service | Remove one or more businessService structures. |
uddi_delete_tModel | Remove or retire one or more tModel structures. |
uddi_discard_authToken | Inform a UDDI server that the authentication token can be discarded. |
uddi_find_binding | Retrieves matching bindings |
uddi_find_business | Retrieves a businessList message matching supplied criteria. |
uddi_find_service | Retrieves serviceList message matching search criteria |
uddi_find_tModel | locate list of tModel entries matching supplied criteria |
uddi_get_authToken | Obtain authentication token. |
uddi_get_bindingDetail | Request run-time bindingTemplate location information. |
uddi_get_businessDetail | returns complete businessEntity information for one or more specified businessEntities |
uddi_get_businessDetailExt | Returns extended businessEntity information for one or more specified businessEntities. |
uddi_get_registeredInfo | Retrieve an abbreviated list of all businessEntity keys. |
uddi_get_serviceDetail | request full information about a known businessService structure |
uddi_get_tModelDetail | Request full information about a known tModel structure. |
uddi_save_binding | save or update a complete bindingTemplate structure |
uddi_save_business | Save or update information about a complete businessEntity structure. |
uddi_save_service | Adds or updates one or more businessService structures. |
uddi_save_tModel | Adds or updates one or more tModel structures. |
Determines whether a user defined type contains a specified member. | |
Retrieves a copy of the requested member from a user defined type instance | |
provides a handle to the first method with specific name in a user defined type. | |
returns the type name of supplied type or compares two input types. | |
This function automatically drops the SQL Type wrappers based on the CLR Reflection API. | |
Drops SQL wrapper types of selected Java classes | |
Returns an union of two or more sets | |
Returns the given sequence in any order. | |
This XSLT 1.0 function is not implemented in the current version of Virtuoso. | |
any
updateXML
(in source any,
in path1 varchar,
in replacement1 any,
in path2 varchar,
in replacement2 any,
...
,
in pathN varchar,
in replacementN any);
|
Create a changed copy of given document by replacing some nodes. |
returns upper case version of string argument | |
Converts its argument to a string and returns it in URL encoding. | |
URLREWRITE_CREATE_REGEX_RULE
(in rule_iri varchar,
in allow_update integer,
in nice_match varchar,
in nice_params any,
in nice_min_params integer,
in target_compose varchar,
in target_params any,
in target_expn varchar,
in accept_pattern varchar,
in do_not_continue integer,
in http_redirect_code integer);
|
Creates regex rules. |
Change the password of an existing user account. | |
create a new user account | |
This deletes a user ccount, optionally including schema objects, DAV resources and other possible resources owned by the user. | |
Retrieve a user option for a given user account. | |
Assign an existing role to an existing security object. | |
Removes a role from an existing security object. | |
create a new SQL role. Same as the create role statemen.. | |
Remove an existing role (group). | |
Set a user option for a given user account. | |
Allows dba to change a user's password. | |
Change the default catalog (qualifier/database) of a user account. | |
username
();
|
returns the login name of the current user |
Decodes a string previously encoded by uuencode | |
Encodes string or string session into sequence of printable characters, suitable for transfer via "ASCII-only" data channels | |
Encodes string or string session into sequence of printable characters, suitable for transfer via "ASCII-only" data channels | |
Checks the package has not been altered since installation | |
Checks the presence and correct versions of required packages and of the Virtuoso platform | |
Checks if the package can be uninstalled. | |
Signals package check failure | |
Invoke VAD installation process | |
executes statements of a SQL file | |
varchar DB.DBA.
VAD_PACK
(in sticker_uri varchar,
in base_uri_of_resources varchar,
in package_uri varchar);
|
get VAD resource |
execute without signalling errors | |
Vad package uninstallation | |
Returns the variance. | |
Returns the population variance. | |
Returns the sample variance. | |
prepares a remote DSN for use | |
varchar
vd_remote_proc_wrapper
(in dsn varchar,
in remote_name varchar,
in local_name varchar,
in metadata any,
out status_code varchar,
out error_message varchar,
in make_resultset integer,
in description varchar);
|
Creating a PL wrapper for remote procedure execution |
declares an existing table as resident on a DSN previously declared with vd_remote_data_source | |
Update VDB RPC cost statistics for given DSN | |
Disconnects a data source if no active transactions are using resources from it. | |
Estimate VDB RPC round-trip for a given DSN in milliseconds | |
make a vector | |
concatenate vectors | |
Void DB.DBA.
VHOST_DEFINE
(in vhost varchar,
in lhost varchar,
in lpath varchar,
in ppath varchar,
in is_dav boolean,
in is_brws boolean,
in def_page varchar,
in auth_fn varchar,
in realm varchar,
in ppr_fn varchar,
in vsp_user varchar,
in soap_user varchar,
in sec varchar,
in ses_vars boolean,
in soap_opts any,
in auth_opts any,
in opts any,
in is_default_host integer);
|
define a virtual host or virtual directory |
Void DB.DBA.
VHOST_REMOVE
(in vhost varchar,
in lhost varchar,
in lpath varchar,
in del_vsps integer);
|
remove a virtual host or virtual directory |
Return full name of configuration INI file | |
calculate on server-side a digest to perform a HTTP digest authentication | |
batch object
vt_batch
();
|
Returns a vt batch object. |
Specify a document to update in a vt batch. | |
Add words to a free text update batch. | |
Add offband information to a free text update batch. | |
Set batch mode update of free text indexing. | |
vt_create_text_index
(in table varchar,
in col varchar,
in id_col varchar,
in is_xml integer,
in defer_generation integer,
in clustered_columns any,
in use_hook_function integer,
[in language_name varchar],
[in encoding_name integer]);
|
Add text index to an existing table |
drop free text trigger | |
determines whether input is a noise word | |
decompose a datetime to its components | |
get number of week from a datetime | |
Returns a string containing a UDT definition | |
Request a security token from WST endpoint | |
Verifies X.509 certificate | |
Prints as a string a big number serialized as binary using base64 encoding | |
varchar
xenc_decrypt_soap
(in xml_text varchar,
in soap_version int,
in validate_flag int,
in encoding varchar,
in lang varchar,
in opts any,
out keys any);
|
Decrypt and verify a SOAP message |
Remove the temporary keys from user's space | |
varchar
xenc_encrypt
(in message varchar,
in soap_ver int,
in template varchar,
in ns any,
in xp-n varchar,
in ki-n any,
in what-n varchar,
... );
|
Encrypt and optionally sign a SOAP message |
Determine XML signature algorithm of a key | |
Determine a key identifier | |
Used to make a symmetric key. | |
Used to make a temporary session key. | |
Importing a triple-des key into user's repository | |
Used to make a symmetric key. | |
Used to make a temporary session key. | |
xenc_key_create_cert
(in name varchar,
in cert varchar,
in type varchar,
in fmt int,
in pkey varchar,
in pass varchar);
|
Import a key from a certificate |
Used to make asymmetric DSA key. | |
Importing a DSA key into user's repository | |
Check if named encryption key is in the user's repository | |
Key instance generation | |
This will delete a key from current user's space. | |
Importing a RSA key into user's repository | |
Extracts a key from user's repository | |
Export of a certificate and optionally private key in PEM format | |
Export of a certificate and private key into Personal Information Exchange Syntax (PKCS#12) format. | |
Associate a X.509 certificate with a key | |
Imports a public key from simple public key infrastructure (SPKI) | |
Exports a X.509 certificate from user's repository | |
xenc_x509_generate
(in ca_key_name varchar,
in public_key_name varchar,
in serial integer,
in validity integer,
in subject vector,
in extensions vector);
|
Generates a X.509v3 certificate using client's public key |
xenc_x509_ss_generate
(in key_name varchar,
in serial integer,
in validity integer,
in subject vector,
in extensions vector);
|
Creates a self-signed X.509v3 certificate |
Adds path to the internal list of system paths. | |
prepares and executes given SQL for XML string output | |
returns an XML DTD for the result of a SQL query with a FOR XML clause | |
returns an XML schema for the result of an SQL query with a FOR XML clause | |
xml_create_tables_from_mapping_schema_decl
(in base_uri varchar,
in mapping_schema_file varchar,
in content_encoding varchar,
in content_language varchar);
|
returns a vector containing strings. Each string is a command to drop a table or a foreign key or to create table. |
creates a new XML document which contains a copy of data pointed by given XML tree- or XPER- entity | |
varchar
xml_doc_output_option
(in xml_entity any,
in option_name varchar,
[in option_value varchar]);
|
|
Returns vector of all system paths. | |
xml_load_mapping_schema_decl
(in base_uri varchar,
in mapping_schema_file varchar,
in content_encoding varchar,
in content_language varchar);
|
creates a xml view from mapping schema. |
xml_load_schema_decl
(in base_uri varchar,
in document_uri varchar,
in content_encoding varchar,
in content_language varchar);
|
returns a string with list of errors detected by XML Schema processor on reading given XML Schema definition document. |
Returns a vector of all namespace declarations in all ancestors of the given XML entity. | |
xml_persistent
(in document varchar,
[in parser_mode integer],
[in base_uri varchar],
[in content_encoding varchar],
[in content_language varchar],
[in dtd_validator_config varchar]);
|
returns an entity object ('XPER entity') created from given XML document |
Registers the XML NS prefix as persistent or keeps it in properties of client connection depending on the persistance bits input value. | |
Execute XML template from Virtuoso PL | |
xml_tree
(in document varchar,
[in parser_mode integer],
[in base_uri varchar],
[in content_encoding varchar],
[in content_language varchar],
[in dtd_validator_config varchar]);
|
Parses an XML fragment and returns the parse tree as nested vectors. |
returns an entity object given a tree from xml_tree | |
Retrieve a resource based on a URI | |
xml_validate_dtd
(in document varchar,
in parser_mode integer,
in base_uri varchar,
in content_encoding varchar,
in content_language varchar,
in dtd_validator_config varchar);
|
returns a string with list of errors detected by DTD validator on reading given XML document |
xml_validate_schema
(in document varchar,
in parser_mode integer,
in base_uri varchar,
in content_encoding varchar,
in content_language varchar,
in dtd_validator_config varchar);
|
returns a string with list of errors detected by DTD and XML Schema validator on reading given XML document. |
returns an XML DTD for the output of given XML VIEW | |
returns an XML schema for the output of given XML VIEW | |
Add an attribute to the given node of an XML tree document | |
Produces a forest of elements from a collection of XML values | |
XMLAppendChildren
(inout source any,
in insertion1 any,
in insertion2 any,
...
,
in insertionN any);
|
Modify an XML document by adding new children to the given entity. |
XMLATTRIBUTES
(
string_expr1 [AS alias1] varchar,
[string_expr2 [AS alias2] varchar],
[...],
[string_exprN [AS aliasN] varchar]);
|
Creates a list of attributes and their values |
Creates a forest of elements by concatenating a list of XML values | |
XMLELEMENT
(
tag_name varchar,
[list_of_attributes sequence],
[child_or_attribute1 any],
[child_or_attribute2 any],
[...],
[child_or_attributeN any]);
|
Creates XML element |
XMLFOREST
(
string_expr1 [AS alias1] varchar,
[
string_expr2 [AS alias2] varchar
],
[
...
],
[
string_exprN [AS aliasN] varchar
]);
|
Produces a forest of XML elements |
Modify an XML document by inserting new children after the node specified by given entity. | |
Modify an XML document by inserting new children before the node specified by given entity. | |
any
XMLReplace
(inout source any,
in location1 any,
in replacement1 any,
in location2 any,
in replacement2 any,
in ...
,
in locationN any,
in replacementN any);
|
Modify a given XML document by replacing some nodes. |
Performs insert/update/delete operations based on an XML updategram. | |
structure
xmlStorageSystem.deleteMultipleFiles
(in email string,
in password string,
in relativepathList array);
|
Remove files from XML Storage System Directory |
Retrieve server specific information. | |
Mail password to user. | |
structure
xmlStorageSystem.registerUser
(in email string,
in name string,
in password string,
in clientPort integer,
in userAgent string,
in serialNumber string);
|
Register a user with the XML Storage System |
structure
xmlStorageSystem.saveMultipleFiles
(in email string,
in password string,
in relativepathList array,
in fileTextList array);
|
Upload a set of files to XML Storage System directory. |
Returns a copy of the given instance with the schema reference removed. | |
Returns a copy of the given instance with new schema reference. | |
static method
XMLType.createXML
(in src any,
[in schema_uri varchar],
[in validated integer],
[in wellformed any]);
|
Creates an XML Type instance. |
Tests node existence having evaluated given XPATH expression. | |
Evaluates given XPATH expression. | |
This function returns the serialization of the current node like XPATH function 'serialize()', i.e. a text in XML syntax. | |
Returns the namespace of the top level element providing the instance is schema-based rather than a fragment. | |
This function returns the integer-value of the current node like XPATH function 'number()'. | |
Returns top-level element of the given instance (NULL for fragment) | |
Returns the URL of the XML schema definition for schema based instances, NULL for non-schema based. | |
The function returns the string-value of the current node like XPATH function 'string()'. | |
The function returns 1 if the instance is an XML generic entity or 0 if it is a plain document. | |
Returns 1 if the given XMLType instance is schema-based, otherwise returns 0. | |
Validates the given XMLType instance against an arbitrary XML schema, returns 1 if successful, 0 if errors are detected. | |
Returns 1 or 0 indicating if the XML entity has been validated against the associated schema. | |
Validates the schema based XMLType instance against its schema and signals an error in case of failed validation. | |
Changes the internal "is validated" flag of the given XMLType instance. | |
constructor method
XMLType.XMLType
(in src any,
[in schema_uri any],
[in validated any],
[in wellformed any]);
|
|
any
XMLUpdate
(inout source any,
in path1 varchar,
in replacement1 any,
in path2 varchar,
in replacement2 any,
...
,
in pathN varchar,
in replacementN any);
|
Create a changed copy of given document by replacing some nodes. |
Returns the xml document corresponding to given XML view | |
xpath_eval
(in xpath_expression varchar,
in xml_tree XML Entity,
[in index integer],
[in named_params vector]);
|
Applies an XPATH expression to a context node and returns result(s). |
creates a new "persistent XML"document which contains a copy of data pointed by given XPER entity | |
xper_doc
(in document varchar,
[in parser_mode integer],
[in base_uri varchar],
[in content_encoding varchar],
[in content_language varchar],
[in dtd_validator_config varchar],
[in index_attrs integer]);
|
returns an entity object ('XPER entity') created from an XML document |
low-level navigation functions for persistent XMLs, useful for import of huge amounts of XML data | |
low-level navigation functions for persistent XMLs, useful for import of huge amounts of XML data | |
returns a smallest fragment of persistent XML entity object ('XPER entity') such that it contains some range of words in its text | |
low-level navigation functions for persistent XMLs, useful for import of huge amounts of XML data | |
low-level navigation functions for persistent XMLs, useful for import of huge amounts of XML data | |
low-level navigation functions for persistent XMLs, useful for import of huge amounts of XML data | |
low-level navigation functions for persistent XMLs, useful for import of huge amounts of XML data | |
declare an XPath extension function | |
discards an XPath extension function | |
xquery_eval
(in xquery_expression varchar,
in xml_tree XML Entity,
[in index integer],
[in named_params vector]);
|
Applies an XQUERY expression to a context node and returns result(s). |
returns an XML document transformed by an XSLT stylesheet | |
returns formatted string representation of a numeric value | |
declares an XSL stylesheet for use | |
force reload of XSL stylesheet | |
xte_head
(in tagname varchar,
[in attr1name varchar],
[in attr1val varchar],
... ,
[in attrNname varchar],
[in attrNval varchar]);
|
Returns the vector corresponding to a head of a XML element |
Returns the vector corresponding to a XML element | |
Returns the vector corresponding to a XML element | |
Adds to the first arguments all remaining arguments | |
Corrects input vector | |
Creates the empty vector | |
xtree_doc
(in document varchar,
[in parser_mode integer],
[in base_uri varchar],
[in content_encoding varchar],
[in content_language varchar],
[in dtd_validator_config varchar]);
|
returns an entity object created from an XML document |
decompose a datetime to its components |