DSXchange

Welcome aboard. The only versions that will run PX jobs on Windows is 7.5x2 and the new 8.0 release, so I hope you weren't planning on actually running them there. For help on compiling, we'd need to know what C++ compiler you have installed and the actual error message you get when you try to compi...

Doh! Just barely beat me to it, Vincent! Was going to post the same link.

First off, where are the two files that you mentioned - .odbc.in and uvodbc.config? Which is in the DSEngine directory and which is in your Project directory? Also, in your dsenv file - why are you manually setting DSHOME and ODBCINI near the end of the file? There's no need for that as they are alr...

Your server is overloaded - period. It was unable to start your job within the timeout period (90 seconds?) and thus the error. There's more to it than just CPU usage when the word 'overload' is used. In your case it sounds like a matter of the number of concurrently running jobs - or the number yo...

I suspect you meant GoSub not GoTo. But there's more problems than that.

You're not answering the question asked. I can't or I would.

From that timestamp format, how does one get the 'Day of the Week' (Mon,Tue,Wed,etc) for that particular date?

RodBarnes wrote:Is this just something it does when it uses AT?

Yes. If you don't want to go the file route, split your timestamp in two - send each portion separately.

I'd have one of those, too, if I could find one in a dang store.

And btw... what's a "Wii person"? A leprechaun?

You have to read them, that's the nature of sequential media. You can skip them in the job using a constraint along the lines of:

To me... this topic is resolved. You've gotten the answer not a 'workaround', even if it's not the one you were hoping for.

But perhaps that's just me.

we are in a big project now to replace cobol with DataStage, and we are also moving the application to AIX, which is cheaper than MVS platform. The migration to another platform is key in your decision. For someone not changing platforms (like the OP) and needing to continue to maintain / enhance t...

ray.wurlod wrote::lol: The only place you're going to find a 360 these days is in a museum!

Hey, I've got one down in my living room. Err... wait...

:D Especially if you were on a warship that had its Windows-based control systems go 'kafluey' quote unquote. And the whole thing about 'network-enabled operations' - remember why only one ship survived the initial Cylon attack on Caprica.

Welcome Aboard. :D Yes, DataStage does ship with 'branded' ODBC drivers but not one for Postgres. When people mention 'Datadirect' here, they mean for you to purchase the appropriate ODBC drivers from them. I really don't believe you have a solution 'out of the box' and that purchasing specific driv...

If you already have a job that parses out the 'detail' records, why not check it after job to see if it found any records to process? Check your 'write' link for a rowcount and, if zero, send the email. You just need a generic "get a link's rowcount" routine (will come in handy in more than just thi...