download table definations from mainframe

[Billyqing]

Is any way to connect to mainframe and download the table definitions using DataStage?

I am current using DS server edition 6.0.

There are lots of files from mainframe needed to download to Unix server.

Instead of typing the all file definitions, I need to find a better way to download the files and file definitions directly to Unix server.


Appreciate for any suggestions and feed back.

Thanks

[ray.wurlod]

Have "them" dump the table definitions as COBOL file definition (FD) files or, if from DB2, as DCLGen files.

In DataStage Manager, use

Code: Select all

Import > Table Definitions > COBOL File Definitions 

or

Code: Select all

Import > Table Definitions > DCL File Definitions

For importing COBOL FDs you must correctly specify the column number in which the Level 01 items occur.