DSXchange

I would imagine that 20 simultaneous jobs would kill a lowly P3/500 processor, that's positively ancient. You sure that's what you have on your server? Regardless, you need to figure out your threshold of pain - how many jobs it will support running at any given time. Then craft your job control to...

It's not about the 'levels of Seqeunces' - it's about the number of simultaneously running jobs. How many are we talking about here at any one time?

I've seen plenty of inefficient methods but I'm looking for the most efficient way out there with the tools at hand. I've used match or alpha when I need to perform a simple alphabetic character check - but how about a range check? Something like when the field must be from 'A' to 'M' inclusive? Loo...

I am trying to have a Command Stage by itself without any links so that I can activate this DOS command, which I want to be a job by itself. If I am correct this is not possible, are there ways that I can have links to or from the Command Stage to stages that do nothing? Just for completeness, this...

What kind of help are you looking for? If you are asking if I have scripts to hand over, sorry but the answer is 'no', that having been over 4 years and a handful of clients ago. Interestingly enough, the primary architect of those scripts was my DBA, quite the Script Wizard. He required very little...

Not familiar with how this all works for DB2, but it looks like this is the core of your problem. Not anything to do with a 'missing' password:

>DB2 Driver Embedded SQL message: SQL1024N A database connection does not exist. SQLSTATE=08003

Post your perl script.

Sorry, not sure where else to put this such that it wouldn't almost immediately disappear in the deluge. And since I'm still getting pinged on this, I'm going to copy the relevant information from this post to here so it stands out a little more... Ok... as mentioned earlier, I'm not really excited...

... depending on your exact 7.x version of DataStage. Initially it was only available for Oracle, with others like SQL Server added in a more recent release.

Just to add some extra information: With Version 7.x there are additional packs you have to "buy", one for Java and one for Web Services. My understanding is that both are 2-way, meaning you can call a DataStage job "as a Web Service", or a DataStage job can call a Web Service (same description for...

Thanks Hadi, always appreciated when someone posts solutions like that. :D

Unless the XML stages are different in PX, there's no way to supply anything like a filename or URL directly in the Input tab. You need to pass it in just like you've been doing in a specific field. However, the Folder stage in Server jobs doesn't provide any magical functionality other than reading...

I was assuming they had added additional 'web service' related functions, but don't recall seeing anything like that documented anywhere. It sure looks like we've found some, cherry picking out of your pasted code: getWSStatusReport setWSSOAPAction setWSEncodingStyle setWSRequestNSTable setWSRespons...

You don't "have to" multiply by 100, although you certainly can. I know what I posted for the FMT command works as I tested it with your input and got your desired output. It's not like we've never helped people do this before. Of course you need to define the output as some sort of character field ...

Oh, trust me - I know what they want it to look like... and I said it was from memory. Simple enough to build a little test harness to check. Turns out we need to combine our answers: FMT(DSLink3.CURNT_BAL_AMT,"17'0'R02") From the help: n[m] n is a number, 0 through 9, that specifi...