Datastage: Importing Table Definitions

As we all know, Oracle table definitions can be imported from DataStage Designer. The Designer client provides a simple and convenient interface that connects to the database, extracts the table definition using Orchestrate Schema Definitions and imports the definition into DataStage. A friendly wizard steps us through the process.
Select Import/Table Definitions/Orchestrate Schema Definiitions

Define database connection

This screen is a bit of a mystery to me. It's titled "Select Schema" and implies that you may be able to import more than
one schema at a time but, if this is possible, I have not figured out how.

The "Field Selection" screen allows us to choose which fields we want to import.

Next we define the Table Definition name and the folder it will be imported into.

The next screen allows us to change the default descriptions for the new table definition.

Finally we're ready to import and the wizard asks for final confirmation.

Eureka! - We've done it.

As I said - very simple and convenient.
But what if we need to import dozens or hundreds of tables? Even if we only have a few tables, what if we wanted to refresh the definitions
on a regular basis? This could become quite a tedious chore. Well here's one way of automating the process.