Create DB2 Application

Use Create DB2 Application to adapt the Access front-end application to operate using the data you migrated to DB2.

Adapted database file location: Type the location where you wish to save the Access database file that has been adapted to operate using DB2 data, or use Browse to display a standard file open dialog box.
Save Password Locally: You can choose to save the DB2 login information on the local PC so that Access will not prompt for it when the application is subsequently started.
Schema: Select the schema from the combo box that contains the tables that were migrated from the current Access database to DB2. DB2 ODBC data sources are created for Access tables that have corresponding DB2 tables in the selected schema. Access tables with no corresponding DB2 table are copied to the “adapted” database including any data.
 
Important  Notes:
The adapted database cannot be used with Scriptoria. The original database should always be used to make design modifications to the migrated DB2 database. To ensure proper application operation, repeat the Create DB2 Application process after completing any design modifications.

 

Scriptorianks to DB2 tables and, to ensure proper binding, creates Access queries for any tables containing columns that were renamed. All renamed columns are assigned aliases that refer to their original Access name. The new Access query receives the name of the original Access table, so that all application field references are properly resolved.