Now we are going to create a package in the Enterprise Access Builder.

Open the EAB. Right click the mouse on the package icon and select the “Create Package” option.

This will then bring up the SmartGuide which will allow you to name the package. I called mine: SCHEDULE. Click DONE after inserting a name.

Now, click the plus sign next to the bean and it will open up the classes and you will see your new class: SCHEDULE.

Now right click on the SCHEDULE package and select “Create Data Access Parts” from the popup.

The Schema Mapping/DAXSession screen will now come forward. See the second ICON from the left with a blue ball to the right of a grid? Click on that to “Create new schema mappings.”

The smartguide wizard will come forward and tell what’s about to happen. Select “Forward” to continue. Then this screen will come foward. Mine shows just these databases for potential connection -- which is fine, since I will be using the SAMPLE Database. Click on the SAMPLE database, and leave it at “mall all columns,” then press the “Forward” button again.

This next part gets tricky. The next screen will ask you to “Get tables using filter.” You can leave the “Owner” set at “*” to get all tables in the SAMPLE database, but I chose to just get those with the “Owner” of  “THACKER.” The Owner is case sensitive so don’t sit there like I did typing your name over and over again in lower case and wondering why it wouldn’t connect.

When you select “Get tables using filter” unbeknownst to you in the background another screen will open up asking for your name and password to connect to the database. (In the beta version anyway.) You can sit there for hours and hours waiting for the hourglass to go away. Don’t. Instead ALT-TAB (in Windows95) to get to the newly opened screen asking for your password and stuff. Then fill in the stuff and continue.

Then come back to this screen and select “Select all” and “Done.”

You will now be returned to the DAXSession where your screen will look like this. You can play around with the view to make it smaller, larger, vertical, horizontal, etc.

Save your work, close the schema mapping screen and take a break. Next we’ll pick up at adding Methods with customized SQL statements.

Modified: 02/11/99