Documentation Tool. (?)
Documentation Tool. (?)
This is a topic for an orphaned message.
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
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
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
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
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
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
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
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
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
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
Hold down the shift key while opening Doc_Tool.mdb.
-----Original Message-----
From: David Daugherty [mailto:DDaugherty@pilgrimspride.com]
Sent: Tuesday, 05 June 2001 02:13
To: DataStage Mailing List (E-mail)
Subject: FW: Documentation Tool. (?)
Importance: High
Has anyone done this before?
-----Original Message-----
From: David Daugherty
Sent: Monday, June 04, 2001 8:44 AM
To: Dssupport (E-mail)
Subject: Documentation Tool. (?)
Importance: High
How can I use Access to modify or add new reports to the Documentation Tool? Also, I cannot find any way in the documentation or help text to export reports out to Word or Excel.
W. David Daugherty
Pilgrims Pride Corporation
(903) 855-4397
License Serial #: DAA#A406416
Install Serial #: 406416
-----Original Message-----
From: David Daugherty [mailto:DDaugherty@pilgrimspride.com]
Sent: Tuesday, 05 June 2001 02:13
To: DataStage Mailing List (E-mail)
Subject: FW: Documentation Tool. (?)
Importance: High
Has anyone done this before?
-----Original Message-----
From: David Daugherty
Sent: Monday, June 04, 2001 8:44 AM
To: Dssupport (E-mail)
Subject: Documentation Tool. (?)
Importance: High
How can I use Access to modify or add new reports to the Documentation Tool? Also, I cannot find any way in the documentation or help text to export reports out to Word or Excel.
W. David Daugherty
Pilgrims Pride Corporation
(903) 855-4397
License Serial #: DAA#A406416
Install Serial #: 406416
What would be REALLY useful would be some documentation about how to get a report into the Custom Reports drop-down.
-----Original Message-----
From: Ernie Ostic [mailto:ernie.ostic@ascentialsoftware.com]
Sent: Tuesday, 05 June 2001 07:55
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
-----Original Message-----
From: Ernie Ostic [mailto:ernie.ostic@ascentialsoftware.com]
Sent: Tuesday, 05 June 2001 07:55
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
After doing a simple test report in Access, with the system open, the report auto-magically showed up in the Custom Reports interface for me. I created the report using the Wizard interface.
dave
-----Original Message-----
From: Ray Wurlod [mailto:ray.wurlod@Informix.Com]
Sent: Monday, June 04, 2001 5:10 PM
To: informix-datastage@oliver.com; ernie.ostic@ascentialsoftware.com
Subject: RE: Documentation Tool. (?)
What would be REALLY useful would be some documentation about how to get a report into the Custom Reports drop-down.
-----Original Message-----
From: Ernie Ostic [mailto:ernie.ostic@ascentialsoftware.com]
Sent: Tuesday, 05 June 2001 07:55
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
dave
-----Original Message-----
From: Ray Wurlod [mailto:ray.wurlod@Informix.Com]
Sent: Monday, June 04, 2001 5:10 PM
To: informix-datastage@oliver.com; ernie.ostic@ascentialsoftware.com
Subject: RE: Documentation Tool. (?)
What would be REALLY useful would be some documentation about how to get a report into the Custom Reports drop-down.
-----Original Message-----
From: Ernie Ostic [mailto:ernie.ostic@ascentialsoftware.com]
Sent: Tuesday, 05 June 2001 07:55
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
Ah! I always create reports in design view. This may be it. Entry number 4,109,321 in my "to investigate" list! . Thanks for that.
-----Original Message-----
From: David Daugherty [mailto:DDaugherty@pilgrimspride.com]
Sent: Tuesday, 05 June 2001 23:18
To: informix-datastage@oliver.com
Subject: RE: Documentation Tool. (?)
After doing a simple test report in Access, with the system open, the report auto-magically showed up in the Custom Reports interface for me. I created the report using the Wizard interface.
dave
-----Original Message-----
From: David Daugherty [mailto:DDaugherty@pilgrimspride.com]
Sent: Tuesday, 05 June 2001 23:18
To: informix-datastage@oliver.com
Subject: RE: Documentation Tool. (?)
After doing a simple test report in Access, with the system open, the report auto-magically showed up in the Custom Reports interface for me. I created the report using the Wizard interface.
dave