| Checks a table for grants. | |
| Returns prefix by given URI. | |
| Returns URI by given namespace prefix. | |
| Return the absolute value of a number | |
| trigonometric functions | |
| Returns false if a value of some argument is false, otherwise returns true. | |
| Adds phrases to given set. | |
| Returns report of all occurrences of phrases from the specified sets in the text. | |
| 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. | |
| 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 | |
| Write data into transaction log format for backup purposes. Deprecated. | |
|
int
backup_online
(
in file_prefix varchar
,
in pages integer
,
[in timeout integer]
,
[in dirs any]
);
|
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 | |
| 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 | |
| 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 | |
| get connection identifier | |
| check if current session connection variables have been altered | |
| Associates a value to the name in the context of the present connection | |
| 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. | |
| get current date and time | |
| get current date and time | |
|
node-set
current
|
Returns a node-set that has the current node as its only member. |
| Get name of current charset. | |
| 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 | |
|
any
DAV_DIR_LIST
(
in path varchar
,
in recursive integer
,
in auth_uid varchar
,
in auth_pwd varchar
);
|
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 | |
|
any
DAV_UNLOCK
(
in path varchar
,
in token varchar
,
in auth_uname varchar
,
in auth_pwd varchar
);
|
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 | |
| Returns APC_ID of a phrase class. | |
| Deletes phrase set. | |
| Alters IRI_ID columns to get IRI_ID_8. | |
| Fix RDF metadata corruption. | |
| Makes a backup copy of RDF metadata (i.e., descriptions of RDF Views and the like). | |
| Converts rdf xml to ttl. | |
| Translates a geometry into a RDF box | |
| Converts geo:lat and geo:long properties properties into geometries. | |
| Returns 1 if language identifier r matches lang pattern t. | |
| Parses the content of RDF/XML text as a sequence of separate RDF triples. | |
| 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'. | |
| 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. | |
| Remote execution of SPARQL via SPARQL protocol, produces a result set of SQL values. | |
| Remote execution of SPARQL via SPARQL protocol, produces a vector of vectors of SQL value. | |
| 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. | |
| parses TTL (TURTLE or N3 resource) and places its triples into DB.DBA.RDF_QUAD on multiple threads. | |
| 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 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 | |
| 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. | |
| Deletes a geometry from an R tree index. | |
| Inserts a geometry from an R tree index. | |
|
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 | |
| Find a value in keyword vector (search uppercase) | |
| returns the timestamp of the current transaction | |
| 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 |
| 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 | |
| returns header of current HTTP request | |
| Kill VSP process whose details match parameter inputs | |
|
integer
http_listen_host
(
in interface_address varchar
,
in action integer
,
[in options vector]
);
|
Starts, stops and retrieves the state of a user-defined HTTP listener |
| get values from HTTP virtual host path mapping 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 | |
| returns the absolute path to the logical path location of the current http request | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| Splits into the namespace prefix and the local part according to the TTL rules. | |
| 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 1 if the argument is a geometry. | |
| 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 non-blank IRI | |
| returns true if its argument is of type varchar | |
| returns true if argument is numeric zero | |
| Gets a property value from a Java class instance. | |
| Declares a Java class to a Java VM | |
| Creates and instance of a Java class. | |
| Sets a Java class property | |
| 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 |
|
array
nntp_auth_post
(
in server varchar
,
in user varchar
,
in password varchar
,
in body varchar
);
|
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. | |
| 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 | |
| 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 |
| 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() | |
| Adds the applicable facts of the graph into a rule set. | |
|
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 | |
| 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 |
|
None
REPL_ADD_DAV_CR
(
in col varchar
,
in name_suffix varchar
,
in order integer
,
in class varchar
);
|
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 | |
| add item to a publication | |
| create initial image of publication on publisher | |
| remove item from publication. | |
| create publication on publisher | |
| purges transactional replication logs for specified account | |
| revoke privileges for subscription | |
| 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 | |
| retrieve status of all subscriptions and publications | |
| returns status of a published or subscribed publication | |
| add a subscription | |
| starts the syncing process against an existing subscription | |
| synchronize all subscriptions | |
| adds a SQL statement to the log of the replication | |
| 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. | |
| execute a SQL statement on a remote DSN | |
| get n rightmost characters of a string | |
| 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. | |
| 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 | |
| Returns excerpts with hit words from text | |
| decompose a datetime to its components | |
| get second from a datetime | |
| 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 |
| 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. | |
|
integer
set_identity_column
(
in table_name varchar
,
in column_name varchar
,
in new_value integer
);
|
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. | |
| Creates a key mapping function & table. | |
| 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 |
|
(
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. |
| 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. |
| 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 | |
|
vector or string
split_and_decode
(
in coded_str varchar
,
[in case_mode integer]
,
[in str varchar]
);
|
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 | |
| 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 |
|
vector
sql_procedures
(
in dsn varchar
,
in qualifier varchar
,
in owner varchar
,
in name varchar
);
|
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 the well known text (WKT) representation of the geometry. | |
| Returns true if all points of a given geometry g2 are in another geometry g1. | |
| Returns the shortest distance between two points. | |
| Parses the string and returns the corresponding geometry. | |
| Returns intersects between two geometries. | |
| Returns a point geometry. | |
| The geometry given as argument is modified to have the specified srid and the modified geometry is returned. | |
| Returns the srid of a geometry. | |