Power GUI Programming with VisualAge C++/powergui.iso/trialva/ibmcppw/help/idata.hlp

OS/2 Help File | 1996-02-22 | 42.2 KB | 1,201 lines

ΓòÉΓòÉΓòÉ 1. File ΓòÉΓòÉΓòÉ

Select an item from the File menu to create classes or to perform file
management tasks in Data Access Builder.

Select from the following list to get information about the items in the File
menu:

 o New...
 o Create classes...
 o Open...
 o Save
 o Save as...
 o Exit

 Select from the following list to get related information from an online book:

 o Accessing Database Tables/Views
 o Saving a Data Access Builder Session
 o Saving a Data Access Builder Session under Another Name
 o Opening a Previously Saved Data Access Builder Session


ΓòÉΓòÉΓòÉ 2. View ΓòÉΓòÉΓòÉ

Select an item from the View menu to change how objects are displayed in the
Data Access Builder client area.

You can display the table-to-class mapping arrows in a horizontal
(left-to-right) or a vertical (top-to-bottom) orientation.

You can also change the size of the icons in the client area (small, medium, or
large).

Select from the following list to get information about the items in the View
menu:

 o Horizontal
 o Vertical
 o Icon size
 o Save and restore window size/position


ΓòÉΓòÉΓòÉ 3. Options ΓòÉΓòÉΓòÉ

Select an item from the Options menu to customize the way you interact with
Data Access Builder, and to specify the type of source code that you want Data
Access Builder to generate by default.

Select from the following list to get information about the items in the
Options menu:

 o Startup window
 o Information line
 o Confirm on delete
 o Full path in title bar
 o Class options...
 o Register Databases


ΓòÉΓòÉΓòÉ 4. Help ΓòÉΓòÉΓòÉ

Select an item from the Help menu to get online information about using Data
Access Builder.

Select from the following list to get information about the items in the Help
menu:

 o General help...
 o Using help...
 o How do I...
 o Product information...


ΓòÉΓòÉΓòÉ 5. New... ΓòÉΓòÉΓòÉ

Select New... from the File menu to end the current Data Access Builder session
and start a new one. If there are unsaved changes in the current session, you
are prompted to save or to discard them.

Select from the following list to get related online help:

 o Create classes
 o Open...
 o Save
 o Save as...


ΓòÉΓòÉΓòÉ 6. Create classes... ΓòÉΓòÉΓòÉ

Select Create classes... from the File menu to create new classes from tables
or views in your database.

Note:   If a table or a view is already mapped to a class in the client area,
use Create class from the pop-up menu of that table or view to create another
class from it. A table or view can only be represented by one object at a time
in the client area.

Select from the following list to get related online help:

 o Create classes
 o Table or View.

 Select Accessing Database Tables/Views to get related information from an
 online book.


ΓòÉΓòÉΓòÉ 7. Open... ΓòÉΓòÉΓòÉ

Select Open... from the File menu to retrieve a saved Data Access Builder
session. Table information in the saved session is not synchronized with the
database catalog. If there are unsaved changes in the current session, you are
prompted to save or to discard them. (Open... does not append the saved session
to the current session.)

Select from the following list to get related online help:

 o Save
 o Save as...

 Select Opening a Previously Saved Data Access Builder Session to get related
 information from an online book.


ΓòÉΓòÉΓòÉ 8. Save ΓòÉΓòÉΓòÉ

Select Save from the File menu to save the current Data Access Builder session.
The current session consists of all objects displayed in the client area, and
the settings for those objects.

If the session has been saved before, the current session is saved under the
existing file name, and replaces the contents of the existing file. The
existing file name (if any) is displayed in the title bar.

If the session has not been saved before, the Save as... window displays, and
you are prompted to specify a file name. Use .dax as the file extension.

Select from the following list to get related online help:

 o Save as...
 o Open settings - Class
 o Delete - Class


ΓòÉΓòÉΓòÉ 9. Save as... ΓòÉΓòÉΓòÉ

Select Save as... from the File menu to save the current Data Access Builder
session under a new file name. The current session consists of all objects
displayed in the client area, and the settings for those objects.

Use Save as... to save a session that has not been saved before, or to save a
session without overwriting the contents of an existing file. The existing file
name (if any) is displayed in the title bar.

If you specify an existing file name, you are asked whether you want to
overwrite the contents of the existing file.

Select from the following list to get related online help:

 o Save As
 o Save


ΓòÉΓòÉΓòÉ 10. Horizontal ΓòÉΓòÉΓòÉ

Select Horizontal from the View menu to display the table objects mapped to
their class objects from left to right.

A check mark appears beside Horizontal when it is selected. To turn this
selection off, select Vertical, the alternate mapping orientation.

Select Vertical to get related online help.


ΓòÉΓòÉΓòÉ 11. Vertical ΓòÉΓòÉΓòÉ

Select Vertical from the View menu to display the table objects mapped to their
class objects from top to bottom.

A check mark appears beside Vertical when it is selected. To turn this
selection off, select Horizontal, the alternate mapping orientation.

Select Horizontal to get related online help.


ΓòÉΓòÉΓòÉ 12. Save and restore window size/position ΓòÉΓòÉΓòÉ

Select Save and restore window size/position from the View menu to save the
current window size and position for use in future Data Access Builder
sessions.

To turn this option on, select the menu item to display the check mark. To turn
this option off, select the menu item again to remove the check mark.


ΓòÉΓòÉΓòÉ 13. Startup window ΓòÉΓòÉΓòÉ

Select the Startup window item from the Options menu to control whether the
Startup window appears in the client area each time you start Data Access
Builder. A check mark appears beside Startup window when this option is
selected.

To turn this option on, select the menu item to display the check mark. The
next time you start Data Access Builder, the Startup window is displayed.

To turn this option off, do one of the following:

 o Select the Startup window item from the Options menu to remove the check
   mark
 o Click in the check box in the Startup window to remove the check mark.

 Select Data Access Builder - Startup to get related online help.


ΓòÉΓòÉΓòÉ 14. Information line ΓòÉΓòÉΓòÉ

Select Information line from the Options menu to control whether an information
line appears at the bottom of the client area while you are using Data Access
Builder. A check mark appears beside Information line when this option is on.

The information line displays messages about using the Data Access Builder
interface, and about the status of actions you initiate.

To turn this option on, select Information line to display the check mark. To
turn it off, select Information line again to remove the check mark.


ΓòÉΓòÉΓòÉ 15. Class options... ΓòÉΓòÉΓòÉ

Select Class options... from the Options menu to see and change the options
that appear in the Class Options window. You can:

 o Set the source code type (Visual Builder, IDL, or C++)
 o Set the access method you will use to access the database. The methods that
   are available to you depend on which database product you have chosen. If
   you selected DB2 version 1.2, the only available option is embedded SQL. If
   you selected DB2 version 2.1, there are two available options: embedded SQL,
   and DB2 CLI. If, however, your datasource is ODBC, the only available option
   is ODBC CLI.
 o Specify where the source code is to be generated.

 If you do not want to be prompted with the Class Options window each time you
 create a class, click on the check box at the bottom of the window.

 Select from the following list to get related online help:

 o Create Class - Class Options
 o Class Options
 o Generate

 Select Specifying Default Generation Options to get related information from
 an online book.


ΓòÉΓòÉΓòÉ 16. Register Databases ΓòÉΓòÉΓòÉ

Select Register Databases from the Options menu to have Data Access Builder
search your workstation for all recognized database products. This is done
automatically the first time that Data Access Builder is started on a specific
workstation, but if you upgrade, add, or remove database products, you must
register the changes so that Data Access Builder can recognize them when
creating classes.

Select Create classes to get related online help.


ΓòÉΓòÉΓòÉ 17. General help... ΓòÉΓòÉΓòÉ

Select General help... from the Help menu to display information about the
active Data Access Builder window.


ΓòÉΓòÉΓòÉ 18. Using help... ΓòÉΓòÉΓòÉ

Select Using help... from the Help menu to display information about using the
online help facility.


ΓòÉΓòÉΓòÉ 19. How do I... ΓòÉΓòÉΓòÉ

Select How do I... from the Help menu to get help for a Data Access Builder
task. In the Data Access Builder: How Do I... help window, you can select from
a list of tasks, or you can search for a specific task.


ΓòÉΓòÉΓòÉ 20. VisualAge for C++ Help Menu Items ΓòÉΓòÉΓòÉ

The central portion of the Help pull-down menu is dedicated to all the online
documentation that is shipped with VisualAge for C++. Making a selection from
any of these cascade menus launches the VisualAge for C++ documentation
associated with the menu item. You can find the same documentation in the
Information notebook found in the VisualAge for C++ Desktop folder.

The cascade menus are organized as follows:

 At A Glance
           Provides general information about VisualAge for C++, such as
           installing the product, a notebook that accesses the sample
           programs, and answers to frequently asked questions.

 Using VisualAge for C++
           Provides direct access to the individual sections of the User's
           Guide. For example, if you are using the Browser, you would look in
           the Browsing section for more information.

 How Do I... Selections
           Provides access to the How Do I... information for each component of
           VisualAge for C++. Use How Do I... information to find out how to
           perform common tasks within VisualAge for C++.

 C/C++
           Provides access to the information that is specific to programming
           in C and C++.

 Class Libraries
           Provides access to the Open Class Library documentation.

 Visual Programming
           Provides access to the information that is specific to creating your
           programs visually.

 IPF, REXX, and Editing
           Provides access to the IPF and Editor references.

 SOM
           Provides access to the information that is specific to SOM.


ΓòÉΓòÉΓòÉ 21. Product information... ΓòÉΓòÉΓòÉ

Select Product information... from the Help menu to see the product information
window for VisualAge for C++.


ΓòÉΓòÉΓòÉ 22. Confirm on delete ΓòÉΓòÉΓòÉ

Select Confirm on delete from the Options menu to control whether you are asked
to confirm each delete action before it is completed. A check mark appears
beside Confirm on delete when this option is on.

To turn this option on, select Confirm on delete to display the check mark.

To turn this option off, select Confirm on delete again to remove the check
mark.

Select from the following list to get related online help:

 o Delete - Table or View
 o Delete - Class


ΓòÉΓòÉΓòÉ 23. Icon size ΓòÉΓòÉΓòÉ

Select Icon size from the View menu to change the size of the icons. Icons can
be small, medium, or large (default). Small icons reduce the need for scrolling
when there are many objects in the client area.

To override the default setting, select the Icon size arrow push button to see
the three options in a cascade menu, and then click on the option you want.

Select from the following list to get related online help:

 o Horizontal
 o Vertical


ΓòÉΓòÉΓòÉ 24. Full path in title bar ΓòÉΓòÉΓòÉ

Select Full path in title bar from the Options menu to control whether the full
path name of the saved Data Access Builder session appears in the window title
bar while you are using Data Access Builder. A check mark appears beside Full
path in title bar when this option is on.

To turn this option on, select Full path in title bar to display the check
mark.

To turn the option off, select Full path in title bar again to remove the check
mark.


ΓòÉΓòÉΓòÉ 25. Exit ΓòÉΓòÉΓòÉ

Select Exit from the File menu to close all windows and exit Data Access
Builder. If there are unsaved changes in the current session, you are prompted
to save or to discard them.


ΓòÉΓòÉΓòÉ 26. Open settings - Table or View ΓòÉΓòÉΓòÉ

Select Open settings from the Table or the View pop-up menu to open the
Settings notebook for a table or a view object in the client area. The Settings
notebook shows you details about the table or the view as it is defined in the
database. This information is read-only; you cannot change it.

Updates to the database table are not automatically reflected in the Settings
notebook. To change the information in the Settings notebook, delete the old
mapping, recreate the class, and then customize as required.

The Settings notebook for a table has three pages: Table, Columns, and Foreign
keys.

The Settings notebook for a view has two pages: View, and Columns.

Select from the following list to get related online help:

 o Table
 o Columns - Table
 o Foreign keys
 o View
 o Columns - View


ΓòÉΓòÉΓòÉ 27. Table or View ΓòÉΓòÉΓòÉ

Select an item from the Table or the View pop-up menu to perform actions on a
table or a view object in the client area. The following actions are available:

 o Open settings
 o Delete
 o Create class.

 To display the Table or the View pop-up menu, move the mouse pointer to the
 table or the view object you want to work with, and then click mouse button 2.

 Select from the following list to get related online help:

 o Open settings - Table or View
 o Delete - Table or View
 o Create class


ΓòÉΓòÉΓòÉ 28. Delete - Table or View ΓòÉΓòÉΓòÉ

Select Delete from the Table or the View pop-up menu to delete a table or a
view object from the client area. The object is not dropped from the database
to which you are connected.

Attention: This action deletes the entire mapping. If Confirm on delete in the
Options pull-down menu is not checked, you are not prompted before deletion.

Select from the following list to get related online help:

 o Delete - Class
 o Confirm on delete


ΓòÉΓòÉΓòÉ 29. Create class ΓòÉΓòÉΓòÉ

Select Create class from the Table or the View pop-up menu to create a new
class from an existing database table or view. The table or the view to be used
is the object you clicked with mouse button 2 to get the Table or the View
pop-up menu. The Class Options window then prompts you to:

 o Set the source code type (Visual Builder, IDL, or C++)
 o Set the access method you will use to access the database. The methods that
   are available to you depend on which database product you have chosen. If
   you selected DB2 version 1.2, the only available option is embedded SQL. If
   you selected DB2 version 2.1, there are two available options: embedded SQL,
   and DB2 CLI. If, however, your datasource is ODBC, the only available option
   is ODBC CLI.

 To turn this prompting off:

  1. Select Class options... from the Options pull-down menu.
  2. Click in the Use these defaults without prompting check box.
  3. Click on the OK push button.

 The new class is created with a default name and other settings. If you create
 more than one class from the same table or view, they will have similar
 default names, such as, for example: Name, Name1, Name2, and so on. To view or
 change these settings, select Open settings from the pop-up menu of the new
 class, or double-click on the new class object.

 Select from the following list to get related online help:

 o Create classes...
 o Open settings - Class
 o Delete - Class

 Select from the following list to get related information from an online book:

 o Accessing Database Tables/Views


ΓòÉΓòÉΓòÉ 30. Open settings - Class ΓòÉΓòÉΓòÉ

Select Open settings from the Class pop-up menu to open the Settings notebook
for a class object in the client area. You can then see or change the
information about a class. You can also change the mapping between a class and
its table.

The class Settings notebook has three pages: Names, Attributes, and Part or IDL
Methods. The source code type (Visual Builder or IDL) that you selected in the
Class Options window determines the methods that are displayed.

If you change any of the notebook settings after source code has been
generated, the color of the class icon's table piece changes from yellow,
green, or purple to black and white.

Select from the following list to get related online help:

 o Names
 o Attributes
 o Part Methods
 o IDL Methods

 Select from the following list to get related information from an online book:

 o Customizing the Class Mapping


ΓòÉΓòÉΓòÉ 31. Class ΓòÉΓòÉΓòÉ

Select an item from the Class pop-up menu to perform actions on a class object
in the client area. The following actions are available:

 o Open settings
 o Delete
 o Generate
 o View source (available only after source code has been generated).

 To display the Class pop-up menu, move the mouse pointer to the class object
 you want to work with, and then click mouse button 2.

 Select from the following list to get related online help:

 o Open settings - Class
 o Delete - Class
 o Generate
 o View source...

 Select from the following list to get related information from an online book:


ΓòÉΓòÉΓòÉ 32. Delete - Class ΓòÉΓòÉΓòÉ

Select Delete from the Class pop-up menu to delete a class object and all its
settings from the client area. Any source files already generated for that
class will not be erased.

Attention: If Confirm on delete in the Options pull-down menu is not checked,
you are not prompted before deletion.

Select from the following list to get related online help:

 o Delete - Table or View
 o Confirm on delete


ΓòÉΓòÉΓòÉ 33. Generate ΓòÉΓòÉΓòÉ

Select Generate from the Class pop-up menu to produce source code for a class
in the client area. The class to be used is the object you clicked with mouse
button 2 to get the Class pop-up menu.

Note:   A class must have at least one attribute mapped to a column, and at
least one data identifier defined, before you can generate code for it.

You can generate Visual Builder parts, IDL source code, or native C++ code. You
cannot choose the code type through this menu item; to change the generated
code type, you must create a new class.

To change the default setting:

  1. Select Class options... from the Options pull-down menu.
  2. Select one or more radio buttons in the Class Options window.
  3. Click on the OK push button.

 After source code is generated, the class icon color changes to one of the
 following:

 o Yellow (Visual Builder)
 o Green (IDL)
 o Purple (C++).

 If you are using WorkFrame, the source files are saved in your project
 directory; otherwise, the source files are saved in the directory specified in
 the Class Options window.

 Select from the following list to get related online help:

 o Class options...
 o View source...

 Select from the following list to get related information from an online book:

 o Generating the Class Source Code
 o Viewing Generated Files
 o Accessing Data Using Visual Builder Programs
 o Accessing Data Using C++ Programs
 o Accessing Data Using SOM Programs


ΓòÉΓòÉΓòÉ 34. View source... ΓòÉΓòÉΓòÉ

Select View source... from the Class pop-up menu to see the files you generated
from a class using Data Access Builder.

Note:   This action is available only after source code has been generated, and
the color of the class icon's table piece has become yellow, green, or purple.
If you change any of the notebook settings after source code has been
generated, the color of the class icon's table piece reverts to black and
white. Although the files are not deleted, they can no longer be viewed.

Select from the following list to get related online help:

 o View source
 o Open settings - Class
 o Generate
 o Class options...

 Select from the following list to get related information from an online book:

 o Viewing Generated Files
 o Accessing Data Using Visual Builder Programs
 o Accessing Data Using C++ Programs
 o Accessing Data Using SOM Programs


ΓòÉΓòÉΓòÉ 35. Table ΓòÉΓòÉΓòÉ

Use the Table page of the table Settings notebook to see the following
information about a table in the client area:

 o The name of the table
 o The name of the database that contains the table
 o The user ID of the creator of the table
 o Any comments that the creator included with the table.

   You can scroll up or down to see any comments that extend beyond the window
   boundaries.

 You cannot change any information on this page.

 Select from the following list to get related online help:

 o Columns - Table
 o Foreign keys


ΓòÉΓòÉΓòÉ 36. Columns - Table ΓòÉΓòÉΓòÉ

Use the Columns page of the table Settings notebook to see column and key
information for a table in the client area.

A yellow right-pointing key icon indicates a primary key. A gray left-pointing
key icon indicates a foreign key.

To see information that may be hidden:

 o Grab the vertical split bar with your mouse and drag it left or right
 o Use the scroll bars to scroll the contents vertically or horizontally.

 Precision, refers to the total number of digits in a decimal type column. The
 precision cannot be greater than 31.

 Scale, refers to the number of digits in the fractional part of the number.
 Scale cannot be negative, or greater than the precision.

 Nulls refers to whether the column can contain a null value. A null value
 means that no value was set for that column. Key values cannot be nullable.

 You cannot change any information on this page.

 Select from the following list to get related online help:

 o Table
 o Foreign keys


ΓòÉΓòÉΓòÉ 37. Foreign keys ΓòÉΓòÉΓòÉ

Use the Foreign keys page of the table Settings notebook to see the following
information about a table in the client area:

 o Constraints on the table
 o The delete rule for each constraint
 o The referenced table for each constraint
 o Referenced keys and matching columns for each constraint.

 If Data Access Builder cannot access the constraints information, it displays
 a message stating that the existence of foreign keys could not be determined.

 Click on the arrow in the Constraint list box to see and select from a list of
 all constraints that apply to this table. When you select a constraint, the
 page updates with information that applies to that constraint.

 You cannot change any information on this page.

 Select from the following list to get related online help:

 o Table
 o Columns - Table


ΓòÉΓòÉΓòÉ 38. View ΓòÉΓòÉΓòÉ

Use the View page of the view Settings notebook to see the following
information about a view in the client area:

 o The name of the view
 o The name of the database that contains the view
 o The user ID of the creator of the view
 o Any comments the creator included with the view.

   You can scroll up or down to see any comments that extend beyond the window
   boundaries.

 You cannot change any information on this page.

 Select Columns - View to get related online help.


ΓòÉΓòÉΓòÉ 39. Columns - View ΓòÉΓòÉΓòÉ

Use the Columns page of the view Settings notebook to see column information
for a view in the client area.

To see information that may be hidden:

 o Grab the vertical split bar with your mouse and drag it left or right
 o Use the scroll bars to scroll the contents vertically or horizontally.

 Precision, refers to the total number of digits in a decimal type column. The
 precision cannot be greater than 31.

 Scale, refers to the number of digits in the fractional part of the number.
 Scale cannot be negative, or greater than the precision.

 Nulls refers to whether the column can contain a null value. A null value
 means that no value was set for that column. Key values cannot be nullable.

 You cannot change any information on this page.

 Select View to get related online help.


ΓòÉΓòÉΓòÉ 40. Names ΓòÉΓòÉΓòÉ

Use the Names page of the class Settings notebook to see or change the name of
the class, and the name of the files that will be generated if you select
Generate from the Class pop-up menu.

Type new names in the Class name or the File stem entry fields. The file stem
is the file name without an extension. If your file system limits the length of
file names, Data Access Builder truncates the names that you enter accordingly.

The class name, by default, is the name of the table from which it was created.
The file stem, by default, is the class name.

The Read Only access to database check box allows you to force all instances of
the class to be read-only.  If your class is generated as read-only, and a
write access is attempted, an exception will be thrown.

This check box is selected by Data Access Builder if the tool can determine
that the table or the view is read-only by querying the datastore. Although you
can override the default selection, the generated code may not compile, or may
not function properly, if the choice is incompatible with the table definition
within the datastore.

The controls under the title DLL Build Control allow you to dictate how the
code that is generated will be built into a dynamic link library (DLL). If you
will not be using the compiled code in its own DLL, you do not need to use
these options.

The Generate MAKEFILE check box allows you to control whether a makefile is
generated when the code for the class is generated. This option is on by
default if you started Data Access Builder from outside of WorkFrame. If you
are using WorkFrame to control your build environment, you will not need to
generate a makefile.

If you choose to generate a makefile, you can supply any parameters you like to
the compiler by typing them in the Compile parameters entry field. You may wish
to do this if you will be compiling for Win32s and need to supply special
parameters. See below for more information on compiling for Win32s.

The Generate DEF file check box allows you to control whether a module
definitions file is generated when the code for the class is generated. In a
Windows environment this option is not available. It is preferred that entry
points are exported using the ilib utility.  This is done for you if you will
be generating a makefile.

The Automate link to application check box will cause the include file to
contain a precompiler directive that tells the name of the import library for
the DLL to any code that is compiled using that include file.  The directive is
#pragma library and if used, you will not have to explicitly add the import
library to your program's build parameters.  The linker will automatically know
where to look.

If any of the DLL Build Control check boxes are checked, you will be able to
select the name of the DLL by typing it in the Library name entry field. This
will be the name of the DLL that will be created when compiled.

The Generated Files list box shows all the file names that will be generated if
you select Generate from the Class pop-up menu.

Database Access Method shows the database access method that has been set in
the Class Options window.

Reset changes all options back to what they were when you last closed the
notebook.

Note to Win32s Programmers:  To compile code targeted for a Win32s environment,
you can select the Generate MAKEFILE check box, and type -qautothread -qwin32s
in the Compile parameters entry field.  These options will cause the compiler
to take Win32s particulars into account.

Select from the following list to get related online help:

 o Attributes
 o Part Methods
 o IDL Methods
 o Generate
 o Class Options


ΓòÉΓòÉΓòÉ 41. Attributes ΓòÉΓòÉΓòÉ

Use the Attributes page of the class Settings notebook to see and change
details about how the class maps to the table from which it was created. By
default, each column in the table is mapped to one attribute in the class, and
each primary key in the table becomes a data identifier in the class.

A right-pointing key icon indicates a primary key. A left-pointing key icon
indicates a foreign key.

You can:

 o Change the names of attributes.

   Select an attribute, and type a new name in the Attribute Name entry field.

 o Delete or add mappings from columns to attributes.

   Select Delete or Add when the desired attribute is highlighted.

 o Apply the data identifier label to, or remove it from, an attribute.

   Click in the Data Identifier check box when the desired attribute is
   highlighted.

   Note:   There must be at least one data identifier for each class.
   Attention: A primary key must be associated with each data identifier. If
   you attempt to move a data identifier previously associated with a primary
   key column to a nonprimary key column, a warning message appears when the
   change has been made and the attribute page has lost focus. If you do not
   undo the change, the generated code could unexpectedly delete or update
   multiple rows.

 o Select the attributes that are to appear in their asString form in the
   IString returned for the entire object when the forDisplay method is called.
   The default action is to concatenate all of the attribute values to form a
   description of the object.

   Click in the Is Displayed check box when a desired attribute is highlighted.

 o Undo all changes to this page since you last closed the notebook.

   Select Reset.

 To see information that may be hidden:

 o Grab the vertical split bar with your mouse and drag it left or right
 o Use the scroll bars to scroll the contents vertically or horizontally.

 Select from the following list to get related online help:

 o Names
 o Part Methods
 o IDL Methods


ΓòÉΓòÉΓòÉ 42. Part Methods ΓòÉΓòÉΓòÉ

Use the Part Methods page of the class Settings notebook to see which data
manipulation methods will be included in the client area if you generate a
Visual Builder part or native C++ code from the class.

This page also shows the Manager class methods, which you can use to manipulate
multiple instances of the class.

<Attribute> indicates a generic method that applies to all attributes by
substituting the attribute name for <Attribute>.

You cannot change any information on this page.

Select from the following list to get related online help:

 o Names
 o Attributes
 o IDL Methods
 o Generate
 o Class options...


ΓòÉΓòÉΓòÉ 43. IDL Methods ΓòÉΓòÉΓòÉ

Use the IDL Methods page of the class Settings notebook to see which data
manipulation methods will be included in the client area if you generate IDL
source code from the class.

This page also shows the Factory class methods, which you can use to manipulate
multiple instances of the class.

<Attribute> indicates a generic method that applies to all attributes by
substituting the attribute name for <Attribute>.

You cannot change any information on this page.

Select from the following list to get related online help:

 o Names
 o Attributes
 o Part Methods
 o Generate
 o Class options...


ΓòÉΓòÉΓòÉ 44. Data Access Builder ΓòÉΓòÉΓòÉ

The Data Access Builder product is an application development tool and a class
library that give you object-oriented access to relational databases.

Select from the following list to get related information from an online book:

 o Creating Table and Class Objects
 o Generating the Source Code
 o Accessing Data Using Visual Builder Programs
 o Accessing Data Using C++ Programs
 o Accessing Data Using SOM Programs


ΓòÉΓòÉΓòÉ 45. Data Access Builder - Startup ΓòÉΓòÉΓòÉ

The Startup window introduces Data Access Builder, and helps you to proceed.
You can:

 o Start new work on existing database tables or views.

   Select Create classes..., and then select one or more databases, tables, or
   views. (If no database product is installed, the Create classes... push
   button is disabled.)

 o Resume work on a saved Data Access Builder session.

   Select Open..., and then select a file name.

 To close this window and work directly from the menu bar, click on the Cancel
 push button.

 To turn off the Startup window (so that it does not appear each time you start
 Data Access Builder), do one of the following:

 o Click in the Display this window on startup check box to remove the check
   mark.
 o Select Startup window from the Options pull-down menu to remove the check
   mark.

 To turn this option on, select Startup window from the Options pull-down menu
 to display the check mark. The next time you start Data Access Builder, the
 Startup window is displayed.

 Select Startup window to get related online help.

 Select from the following list to get related information from an online book:

 o Accessing Database Tables/Views
 o Opening a Previously Saved Data Access Builder Session


ΓòÉΓòÉΓòÉ 46. Create classes ΓòÉΓòÉΓòÉ

Use the Create classes window to create new classes based on existing database
tables or views.

Click on the down arrow to the right of the Database Type list box to display
all of the supported database products on your system. Select a product from
the list.

The Databases list box shows all currently accessible databases. Select a
database from the list, and then click on the Connect push button to connect to
that database. (Double-clicking on the database name does the same thing.)

You can specify what tables are to be displayed in the Tables list box by using
the Table Filter; tables can be filtered by table owner, name, or type:

 o Type an owner name in the Owner entry field. Owner name is case sensitive.
 o Type a table name in the Name entry field. Table name is case sensitive.
 o Click on the down arrow to the right of the Type list box to display all the
   table types on your system. Table type identifies a category of database
   table, such as user table, system catalog table, view, and so on. Select a
   type from the list.

 You can use pattern-recognition (wildcard) characters in the Owner and the
 Name entry fields. Valid characters are:

 o ? for single-character pattern recognition
 o *, for multiple-character pattern recognition.

 The Tables list box shows all available tables and views in the selected
 database. Select one or more names from the list. To select all the names at
 once, click on the Select All push button. To remove all selections, click on
 the Deselect All push button.

 To create a new class for each table or view that you have selected, click on
 the Create classes push button.

 To turn off the Class Options window so that it does not appear each time you
 create a new class, click in the Use these defaults without prompting check
 box to display the check mark.

 To close the Create classes window without creating any classes, click on the
 Cancel push button.

 Select Create class to get related online help.

 Select from the following list to get related information from an online book:

 o Accessing Database Tables/Views


ΓòÉΓòÉΓòÉ 47. Class Options ΓòÉΓòÉΓòÉ

Use the Class Options window to set:

 o The default directory where generated files will be written.

   If you started Data Access Builder from a WorkFrame Project, this will
   default to your project subdirectory. If you started Data Access Builder
   from the command line, this will default to your current subdirectory.
   Changing this value sets a new subdirectory where all subsequently generated
   source files will be written. Changing this value does not affect any source
   files that have already been generated.

 o The default type of source code that will be generated by Data Access
   Builder. Select one of the following:

    - C++ Visual Builder part
    - IDL
    - C++.

 o The default type of database access method that will be used by Data Access
   Builder. Select one of the following:

    - Embedded SQL for DB2.
    - Call Level Interface (CLI) for DB2
    - CLI for ODBC. This is the only valid option if your table belongs to an
      ODBC database.

   All three access methods are valid for DB2 Version 2.1. If you want to
   access DB2 Version 2.1 through ODBC, select ODBC Datasources as the database
   type.

 To turn off the Class Options window so that it does not appear each time you
 create a new class, click in the Use these defaults without prompting check
 box to display the check mark.

 To set the new default values, click on the OK push button.

 To close the Class Options window without changing any settings, click on the
 Cancel push button.

 Select from the following list to get related online help:

 o Class options...
 o Create Class - Class Options
 o Generate

 Select from the following list to get related information from an online book:

 o Generating the Source Code
 o Accessing Data Using Visual Builder Programs
 o Accessing Data Using C++ Programs
 o Accessing Data Using SOM Programs


ΓòÉΓòÉΓòÉ 48. Create Class - Class Options ΓòÉΓòÉΓòÉ

Use the Create Class - Class Options window to choose:

 o The type of source code that will be generated by Data Access Builder.
   Select one of the following:

    - C++ Visual Builder part
    - IDL
    - C++.

 o The type of database access method that will be used by Data Access Builder.
   Select one of the following:

    - Embedded SQL for DB2.
    - Call Level Interface (CLI) for DB2
    - CLI for ODBC. This is the only valid option if your table belongs to an
      ODBC database.

   Options that are not valid for the associated database do not appear.

 To turn off the Class Options window so that it does not appear each time you
 create a new class, select Class options... from the Options pull-down menu,
 and click in the Use these defaults without prompting check box to set a check
 mark.

 To create the class or classes with the selected choices, click on the OK push
 button.

 To cancel the creation of classes, click on the Cancel push button.

 Select from the following list to get related online help:

 o Class options...
 o Class Options
 o Generate

 Select from the following list to get related information from an online book:

 o Generating the Source Code
 o Accessing Data Using Visual Builder Programs
 o Accessing Data Using C++ Programs
 o Accessing Data Using SOM Programs


ΓòÉΓòÉΓòÉ 49. Open ΓòÉΓòÉΓòÉ

Use the Open window to retrieve a previously saved Data Access Builder session:

  1. Click on the down arrow to the right of the drives list box to display all
     the drives on your system. To access drives that are mounted on the
     network, click on the Network push button.
  2. Select a drive.
  3. Select a directory from the directories list box.
  4. Select a file from the files list box, or type a file name in the entry
     field. Use a file name extension of .dax.
  5. Click on the OK push button.

 The name of the retrieved session appears in the title bar.

 To close the Open window without retrieving a session, click on the Cancel
 push button.

 Select Open... to get related online help.

 Select Opening a Previously Saved Data Access Builder Session to get related
 information from an online book.


ΓòÉΓòÉΓòÉ 50. Save As ΓòÉΓòÉΓòÉ

Use the Save As window to save the current Data Access Builder session under a
new file name. The current session consists of all objects currently displayed
in the client area, and the settings for those objects.

  1. Click on the down arrow to the right of the drives list box to display all
     the drives on your system. To access drives that are mounted on the
     network, click on the Network push button.
  2. Select a drive.
  3. Select a directory from the directories list box.
  4. Select a file from the files list box, or type a file name in the entry
     field. Use a file name extension of .dax.
  5. Click on the OK push button.

 If you specify an existing file name, you are asked whether you want to
 replace the existing file.

 To close the Save As window without saving the session, click on the Cancel
 push button.

 Select Save as... to get related online help.

 Select Saving a Data Access Builder Session under Another Name to get related
 information from an online book.


ΓòÉΓòÉΓòÉ 51. View source ΓòÉΓòÉΓòÉ

Use the View source window to browse any source file generated by Data Access
Builder.

The View source window lists all of the source files that the Data Access
Builder has generated for the class. The name of the subdirectory in which the
files are located is displayed above the list of file names. Select one or more
files to browse, and then click on the View push button.

To close the View source window without viewing any files, click on the Cancel
push button.

Attention: Do not edit the source code generated by Data Access Builder. You
should always generate source code directly from the information in the class
notebook. If you edit a source file directly, your changes will be lost the
next time that you use the tool to generate code for the same class.

Select from the following list to get related online help:

 o View source...
 o Generate

 Select from the following list to get related information from an online book:

 o Generating the Source Code
 o Viewing Generated Files