Here you define the VAGen Record part as an SQL row record and use the CUSTOMER table definition in the relational database catalog to define the contents of the record.
Note: | If you have already completed the steps in Chapter 11, "Defining an SQL record", skip to the last step in this section to customize the data item descriptions. |
VisualAge Generator supports accessing a variety of file types and databases.
In this case you are going to access a relational database table, so you selected SQL row as the record type.
The SQL Row Properties window is displayed.
A blinking cursor is displayed in the Name field.
The SQL Row Properties window closes.
Note: | If a message window is displayed, indicating that the system cannot locate a
database access plan, select Yes to have a plan created.
If you have not already connected to the database, you will be prompted for an ID and Password. Enter the ID and Password you used in setting up your database. |
The table definition information is retrieved from the relational database catalog and used to create data item definitions for the record.
For more information about defining records, refer to the VisualAge Generator help facility.
Now that you've defined an SQL Row record,, you're ready to add fields to the Customer Information window and define connections to the record. Data items in the CUSTOMER record will be visually connected to parts of the Window with a blue line, indicating a property-to-property connection. With this type of connection: