DSXchange

You can, but start a different thread to do it in.

There are various other criteria. The decision should really depend on what functionality you need - the memory savings of the Join and Merge stages are countered by the need to sort upstream (which eats most of the saved memory!). Lookup stage gives you conditional lookup. It allows condition failu...

That's one of those wonderful "it depends" questions. Get the document and see which technique is most appropriate.

Load the value in the job's user status area and retrieve it from there in the other Transformer stage. But there's only one user status area. You can also use system variables @USER0 through @USER4 and @USER.RETURN.CODE to get five more. If you need more than six, you will need to pack them up into...

Please edit and put a [ c o d e ] tag at the beginning of your code and a [ / c o d e ] tag at the end of your code (minus the spaces, of course).

If the file is placed on your server by an external scheduler, such as Ctrl-M or SeeBeyond, why not configure the same scheduler to start the DataStage job that has to process the file?

A job is already attached to itself. Use DSJ.ME as the job handle in the DSGet... functions. Do NOT use DSAttachJob(), DSPrepareJob() or DSDetachJob(). Use a CONTINUE statement to bypass the remainder of the loop if the job name is the name of the current job. The following code fragment assumes DS_...

I don't have access to one at the moment. Since it's not an Enterprise stage you may have some success. When you feed this stage from a Transformer, are there any link variables accessible via the expression editor?

Server jobs will be around for the foreseeable future. This was reinforced in (unofficial) discussions with IBM technical person this week. The first question you must ask is whether there's any value in migrating, given that fact. If your server job performs well, and meets your time window, it's n...

/dev/null is a black hole. Anything sent to /dev/null has gone forever. You are very lucky your session didn't also disappear into the black hole (= hang forever) if you tried View Data on /dev/null. Because the data have gone, you would only ever expect to be able to see those that remain; that is,...

For small volume of data, a BASIC Transformer stage could serve here. Use Oconv(Iconv(TheDate, "D"), "DQ") to generate the quarter number (1, 2, 3 or 4). Then take the remainder after dividing the quarter number into the month number, added to the month number. Us...

You're just out of luck. A completely different mechanism is used in the Enterprise stages.

There is a 22 page document available from IBM support that describes setting up for remote DB2 access. That there's 22 pages ought to suggest that the process is non-trivial. You will also need to talk to your sales rep about getting an additional copy of DataStage to run on the DB2 machine - this ...

This is a warning that can safely be demoted to informational. It's telling you that the key column passed to the Lookup File Set is exactly the same as the key column returned from the Lookup File Set, so one of them has been consumed so that only one of the (identical) values is moved onto the out...

If the second Transformer stage is downstream of the first, all you need to do is to add the stage variable as an extra output column on the output link from the first Transformer stage.