DSXchange

Hi all, I am trying to use an MQSeries Plugin stage to check the reason code while writing to a queue. If the reason code is Queue Full, I want the stage to sleep for some time and then attempt the write again. Can anyone give me any pointers on how I can achieve this using the MQ stage itself, with...

Hi there,

Does anyone know of testing tools for performance and volume testing that can be used with DataStage to fine tune the response time and behavior of jobs in a typical shared server environment?

Regards,
Manav

Hi all, I am using a Merge stage to merge two files using a 'Pure Inner Join' merge method. The two files are fixed-width column format files with Unix-style line termination. When I run the job, I get the following error: Function 'construct_hash_table' failed [Input file : MergeInput2.txt] End of ...

Can anyone tell me how to set the variable after I have added it to the parameter list of the job? I do not want to override its value, I just want to set a value for the variable and then run the job specifying '$ENV' as the parameter value. I have tried setting the variable using the UNIX command ...

Adding the Environment Variable as a parameter to a job is simple enough, but I am unable to figure out exactly where I can set the values of these env variables before I run the job, so that the job runs with the value I specify. When I run the job with the special value $ENV, it is supposed to pic...

When I browse to the Doc_tool.mdb file and double-click on this, I get the same interface as the Documentation Tool Report configuration on Data Manager. Is there any place I can actually look at the behind-the-scenes Access database and reports?

In the documentation tool in version 6.0 of DataStage, I see a button called 'Custom Reports', but clicking this brings up an empty list. I could not find any mention in the help of how one can add customized reports to this list. Can anyone throw any light on how I can do this?

Hi all,

I wish to set some environment variables of my own in UNIX (shell command in my local.profile) and use them in a server job. Any idea how I could accomplish this? I heard the $ENV special parameter value can be utilized for this.

Thanks,
Manav

Does anyone know if DataStage has any features one could utilize to encrypt an output file using PGP? Our project has a requirement where we need to FTP a sequential file output from a job after encrypting it using PGP.

Thank you Kim and Wolfgang for your inputs. The particular requirement in our project is to keep a count of the number of rows in a sequential input file that failed any of the validations performed in a transformer stage. Then, I need to reject the input file if the percentage of error records in t...

Hi,

Does anyone have a clue how I can determine the number of records in a Data Link in a server job, and use that number for my processing in a transformer stage?

Regards,
Manav