Data Type Conversion for a Package

The DBMS Package procedure or mapper enables you to convert a package of database tables from one DBMS type to another DBMS type, as well as providing the ability to change the ownership of tables.

Access:    Project Browser Package Context Menu | Code Engineering | Reset DBMS Options > Manage DBMS Options

How To:

To map the DBMS types of a package to another DBMS type, follow the steps below:

Step

Action

See Also

1

In the Current DBMS field, click on the drop-down arrow and select the current DBMS

 

2

In the New DBMS field click on the drop-down arrow and select the target DBMS

 

3

Select the Convert DBMS Type checkbox

 

4

If there are child packages that also require changing, select the Process Child Packages checkbox

 

5

Click on the OK button

All tables in the selected packages are mapped to the new DBMS

 

 

To change the owner of the table or all of the tables in a package, follow the steps below:

Step

Action

See Also

1

In the New Owner field, type the name of the new table owner

 

2

In the Current Owner field, click on the drop-down arrow and select either:

  • The current owner to change, or
  • <All> to change the ownership of all tables in the package to the name you typed in the New Owner field

 

3

Select the Change Table Owner checkbox.

 

4

If there are child packages that also require changing, select the Process Child Packages checkbox

 

5

Click on the OK button

The ownership changes for all Tables in the selected packages that have the specified current owner

 

Learn More: