DSXchange

One issue we have been having with DataStage is we need to be able to feed the DB2 Stage with a file of keys to use as the where criteria. We find it inefficient to have to pull all of the data from the table and then lookup or match these rows using the Lookup stage or merge. Is there some way to d...

Ok, I got it. And the job worked. Thanks, you saved me. People have been bothering me for this job all week. Sorry for all of the questions on this one. I don't have DataStage parallel in front of me but I remember there is an option in lookup stage where you can define if you want to match one or a...

I have this job working just as I want it now, using 2 lookups, with the first one being a range lookup, except I am having a problem matching. From the file, I have an id and from the database table, I lookup the range, but several of the ids will be within the same range, so it should match with t...

I think this might just work. Thank you so much for helping me think that one through! :) I was considering other options, but I really didn't want to start something else since I had put the time into doing it this way. Thanks, Nicole One way to accomplish this through DataStage is perform lookups ...

Hmm.....I'm just not sure how I can do that, since I need data from the lookup of the table and data from the file together. What exactly is an 'upstream transformer' stage? I tried to find posts which would be helpful, but none really described it. If I had to guess, it would be a transformer stage...

I need to elaborate on this a little. From the file I explained I have an id field and then I have a database table which has begin_id and end_id fields. I used the range lookup to find this. There is also a sequence number column from the table. In order to find the right row to lookup, I need to s...

Thank you...as I was waiting for a reply, I was playing around with the lookup stage and noticed the range option, but I wasn't sure if that was what I wanted, but now I see it is!!! Thanks so much! That's a "range lookup" and if you do an exact search on that phrase you should find all ki...

I have a file which has an id field and then I have a database table which has begin_id and end_id fields. I want to create a job which will get each ID from the file and then go to the table and find the row where the id from the file is in between the begin_id and end_id and then get a value from ...

I don't think this one will work because we still have a SQL statement in the DB2 Stage, but we want to run the first sql to get the max and min to pass as values in the where clause of the sql in the DB2 Stage. Thank you for the suggestion. Create the sql into a file in the pre-job and use external...

That is a good idea...BUT the max and min values are on a table which is on a totally different platform. Of course, the obvious option is to query for the max and min and plug them in before running the job, but we were trying to find a way to do it within the one job. Use it as a subselect sql sta...

Hi everyone. I want to be able to query for a max and min value each time a job is run, and then pass the max and min value into the DB2 stage as input parameters to the query for that stage, but of course, I can't create an input link into a DB2 stage so what would be the best way to go about this?...

Hi. If I schedule a job with input parameters, is there anyway to set those input parameters so the job can be automated. For instance, if a job is run everyday and you want the job to process rows with today's date. Would there be a way to set that?

Thanks for your help!

Nicole

Hi Mike...I had given up on this one..almost..I think I may need a different version of DataStage.. But yes, I do mean execute a COBOL program, not just reading a COBOL file. Is this possible in DataStage? Do you need the MVS version? Or some other? Thank you, Nicole Hi Nicole, What exactly does &qu...

Hi there... I want to subtract the value of 2 columns and if they are below a certain amount, then I want to add 1 to a counter. What is the best way to do this? Should I create a count output column and in the derivation put the criteria in an IF statement? I looked in the forum for counter example...

Hi. We are using the MQ Connector Stage to put a message to a queue. Once the message is picked up from the listener, the following error message is given: 'An invalid XML character (Unicode: 0x0) was found in the element content:osh' It is putting the 0x0 prior to this value and we cannot figure ou...