DSXchange

Also I am running Unidata 5.2 on unix and datastage 7.5 on windows

Hi All, I have just upgraded from Datastage 5.2 to 7.5 and I am having problems with connecting to unidata. I have created a fairly simple program that connects to unidata 5.2 selecting all values in a file however i keep on getting the same error: Unable to Compile and Catalog DSHELPER subroutine -...

how/where do i tell it the value that i want to replace the missing column with?

Hi All, I have a seq file stage in a job that at times has 1 less columns than i am expecting so I have changed the job to discard and warn on any incomplete columns. But what I want to do is put the discard out to an exception file so I can monitor these discards. Is there anyway of doing this? Reg...

Hi All, I need to write something that will tell me what batches and jobs are called in what sequence. Does anyone know if something like this is available? I guess what I want is a skeleton view of the batch but the sequence of what is called at runtime. Does that make sense? For example I want to ...

Hi All,

Does anyone tips on code walkthroughs for datastage jobs and batches.

Thanks
Brad

Hi All,

When opening datastage director I get the following error message:
DataStage Repository Interface
Cannot find job Batch::LoopLPMRepayments
How can I prevent this message appearing everytime Director is opened

Thanks
Brad

Hi, We are looking at redesigning our datastage batch runs and I am after some tips on making the batch easily rerunnable. Because from time to time our batch will fallover due to an implementation error or a corrupt record which we have not catered for. Does anyone have any suggestions on how we ca...

I had a similar problem to this and I found that our virus scan was conflicting with datastage... it seemed to be locking some files that datasatge needed causing it to crash at different times. Would might want to turn your virus scanner off and see it if crashes any more. It this works then you mi...

Can anyone tell me about the configurable settings in the DSParams file?

Hi,

Is there any way to compare 2 hash files without exporting them to a sequential file?
In addition is there any way to copy and paste rows out of a hash file?

Thanks
Brad

I have check the job and it did run with the following parameters: Starting Job PopDailySavingsTran. InternalDay = 13122 DataSourceName = production DataFileDirectory = W:\data\production\rdbLoadFiles\DataFiles LogFileDirectory = W:\data\production\rdbLoadFiles\LogFiles DiscardFileDirectory = W:\dat...

We are having a problem where we have a batch program that has a number of jobs in it. We have experienced 3 different occurences when the DSWaitForJob has not waited and the next job has executed at the very same time and caused major problems with our system. Is there any known problems that have ...

We are having a problem where we have a batch program that has a number of jobs in it. We have experienced 3 different occurences when the DSWaitForJob has not waited and the next job has executed at the very same time and caused major problems with our system. Is there any known problems that have ...

I am not too sure if there are any solutions for this but when I open datastage director with categories turned off it takes about 5mins to display the jobs. Is there any way to make this quicker?