DSXchange

Yes, but can you manipulate the value, for example by concatenating a string value, as luca wants to do? I don't think it can be done in the GUI. But I would be happy to learn - how would you refer, in your example, to Routine AA's return value when you are in Routine BB? Pass it as an argument? Unf...

Yes, if you must use Java, why can't it write the two values to a file? This is a much easier interface to manage - returning more than one value is always tricky! But if you can program it in Java chances are it can be programmed as easily in DataStage BASIC, as Roy points out, then you don't have ...

It stems from the fact that, when code is generated, variable names are generated. This is particularly important when "marked" items (such as return value, but also names of routines and the like) have to be incorporated. Mapping variable names also supports the ability for the Japanese version of ...

Hi , I have taken taining in Datastage. i have completed one basic project in Datastage. Presently iam looking job in india. I need help from Datastage experts,gurus. I have FAQ in Datastage. I apprecaite if you give answers to this questions to me. The following are the questions frequently asking...

Can you please verify also that your job consists of more than just these three stages? Both link partitioner and link collector stages must have inputs and outputs. Ideally you will have multiple Transformer stages between them, coded identically, but working with separate partitions of the data. T...

In server jobs, checking the box in the constraints grid makes that output link a "reject link" - Ascential's terminology, not mine. What it means, in the server job context, is an output link that handles any row that has not been processed by any previously-executed output link from a Transformer ...

Ray -- This is what causes a lot of confusions with folks here using PX when I try to explain things to them. So that is why I used the terms "Reject Link" and "Reject Constraint". A "Reject Link" in my definition is the actual broken line link out the Transform stage to capture records that the Tr...

The support group has access to Engineering, which is forbidden to us mere mortals.
That is, even they (the support analysts) can escalate problems. Kudos to them, they seem to solve most of our problems without needing to.

Once the script has been built and tested in isolation (and given that I, too, would advocate the job sequence or job control approach that Ken suggested), I think the answer you seek is to select ExecDOS as your after-job subroutine, and put the command line into the Input Value field - where you c...

I'm not sure IN works like that in SQL. But you could certainly construct a WHERE expression something like TableB.string = SUBSTRING(TableA.string FROM 1 FOR CHAR_LENGTH(TableB.string)) This example assumes that you're looking for the substring at the beginning of the string. At the...

Seeing that I have almost zero chance of getting formal training, please forgive me if I ask these types of questions. If you are an employee of a company, I don't sweat helping you out. What irritates me are posts from "consultants" for "CRM/ERP/DataWarehousing" agencies. I'll get a call from a fi...

In Bangkok (Thailand) at the moment. Where are you?
If you want to preserve the job scheduler and yet perform this edit, you need to compile before editing, then inspect the code to see what the name of the variable actually is.

There's no value in having them in hashed files for this particular task. I'm assuming you're attempting to decide on a row by row basis; that is is the string in Table B for this row a subset of the same row in Table A. Or are you trying to answer the question "is the string in Table B for this row...

Probably the easiest approach is to place another Transformer stage in your rejects link, implementing the strategy we've already discussed using the @INROWNUM system variable.
Anything else is really difficult!

The document you seek would be a very long one, even if anyone were prepared to assemble it. 4.2 and 5.2 were also reasonably major changes. Many and varied have been the new functionalities introduced at each new release. If you add the performance improvements (and bug fixes) you're really writing...