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;

Contains any of the contents of the %named.design.note.prolog; entity, followed by any of the contents of the %note.epilog; entity.

<!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

Indicates whether to allow the key field to be updated. Default is false.

Type of data source the external connection is being made to. See the %dataconnections.class; entity for a list of options.

Boolean value. If true, instructs Notes/Domino to throw an error when there is a data conflict during a transfer. Default is false.

Maximum number of concurrent connections that should be made to an external data source.

Name of the external database you want to access. This attribute is only an option if the type attribute equals DB2, Sybase, or OLE DB.

Data source name of the external database you want to access. This attribute is only an option if the type attribute equals OLE DB.

Indicates whether the server should cache data extracted from the external database. If the data source contains mostly static data, you may want to disable caching. Do not disable caching for a transactional processing system where the data is frequently changing. Default is false.

Indicates whether errors on individual field updates should be recorded in the corresponding Notes fields. If false, fields remain blank if there is an error in the data transfer.

Host string of the external database you want to access. This attribute is only an option if the type attribute equals Oracle or Oracle 8.

Name of the procedure to associate with the Create event.

Name of the procedure to associate with the Delete event.

Name of the metadata object to connect to.

Name of the procedure to associate with the Open event.

Owner of the metadata object to connect to.

Type of object to access data from in the external data source. See the dataconnection.object.types; entity for a list of options.

Name of the procedure to associate with the Update event.

Instructs Notes/Domino on how to proceed if it encounters a data conflict. See the %dataconnection.ondatamismatch.values; entity for a list of options.

Instructs Notes/Domino on how to proceed if it encounters a missing record. See the %dataconnection.onmissingrecord.values; entity for a list of options.

Password associated with the user name authorized to access the third party database.

Indicates whether to trim the leading and trailing spaces of a field, and if so, which fields to trim. See the %dataconnect.spacetrim.values; entity for a list of options.

Name of the SQL server hosting the Sybase database you want to access. This attribute is only an option if the type attribute equals Sybase.

Vendor type of the third-party data source. The choices for this attribute depend on the class type. See the %dataconnection.types; entity for a list of options.

If true, triggers the exchange of data only when an update to a field has been made.

User name authorized to access the third-party database.

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

All of the fields.

None of the fields.

Only the non-key fields.

Syntax:

<!ENTITY % dataconnection.class " rdbms ">

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

rdbms

A relational database management system.

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

Commands with which you create, update, and query a database. This option is not applicable to ODBC data sources.

Data table which is a collection of records with fields in a database.

Data view.

Syntax:

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

datatruncation

Specifies that the server should allow data truncation. Data truncation is not performed on key fields. You might want to allow for this in order to enable the extraction of a string, for example, from a field in a database having a greater maximum allowable string length to a Notes field having a smaller maximum allowable length.

Specifies that the server should return an error on data conflict.

Specifies that the server should allow precision loss. You might want to allow for this in order to enable the extraction of a number, for example, from a field in a database that records numbers with more extensive precision than a Notes database does.

Syntax:

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

error

Specifies that the server should return an error message when it encounters a missing record in the external data source.

Specifies that a record should be created in the external data source to prevent the data transferal from stopping. Creates a stub in the external data source.

Specifies that the server should ignore any missing record errors encountered and continue the retrieval.

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

The Domino DTD

Glossary