DSXchange

Fair enough. My assertion is certainly true for Server jobs, but if that's not the case on the Parallel side of the house, I stand corrected. Thanks. :wink: For what it's worth, only the first sql in a set of "union" sqls would need any column aliases as that one drives the column names in...

Unfortunately, most of what you'll get back from "oerr" is empty sections, never mind that you'd need to parse out the bits you want from the paragraphs of output if it does actually return something. What we did eons ago was find an online reference and/or work with the DBAs to get a flat...

Yup, technically.

Harkens me back to my Hollerith / punch card days where you could actually see the "over punch" needed for this.

And yes, I am a member of the Old Fart club, thank you very much.

Welcome. :D For the "list of recipients" from a text file, you'd need something (a routine perhaps) to "read" the file and return the contents of it in a properly delimited list. Load that into a job parameter and use that parameter in the "To:" portion of Notification ...

Adding more CPUs to a server doesn't magically mean a single job will use more of them, simply that more jobs could run at the same time. And if you want tips on tuning your job design, you'd need to post it first so we have some idea what it is doing.

I have posted it in this forum since datastage version used by us is Enterprise Edition. But we are using server type and created server jobs as earlier we were using Datastage server edition. We are not using parallel job type. That is why I have posted it here. Well... for the record, there's one...

"In transformer stage" the job will still be running, so what kind of status do you expect to send from there? Double-click on it in the Manager if you're unclear on the syntax needed to call it, it's all documented there.

A search here for "Fault type is 11. Layer type is BASIC run machine." should help as you're not the first to see an issue like this. Also, to help narrow down the culprit, find the file noted in your error message and post the code from around the line it mentioned. Since your job number ...

Best thing would be to go to the RT_BP746 directory in your Project and post the code from around line 650 from the "TRANS3" file noted in your error. Should help to narrow down what is happening in your 3rd transformer to blow it up.

From what we've seen here, you may need to add the user credentials to the command line, and also with 8.x add in the -domain option as well.

[raises hand]

As noted above, didn't have much luck but didn't really try all that hard.

I wondered the same thing about the role of the Field() function here until I saw this where (I assume) all three fields are being pulled from a single string field:

ds_search2008 wrote:I'm trying to extract the exact input decimal values (23.765980, 47.987650, 2101.00000...)

Yup, they need to be "escaped" to be preserved.

throbinson wrote:Basically another level of abstraction and obfuscation.

Excellent! Nothing like a layer of abstration, followed by a nice chocolate creme and then some rich obfuscation to top it all off.

Sorry, but any column aliases ("as c") you use in your sql are ignored by the stage. Not to mention unneeded in the sql as well.