DSXchange

Hi sourabhverma, I would consider placing all your 'like' patterns into a file or DB table, expressing them as regular expressions. You could then join these to your source and compare them to your value (@CLASS) using the regular expression parallel routine provided <a href="http://www.dsxchan...

To verify Ray's suggestion try to test if your paths are set up and whether Oracle client can see the specified instance.

I use Mozilla Thunderbird to check my favourite techie sites a couple of times a day. Its features are fairly basic, so I've been meaning to investigate the <a href="http://forumzilla.mozdev.org/">forumzilla</a> extension. I know a very popular one is <a href="http://www.newsgator.com...

Just to clarify: You're stating that a specific ID value may be associated with more than one COUNTRY? (In your example data, each ID has only a single COUNTRY associated to it)

SELECT DS_JOBS.NAME AS JOB_NAME FMT '40L', DS_JOBOBJECTS.OLETYPE AS STAGE_TYPE FMT '40L', DS_JOBOBJECTS.NAME AS FILE_NAME FMT '25L' FROM DS_JOBOBJECTS, DS_JOBS WHERE DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO AND DS_JOBOBJECTS.OLETYPE LIKE 'CSeq%'; I had it lying around in my box o' tricks!

You could add your own regular expression support using the C-source I posted <b><a href="http://www.dsxchange.com/viewtopic.php?t=107882">Here</a></b>. (Although I'm beginning to wonder why I bothered, as nobody seems to like using <b><a href="http://www.dsxchange.com/search.php"...

that is an interesting question - I can't think of an easy way to do this in PX as there are no regular expression functions. Although you could add your own regular expression support using the C-source I posted <a href="http://www.dsxchange.com/viewtopic.php?t=107882"> here</a>. J.

No Ray, Aero is part of Vista.

Vista - The one where you spend your hard earned on Aero rather than the Operating System.

Welcome aboard!

Do you have that miracle of modern technology named 'Aero' running?

j

... and was, in fact, covered yesterday:

<a href="viewtopic.php?t=118685">http://www.dsxc ... =118685</a>

J.

Try the variables below. I've put some absurd indenting in to try and make the logic clearer. I'm not guaranteeing this to be the optimum solution, just something that should work :-) svColId = If inLink.KeyChange Then 1 Else svColId + 1 svCol1 = If keyChange Then inLink.Value Else svCol1 svCol2 = I...

Here's a summary of how your stage variables would be accumulated over the course of your example input data: ('-' means NULL) INPUT COLUMNS STAGE VARIABLES ---------------------- -------------------------------------- Key Value keyChange svCol1 svCol2 svCol3 svCol4 svCol5 A Value1 1 Value1 - - - - ...

... accumulate your list of non-key columns in stage variables, initializing to null on key change.

Ray described how to use a transformer to perform the pivot you require. Did you follow the instructions, particularly the part quoted above, closely?

From within a DataStage job you could: 1. Use a Command stage in a sequence to execute your QualityStage job by supplying a shell command to call your job, an example of which is <a href="http://www.dsxchange.com/viewtopic.php?t=118639">here</a>. 2. Use the QualityStage plugin (configured ...