DSXchange

Hi Ray, Thanks for the reply. Currently I am running manually the commands exactly the way you explained, one after the other in the same order. if I have to script it, then I have to make sure the first command is successfull to pass to the next step .How do I do capture the return code of the firs...

Hi All, We are taking automated server backups of IIS 8.1 , based on IBM DS8.1 backup documents except shutting down and starting the DS services has been done manually. But , according to our corprate standards the infrastructure team has to fully automate the backup process which also includes aut...

I read some posts and did not find what can be the issue for my job. Below is what I think is causing the issue: 15 I_PCT COMP-3 PIC 9(3)V9(6). 15 I_PCT_C REDEFINES I_PCT COMP-3 PIC 9(1)V9(8). 15 I_PCT_A REDEFINES I_PCT_C PIC X(5). Till now I handled Numeric columns redefined as Char columns and Vic...

Hi, I am reading MF file using Seq File stage and the file does have comp-3 fields. I have 4 regions files that I need to process with same code. For one region job works fine but fails for other with error below: so was wondering if I can use Seq File Stage to read data in COMP-3 fields or If I am ...

I found the problem. The Oracle before set was in fact returning multiple (identical) rows. While the ODS table only contains one row for the member, it was being joined to a subquery which was producing multiple rows. Apparently one of the tables was updated in production after the data had been co...

I am currently experiencing some strange behavior with the Change Data Capture stage in one of my jobs. Below is a diagram of the job. Oracle (Before) | ______________>Dataset (Deletes) | / V / Dataset (After)--->CDC--->Transformer----------->Dataset (Edits) \ \ -------------------->Dataset (Inserts...

Nothing changes in DS_JOBS or DS_JOBOBJECTS when you compile. On import, jobs get new numbers - it may be this that leads to your "seems not updated". These two hashed files contain design time information - if your export contained only job executables, of course, they would not affect D...

Hi,

I know the parameter and I have the value that's been passed to it but I don't know the job where its been passed.

I need to find out the job where that value is been passed.

Thanks
nsm.