Sample: Map a Table and
Retrieve Rows from a Result Set
Objective
The objective of this sample is to
demonstrate how to:
- Create a simple mapping for a database
table.
- Write a program that uses the methods
fetchNext and element to process a result set.
The sample database you will use must be set up
before you work with the sample. See Preparation for Samples for information.
Description
This sample does the following:
- Connects to the database.
- Opens a cursor on the table using the open
method to get department result set.
- Uses the fetchNext method to fetch a row.
- Uses the element method to get the
contents of the row.
- Prints the row.
- Repeats steps 3 to 5 to retrieve and print
each row of result set.
- Closes the cursor.
- Disconnects from the database.
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:
- DepartmentManager - open, element,
fetchNext, close
- DepartmentDatastore - connect, disconnect
Some of the methods listed are inherited from
the Data Access class library.
Running the Sample
The executable for the sample is called curfetch.
Since Data Access Builder generates code for three access methods
(CLI, ESQL, and ODBC), a curfetch 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:
curfetch
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:
curfetch userid password
The source code for the curfetch 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:
- In the IDE, create a new
project, an executable target, and a new Data Access
part. When you choose to add a Data Access part, the Data
Access SmartGuide will start up.
- To create the schema
mapping in the SmartGuide pages, do the following steps:
- On the overview
page of the SmartGuide, click Next>>
to go to the next page.
- If you are using
DB2, select DB2 Driver and select the database SAMPLE;
if you are using dBase, select ODBC Driver and
select the database CPPASAMP40.
- Select By
selecting database tables or views for
the method to create the schema mapping. Click Next>>
to go to the next page.
- If you are using
DB2, select the desired database access method
(DB2 CLI or DB2 ESQL). Click Next>>
to go to the next page. If you are using ODBC,
you will not see this page.
- Click Get
Tables with Filter and when the list of
tables is displayed, select DEPARTMENT for DB2 or DEPT for dBase.
- Click Finish.
You will return to the IDE.
- Edit the new Data Access
part by clicking the Edit Part button.
This will launch the Data Access Builder main window.
- Select Properties
from the mapping icon's
popup menu.
Ensure the Class Name field contains
"Department" and the File Stem
field contains "Dept".
- Change the deptno
attribute to be a data ID by doing the following steps:
- Select the Department
mapping icon. Select Attributes
from its popup menu.
- From the list of
attributes, select the deptno
row.
- Enable the Data
Identifier check box (near the bottom of
the dialog).
- Click OK
to close the notebook.
- In the Data Access Builder
window, select Save from the File
menu to save the mapping.
- Select the mapping icon
and select Generate from its popup menu
to generate the C++ classes. Exit Data Access Builder.
- Return to the IDE and
build the part.

Data
Access Builder
Data
Access Builder Workflow
Keyless
Table Support and Data Identifiers

Data Access
Class Library and Generated Class Reference
Data Access Builder
Samples
Preparation for
Samples