Reading thru these, I believe it may also be helpful to note that DSProperties is the table that contains most of the detailed "meat" of various properties within a DataStage job. The PropValue column was derived to hold "pieces" of anything in a DataStage job that would be a long character string. The Documentation Tool and "Reporting Assistant" (as seen from the pull down in the DS Manager) was written before a lot of query tools had decent support for long varchars, so each "long" string is broken down into appropriately smaller pieces (and noted in the GUI when you export to the Reporting Assistant).
So... this means that Long Descriptions, SQL Strings, and perhaps most importantly, Derivations, are placed into this table, parsed into individual parts and referenced by a numeric column that identifies their order.
Ernie
-----Original Message-----
From: Ernie Ostic [mailto:
ernie.ostic@ascentialsoftware.com]
Sent: Monday, June 04, 2001 5:55 PM
To:
informix-datastage@oliver.com
Subject: RE: Documentation Tool. (?)
You may also find these notes helpful. This lists out the most interesting tables within the set. These notes were compiled by one of the DataStage field engineers.
Ernie
Structure of DSPROPERTIES
ObjectType JOB.
The owner of a job is the project. The Jobname and the ObjectName will be the same. Jobs have Propnames Full Job Description, Before Job Subroutine, After Job Subroutine, and Job Control Code.
ObjectType STAGE:
The owner of a stage is Job. The Objectname and the Stagename are the same. Passive Stages have Propnames Description and Directory. Transformation stages have Description, Before Stage Subroutine, and After Stage Subroutine Propnames associated with them.
ObjectType Link:
The Owner of a Link is the Stage associated with it. Links have a Linkinpoutprop associated with them describing if the link is an input or an output. Links have a Propname description associated with them. An output link will also have a Constraint Propname associated with it.
ObjectType Column
The Owner of a column is the Link associated with it. Columns not moving through an active stage only have a propname of description associated with them. Columns passing through a transformation have propnames of Description, Derivation, and SourceColumn (001) associated with them.
ObjectType TableDefinition
The Owner of a TableDefinition is the ProjectName. There is no jobname or stagename associated with a TableDefinition. The ObjectName of a TableDefinition is the qualified location of the meta data associated with the table. TableDefinitions have a Propname of Long Description associated with them which generally will contain the import date/time of the metadata.
Structure of DSCOLUMNS
This table contains the relationship between a column and the jobs and links it is used in. The ColumnName and JobName values are straightforward. The OutputFromStage column identifies the source stage for the column. For a Column with no Jobname or OutputFromStage value, the LinkOrTblDefnName identifies the qualified location of the meta data, allowing us to tie the column to a TableDefinition within the DSPROPERTIES table. For other Columns, the LinkOrTblDefnName contains the name of an output link the column will be placed on.
Structure of DSSTAGES
This table provides the Project, JobName, StageName and StageType of all stages used in the project.
Structure of DSLINKS
DSLINKS provides the definition of the data flow. It contains the Project, JobName, and LinkName. From this we can find the Stages connected by the link as well as the type of link defined and the associated tables, if the link is connected to a passive stage via the OutputFilesPName and InputFilesPName columns. These columns are if the link is connected to an Active Stage.
-----Original Message-----
From: Pavan Marpaka [mailto:
Pavan.Marpaka@ascentialsoftware.com]
Sent: Monday, June 04, 2001 5:26 PM
To: David Daugherty ;
informix-datastage@oliver.com
Subject: RE: Documentation Tool. (?)
Dave,
You can also try this. Double click on Doc_tool.mdb and once the application is open, press F11 to reveal the tables.
Regards,
Pavan
-----Original Message-----
From: David Daugherty
To:
informix-datastage@oliver.com
Sent: 6/4/2001 1:00 PM
Subject: RE: Documentation Tool. (?)
Thanks for your help.
dave
-----Original Message-----
From: Riccardo Tani [mailto:
rtani@datamat.it]
Sent: Monday, June 04, 2001 12:24 PM
To:
informix-datastage@oliver.com
Subject: Re: Documentation Tool. (?)
Hi David,
open the doc_tool.mdb in this way:
press the shift key while doble clicking the file
You will be able to modify the doc_tool!
Riccardo Tani
Staff Consultant
Unita Servizi alle Imprese
Datamat, Enabling Your Future
Rome, Italy
e-mail:
rtani@datamat.it