<das:table-data-source> element represents a table in a conventional relational model database.

 

In the following sample, two tables are defined with a foreign-key constraint between them.

 

Attributes:

 

id - unique identifier of this resource in the current processing job.

name - a name by which the table is recognized in the database.

connection - the id of the element in the job that identifies a connection to a database.

 

Children Elements:

 

<das:field> - describes a column of the parent table.

<das:foreign-key> - describes a foreign key constraint between two tables.

 

Note: Tables emp and hist can be found in emp.mdb database in Samples\Database Sample folder.

 

 

<das:table-data-source id="ds1" connection="con1" name="emp">

 <das:field id="fld1" name="ID"/>

 <das:field id="fld2" name="FIRST_NAME"/>

 <das:field id="fld3" name="LAST_NAME"/>

</das:table-data-source>

 

<das:table-data-source id="ds2" connection="con1" name="hist">

 <das:field id="fld4" name="EMP_ID"/>

 <das:field id="fld5" name="DATE_MODIFIED"/>

 <das:field id="fld6" name="DEPARTMENT"/>

 <das:foreign-key id="fkey" parent-key="ID" key="EMP_ID" parent-id="ds1"/>

</das:table-data-source>:table-data-source>