XML FOR DOMINO


dataconnection element
Represents a connection made between a Notes field and an external data source.

Containment Hierarchy

Contained by: %design.elements;

Contains: %named.design.note.prolog; , %note.epilog;

Syntax

<!ELEMENT dataconnection (%named.design.note.prolog; , %note.epilog; )>

Content

%named.design.note.prolog; , %note.epilog;


Attributes

<!ATTLIST dataconnection

%named.design.note.attrs;
class(%dataconnection.class;)#REQUIRED
type(%dataconnection.types;)#REQUIRED
username%string;#IMPLIED
password%string;#IMPLIED
database%string;#IMPLIED
hoststring%string;#IMPLIED
sqlserver%string;#IMPLIED
datasource%string;#IMPLIED
objecttype(%dataconnection.object.types;)#IMPLIED
objectowner%string;#IMPLIED
objectname%string;#IMPLIED
objectopen%string;#IMPLIED
objectupdate%string;#IMPLIED
objectcreate%string;#IMPLIED
objectdelete%string;#IMPLIED
connections%integer;"1"
blockkeyfieldupdates%boolean;"false"
updatechangedfieldsonly%boolean;"false"
disablehttpcaching%boolean;"false"
fieldsgetdecserrors%boolean;"false"
spacetrim(%dataconnect.spacetrim.values;)"none"
conflictdetection%boolean;"false"
ondatamismatch(%dataconnection.ondatamismatch.values;)"precisionloss"
onmissingrecord(%dataconnection.onmissingrecord.values;)"error"
%dataconnection.customizedproperties.values;
>

blockkeyfieldupdates


class
conflictdetection
connections
database*
datasource*
disablehttpcaching
fieldsgetdecserrors
hoststring*
objectcreate
objectdelete
objectname
objectopen
objectowner
objecttype
objectupdate
ondatamismatch
onmissingrecord
password
spacetrim
sqlserver*
type
updatechangedfieldsonly
username
*These attributes indicate the name of the third-party database to access. The vendor-type determines which attributes are required. The following table illustrates which data source name attributes are required for the specified data connection types:
Data connection typeRequired data source name attributes
db2database only
odbc2datasource only
oledbdatabase and datasource
oracle and oracle8hoststring only
sybasedatabase and sqlserver

Defined entities for <dataconnection> element

The %dataconnect.spacetrim.values; entity defines which fields to trim leading and trailing spaces from.

Syntax:

<!ENTITY % dataconnect.spacetrim.values " none | nonkeyfields | allfields ">

The following options specify to trim the leading and trailing spaces from:

allfields


none
nonkeyfields
The %dataconnection.class; entity defines the class options of data sources that you can connect to using Lotus Domino.

Syntax:

<!ENTITY % dataconnection.class " rdbms ">

The following option specifies that the data source for the external connections is:

rdbms


The %dataconnection.customizedproperties.values; entity defines the customizations you can make that are specific and unique to the data source you are accessing.

Syntax:

<!ENTITY % dataconnection.customizedproperties.values " %db2properties; | %oledbproperties; | %odbcproperties; ">

The following options specify that additional customizations are available for the following data sources (See their entity descriptions below for a list of their attributes.):

%db2properties;

%oleproperties;

%odbcproperties;

The %dataconnection.object.types; entity defines the types of objects you can connect to using Lotus Domino.

Syntax:

<!ENTITY % dataconnection.object.types " table | view | procedure ">

procedure


table
view
The %dataconnection.ondatamismatch.values; entity defines how the Domino server should handle data conflicts.

Syntax:

<!ENTITY % dataconnection.ondatamismatch.values " error | precisionloss | datatruncation ">

datatruncation


error
precisionloss
The %dataconnection.onmissingrecord.values; entity defines how the Domino server should behave when it encounters a missing record.

Syntax:

<!ENTITY % dataconnection.onmissingrecord.values " error | ignore | externalrecord ">

error


externalrecord
ignore
The %dataconnection.types; entity defines the types of data sources you can connect to using Notes/Domino.

Syntax:

<!ENTITY % dataconnection.types " db2 | oracle | sybase | odbc2 | oracle8 | oledb ">

The %db2properties; entity defines the additional property settings you can make for data from a DB2 database.

Syntax:

<!ENTITY % db2properties "

datajournaling%boolean;#IMPLIED
">

The %odbcproperties; entity defines the additional property settings you can make for data from an ODBC database.

Syntax:

<!ENTITY % db2properties "

singlethreading%boolean;#IMPLIED
">

The %oledbproperties; entity defines the additional property settings you can make for data from an OLE database.

Syntax:

<!ENTITY % db2properties "

oledbprovider%string;#IMPLIED
oledbdatasource%string;#IMPLIED
oledbdatabase%string;#IMPLIED
oledbproviderstring%string;#IMPLIED
oledbauthentication%string;#IMPLIED
">

See Also