Objective
The objective of this sample demonstrates how to:
The sample database you will use must be set up before you run the sample. See Preparation for Samples for information.
Description
This sample does the following:
Generated Data Access Classes Used by this Sample
This sample uses the following generated classes and
methods, as defined in the Data Access mapping, minisamp.dax (the
table join is called Query):
Some of the methods listed are inherited from the Data Access class library.
Running the Sample
The executable for the sample is called tabljoin.
Since Data Access Builder generates code for three access methods
(CLI, ESQL, and ODBC), a tabljoin executable is located in each
of three corresponding directories: db2cli, db2esql, and odbc
(all of these are subdirectories of samples\database\minisamp).
To run the sample, enter the following on the command line of the appropriate directory:
tabljoin
If the sample fails because it could not connect to the database, enter a user ID and password that is valid for accessing the sample database, as shown:
tabljoin userid password
The source code for the tabljoin executables is located in the samples\database\minisamp\source directory. If you make changes to the sample's source code, you must import the sample into an IDE project and rebuild it.
The Data Access Builder Mapping
The Data Access samples use a complex mapping, which is
provided for you in a file called minisamp.dax. One minisamp.dax
mapping file is provided in each of the three directories:
db2cli, db2esql, and odbc. If you want to see the mapping or
generate the classes for it, import the sample into the IDE; in
the Data Access Launch view, select the part and click Edit
Part.
Hints on How to Create A Mapping for This Sample
Rather than using the mapping provided with the samples
(minisamp.dax), you can create your own mapping that will work
with this sample (but not necessarily the other samples). To
create a mapping for this sample, follow these steps:
or the
following for dBase:
select d.deptname, e.firstnme, e.midinit,
e.lastname from empl e,
dept d where d.deptno=e.workdept
Warning! If you are using DB2, the following lines must be in the DB2CLI.INI file in the SQLLIB directory, or else the validate action will return without an error message regardless of the SQL statement's actual validity:
[common] DEFERREDPREPARE=0
![]()
Data Access Builder
Data Access Builder
Workflow
Table Joins and Query
Support
![]()
Data Access Class Library
and Generated Class Reference
Data Access Builder Samples
Preparation for Samples
