<das:sql-data-source> describes the structure of the SQL query result.

 

The following samples illustrates a query that selects records from the table emp given the specified employee id.

 

Attributes:

 

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

select - the query which is to be applied to 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:in-param> - a parameter for the SQL query.

 

Note. Table emp can be found in emp.mdb database in Samples\Database Sample folder.

 

 

<das:sql-data-source id="ds1" connection="con1" select="select * from emp where Id=@theID">

 <das:in-param id="p1" name="theID" value="ret1"/>

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

 <das:field id="fld2" name="First Name"/>

 <das:field id="fld3" name="Last Name"/>

</das:sql-data-source>

 

 

<das:sql-data-source id="ds2" connection="con2" select="select * from emp where Id=:theID">

 <das:in-param id="p2" name="theID" value="ret2"/>

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

 <das:field id="fld5" name="First Name"/>

 <das:field id="fld6" name="Last Name"/>

</das:sql-data-source>