DSXchange

You can't. Premium memberships are one of the ways in which the hosting and bandwidth costs of DSXchange are defrayed. By taking premium membership you not only benefit in a number of ways, but can also rejoice in the knowledge that you're helping to keep DSXchange alive. It's not expensive, at less...

U is not expecting anything, as far as I am aware. U is one of our posters. The second person personal pronoun in English is spelled "you", not "u". Please strive to maintain a professional standard of written English on DSXchange. It helps those whose first language is not Engli...

I have just finished one site on AIX 6.1 (64-bit) and am embarking on another. I am not sure about Windows - certainly Windows 2008 is not yet a supported server. Check the IBM web site.

My error. The Find statement should be FindStr. I just tested it and it works OK. Obviously there will be some cases where it won't work, where the search string occurs earlier in the overall string than where it's the first element. But none of your examples had that situation. The solution provide...

Ray, Thank you for the quick response. TEST #1 ******* Arg1 = Austin+Texas;Blue+Sky;air-baloon+ride;Laptop+Pad;Grass+Green;Deep+; Arg2 = Blue Test completed. Result = The expected value is Sky, but I get a blank result. Appreciate your valuble inputs on this. Please confirm that you used 2 as the t...

The reason for "unknown" and no row count is that there is no Modify stage in the executed job.

Please re-read my previous post.

Please mark thread as Resolved using green button at top.

Consider a server job with a server routine. DataStage BASIC has a wonderful richness of string-handling functions, because everything it does it does on strings. FUNCTION ReturnSecondOfPair(aString, aSearchString) * Convert string into dynamic array. String = Convert(";", @FM, aString) * ...

That, at least, is easily remedied.

Interesting question. It can be proven that left- and right-outer joins are commutative. I suspect that you are right about range lookups, both because I can't thnk of an example where it's not and because I can imagine a formal proof. But I'm not going to consume brain cycles formulating that proof.

No, you need version 8.1 (unless on HP Itanium).

Welcome aboard.

There is no facility for exporting the Monitor statistics to a file.

These statistics are available through the DataStage API, so you can create a job or a routine, or even a C-language program, to retrieve them.

(1) Automatic reset of job is achieved by setting its run mode in the job activity to "reset if required, then run". (2) Automatic reset of job sequence can only be achieved by running that sequence from a parent sequence, which never aborts. Note, however, that it is not necessary to rese...

Did you do that in a server job or in a BASIC Transformer stage in a parallel job? Because Oconv() is not supported in the parallel Transformer stage.

That is correct. You may have the client software installed on as many machines as you like, but only N will be permitted to be connected at the same time, where N is the licence count.