DSXchange

I am trying to create our first mainframe job using Datastage XE/390. I get all the way though and generate code, but my code won't compile. The compile JCL refers to some copylibs that we don't have: YOUR.ARDTRTL.COPYLIB Now, this does not look like the right copylib name. However, I can't figure o...

Ahh, I see. I'll see if I can get that to work. Thanks for the help! I hate wandering around endlessly...trying many, many, many different solutions (none of which work). So, it's good to be pointed in the right direction!!!

Yeah, that's the trouble I'm having. I have a sequence with 3 steps. Sequence 1 followed by Sequence 2 followed by Sequence 3. Sequence 1 consists of 2 server jobs; say server job a and b. I don't want sequence 2 to run if server job a has failed. However, when I set up the custom trigger using the ...

I searched the forum and didn't see this particular question, so I hope it's not a too often repeated inquiry! We have one sequence that runs many sequences (I'll call them subsequences), the subsequences run many jobs. I've got it set up with the trigger conditions so that within the subsequences i...

I just wanted to say thanks! The Pivot stage worked great. We didn't have that plug-in installed, so I had to have it done, but it was worth it. Thanks!

A Pivot Stage? That sounds like it would work, but I've never heard of such a thing. Could you explain where you find a pivot stage in datastage? I mean under what grouping on the palette?

Oops, I just understood what you meant when you mentioned including the new line.

The input file actually has 276 columns and we want to write out 277 (our number column), so it would be rather difficult to do in the method you describe.

To generate the 10 lines though, don't you need to have 10 output files? One with: a 1 b 1 c 1 d 1 : : and another with: a 2 b 2 c 2 d 2 : : Up to 10. That's what we have, then we merge the 10 files back together to 1 file using the link collecter. The problem is we end up creating and saving 10 fil...

Hi, I'm hoping someone can help me. We have a server job that has a performance problem and I am hoping to correct it. A transformer reads in a file and for each record in that file we write out to 10 different files, then we merge them back into a single file using the link collector. We don't real...

Thanks! We'll check that.

How do I set up FTP to overwrite a dataset? I thought changing the Append to File property to NO would do this. When I try it, I get the following messages: WARNING- 450 Data set LAYER.DETAIL.FINAL is allocated to another job and is unavailable for STOR command. Followed by a FATAL- Error while tryi...