Importing CFDs in Datastage

To import a CFD: Procedure 1. Open the Import Meta Data (CFD) dialog box in either of these ways: > Choose Import > Table Definitions > COBOL File Definitions from the main menu. > Right-click the Table Definitions folder in the repository tree and select Import Table Definition > COBOL File Definitions from the shortcut menu. 2. In the COBOL file description pathname field, type or browse for the path name where...

Read more ...>>

COBOL File Definitions in Datastage

COBOL File Definitions contain data description statements in a text file that describe a file format in COBOL terms. You can import CFDs into the InfoSphere™ DataStage® repository directly from a COBOL program. A CFD file can contain multiple table definitions, and can be either a COBOL copybook or a COBOL source program. Before you import a COBOL FD, be sure it contains valid COBOL syntax. InfoSphere DataStage supports level...

Read more ...>>

The Unix Time Command : tips & tricks

If you have a program ./prog.e then in the bash/ksh shell you can type this command and the output on the screen details how long the code took to run: $ time ./prog.e real 24m10.951s user 6m2.390s sys 0m15.705s Real time - Elapsed time from beginning to end of program (or wall clock time).The real time is the total time of execution. CPU time - Divided into User time and System time. User time - time used by...

Read more ...>>

DataSet in DataStage

Inside a InfoSphere DataStage parallel job, data is moved around in data sets. These carry meta data with them, both column definitions and information about the configuration that was in effect when the data set was created. If for example, you have a stage which limits execution to a subset of available nodes, and the data set was created...

Read more ...>>