sql_write_private_profile

Name

sql_write_private_profile_string — Sets a DSN's attribute value

Synopsis

`integer sql_write_private_profile_string (`	in `dsn` varchar ,
	in `type` varchar ,
	in `name` varchar ,
	in `value` varchar `)`;

Description

This function corresponds to the ODBC catalog call of similar name. It and related functions are used by the virtual database to query remote data dictionaries.

The type argument must be either 'system' or 'user'.

Sets a data source attribute by calling SQLWritePrivateProfileString from the ODBC Installer API.

Parameters

type denotes the DSN type.

others are passed to the SQLWritePrivateProfileString

Return Types

Returns the SQL state.

Prev	Up	Next
sql_procedures	Home	sql_get_private_profile_string

Prefix	IRI
n4	http://docs.openlinksw.com/virtuoso/fn_sql_write_private_profile_string/
schema	http://schema.org/
n5	http://creativecommons.org/licenses/by/4.0/
rdf	http://www.w3.org/1999/02/22-rdf-syntax-ns#
n3	http://www.openlinksw.com/#
xsdh	http://www.w3.org/2001/XMLSchema#

Prefix	URI
xmlns:n4	http://docs.openlinksw.com/virtuoso/fn_sql_write_private_profile_string/
xmlns:schema	http://schema.org/
xmlns:n5	http://creativecommons.org/licenses/by/4.0/
xmlns:rdf	http://www.w3.org/1999/02/22-rdf-syntax-ns#
xmlns:n3	http://www.openlinksw.com/#
xmlns:xsdh	http://www.w3.org/2001/XMLSchema#

Subject	Predicate	Object
n4:	rdf:type	schema:APIReference
n4:	rdf:type	schema:TechArticle
n4:	schema:name	sql_write_private_profile_string
n4:	schema:copyrightHolder	_:vb80072
n4:	schema:datePublished	2016-09-09 16:16:54
n4:	schema:headline	sql_write_private_profile_string
n4:	schema:keywords	OpenLink,Virtuoso,database,RDBMS,relational,SQL,RDF,triple store,linked data,linked open data,Big Data,function,API,reference,sql_write_private_profile_string,ODBC
n4:	schema:license	n5:deed.en_US
n4:	schema:publisher	_:vb80071
n4:	schema:url	n4:
_:vb80071	rdf:type	schema:Organization
_:vb80071	schema:name	OpenLink Software
_:vb80071	schema:url	n3:this
_:vb80072	rdf:type	schema:Organization
_:vb80072	schema:name	OpenLink Software
_:vb80072	schema:url	n3:this