DSXchange

Hi All, I've been trying to create a BuildOp in 7.1r2 using a 3rd party libary. The BuildOp generates OK but at runtime I get the following error: main_program: /opt/product/Ascential/DataStage/PXEngine/user_lib/thirdparty.sl: Could not load "/opt/product/Ascential/DataStage/PXEngine/user_lib/t...

Round Robin partitioning will distribute data evenly regardless of keys. This creates evenly sized partitions and is normally what you get when you select 'Auto' partitioning. This obviously won't support joins or other stages which require matching keys from multiple streams to be present in the sa...

Duplicate post.

Hi flavour, The simplest solution is to take what I described in my previous email and use it as a pre-processor. Just pass your data into the pattern to split the '<' tokens where appropriate, then take the resulting file and pass it into your original pattern file, where it will be re-tokenised in...

Try here:

http://www-306.ibm.com/software/data/in ... w-library/

J.

Hi Flavour, Hmmm - interesting one. One approach could be: ? | < COPY [2](c) temp1 ;Leading characters COPY [2](-n) temp2 ;Trailing numerics CONCAT " " temp1 CONCAT temp2 temp1 ;Create temp1 " " temp2 RETYPE [2] ? temp1 PATTERN {IP} This is just off the top of my head so apologie...

Flavour, If you do an investigate on your example input you'll see it's classified as "<" (Leading Alphabetic). You can create a simple pattern to match your leading alphabetic token and then use the "-n" (trailing numeric characters) and "c" (leading alphabetic charact...

Thanks Ray ... I didn't pick up on the OP being so specific. I'll be sure to differentiate 'custom' and 'Custom' in future!

J.

theverma, That's a buit like saying "How fast does a car go?" It really does depend on many factors: hardware/software landscape, job design, etc. I've worked alongside IBM when clients have asked the same question and they'll tell you the only way to infer any likely performance character...

If you're looking to compile numerous jobs in our go (say after a bulk import from a CMS into a testing environment) you could use the Multiple Job Compile tool in Manager. If you're looking to reset aborted jobs (or somehow 'clean' your environment after a test/execution cycle) then you should inve...

Sanket_Saraph, On our project we've got BuildOps which call QAS (an address cleaning solution) and BankWizard (a sort/account code validation system) We've got two different flavours of BuildOp for each - A local version which calls the relevant APIs on the local machine, and a client/server version...

ssunda, I read your original post as requiring column headings in your output file. One way to do this is to use a before-job execSH to echo the column headings to your file (creating the file in the process), then set your sequential file stage to 'append' rows to the file. To avoid name mismatch y...

You could always write a script which does an infinite loop like ...
You could start this script (nohup MyScript &) when your server comes up and leave it looking for your file.

J.

Just thought I'd tag onto this old post that we also encountered this error because there appears to be a feature (bug?) in 7.0 where the '.op' file generated for a wrapped stage appears to be broken ... echo "{ wrapped, kind = parallel, usage = \"qascleankey.op \", command = \"/...

Probably - I'm anticipating that we'll meet in this forum when you correct next week's deliberate mistake.