DSXchange

Hello Ernie, Appreciate your response. This is not at all arbitrary. And, we are fully aware of the repercussions of enabling OMD at project level. For that reason, we do not want to keep it enabled for an extended period of time. However, i would refrain from discussing more about the non-technical...

Hello Ernie, I do not have the liberty to touch the existing code on any projects that are already created & will be created to use the arguement [-opmetadata [TRUE | FALSE]] during run time. This idea is not viable for me at this time. What i am trying to achieve is to create a report with the ...

Hello Paul, Thanks for the response. What i am trying to achieve is, I want to enable the option "Generate Operational Metadata" for a short period of time of One day for example on all the projects on a Server, let the jobs run on all the projects, Then Turn Off the option. So that, the o...

Hello Everyone! I would like to enable the option " Generate Operational Metadata " which is in DataStage Administrator ver 8.1 under "General Tab" through a shell script. I would need to automate this by writing a script which will enable and disable the above mentioned option f...

Ray,

Is new category is stored in DS_AUDIT?

Hi Ray, Thanks for your prompt inputs. I appreciate it! I really liked the code you provided. I made little tweaks to the code you provided and achieved the 1st step of the intended result i.e. Listing out the Parent Categories in each Project. Here is the tweaked version of code: SELECT DISTINCT EV...

Hello, Note: The following request is on DataStage Versions 7.5. I need to generate a report to list out the parent categories under "Jobs" of each project on a Server. The report should have the following columns: Host Name Project Name Parent Category Name (Under Jobs) Created By User Cr...

Hello Everyone, I have a text file being created using the DB2 export utility in which there is a description field where few records have Line Feed's in it. This file is to be loaded into TeraData Database. Now the question is: 1. Can we read a text file into DataStage with Sequential file stage wi...

Hello,

I am getting the following error message while trying to create a project in DataStage ver: 8.1:

DSR.ADMIN: Error updating secondary indices.

Can anyone help me out?

This is a brand new installation on Unix-AIX 6.

Thanks
Vini

Mike & Ray, Thanks for the advises. Yes, I am going through some tedious process, But it takes me some time to get the copybooks for the files i have. In this mean time i am trying to make some testing on those files. So, Is there any way to find whether the data file has levels and arrays in it...

Hello, I have a data file which is extracted from a mainframe system. Now here is my question: 1. Is there any way to tell whether the data file has arrays and levels in it by looking at the data? I don't have a Cobol Copy Book/CFD. But, I have a file layout in spread sheet which is telling about th...

Hey Amey,

May i know what issues are you facing to use CFF stage in 8.0?

Thanks
Vinay

Nicole,

It is possible to read the main frame data from DataStage. Use Complex Flat file stage. For further information about Complex Flat file stage, Please go through the DataStage documentation.

Hope this helps.

Thanks
Vinay

Nicole,

It is possible to read the main frame data from DataStage. Use Complex Flat file stage. For further information about Complex Flat file stage, Please go through the DataStage documentation.

Hope this helps.

Thanks
Vinay

Hi, We have an evaluation version of IIS 8.1 on a windows 2003 machine. We installed Oracle 10g client by choosing the " custom mode " option on the windows machine where the DataStage is Installed. And, I created a System DSN on Windows 2003 machine. When i try to connect Oracle 10g data...