DSXchange

Jolly good.

Ray - Let me know if you're ever running a "Parallel to Server" transition class!

John.

If your concern with the Unix option is that you don't want another 'asset' to have to manage outside the DataStage environment then couldn't you just supply the 'script' in the filename specification? E.g. Something like ... MyFilename_`date +%Y%m%d-%H%M%S`.txt I've been working in a purely PX envi...

Here's a list of OLETypes I took from our project, along with their corresponding descriptions. The first column is the OLEType with the description after the semicolon. Ignore the "= **" bit. On our project we use a server routine to verify consistent stage naming across all jobs. This is...

Thanks for that Ray, Would you mind elaborating on one point I'm trying to understand ... That said, you only have 418056KB free on /tmp, so maybe something else was eating /tmp space at the same time, and has since deleted its files. ... wouldn't the Sort stage be the one consuming /tmp ? My unders...

If I'm not mistaken isn't your file size greater than your free space in /tmp ?

I know it's obvious but you ARE sorting and de-duping on the same keys, aren't you?

There's a website called www.google.com which is sometimes useful with problems such as this. :-) However, here's something to get you started ... SELECT DISTINCT CHILD, PARENT FROM {table} CONNECT BY NOCYCLE PRIOR CHILD = PARENT ORDER BY CHILD; If you want to test it for an individual employee ... ...

You might find <a href="http://www.dsxchange.com/viewtopic.php?t=104921">this thread</a> on a similar topic useful. If memory serves, I think the simplest solution suggested was to use a 'pre-processor' PAL script to split the ">" token into separate tokens for digits and alphabe...

You don't necessarily need to write a procedure. A query could potentially return the data in the form you require.

What RDBMS are you using? Oracle, for example, has a "CONNECT BY" syntax that can "flatten" hierarchical relationships in the manner you require.

J.

Your best (and quickest) help would come from performing a <a href="http://www.dsxchange.com/search.php">search</a> on your error message. It would have delivered useful topics on your, like perhaps <a href="http://www.dsxchange.com/viewtopic.php?t=104192&highlight=Client+Library+...

Decimal fields can't contain spaces - so I'm assuming you're talking about a string field containing string representations of decimal values? I think your logic would be better expressed as: if trim(sv," ","A") = "" then "null" else "abc" ... as tri...

Reason Code 2058 is MQRC_Q_MGR_NAME_ERROR which means your queue manager name is invalid. Have you tried connecting from your DataStage server to the queue using MQSC?

By the way, you can access the documentation online at:
http://www-306.ibm.com/software/integra ... index.html

J.

Welcome Aboard Marco! :D Other than the supplied manuals your best approach would be to attend the 'official' IBM QualityStage training course. Alternatively, you could try posting on the "looking for talent" forum and employ the services of an independent consultant. The manuals do walk y...

Does your transformer compile if you enter the name of the parallel routine into your transformer derivation manually? If not, what error message do you receive?

John.

Thanks Ray -

I wanted confirmation that the wizard employs the orchdbutil utility. I suppose I should have phrased it along the lines of 'the wizard generates the orchdbutil command line for you'.

J.