Database Guide


How to bind to a database

You can bind to an IBM database as follows. Make sure you have an active connection to your database. To take advantage of improved performance offered by binding to your database with the BLOCKING ALL parameter, use the method described under "From the DB2/2 command prompt."

From the System Transcript

Execute the following expression. Replace 'SAMPLE' with the name of your database.

AbtDbmSystem activeDatabaseMgr bindToDatabaseNamed: 'SAMPLE'
Note:You cannot bind to DB2/2 from the System Transcript on Windows.

From the DB2/2 command prompt

To bind to your databases from the DB2/2 command prompt, follow these steps:

  1. Catalog your server workstation node.

    The way you catalog your server workstation node varies according to the particular communication path you are using. Refer to your database user's guide for instructions.

  2. Catalog your server database.

    Refer to the database user's guide for instructions.

  3. Bind VisualAge to the database by executing the following commands from the DB2/2 command line interface. Replace dbname with the name of the database you are binding and replace bindfile with the correct bind file for your platform.
    connect to dbname
    bind bindfile datetime iso blocking all
    

The parameter datetime iso specifies the date and time format. This parameter is required. VisualAge accepts only the International Standards Organization (ISO) format. If you do not specify the ISO format when you bind your database, you will get a debug window when you attempt a database operation. To correct this error, disconnect from your database manager and rebind using the datetime iso parameter.

The blocking all parameter is recommended to improve performance.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]