DSXchange

How is this any different from the post you made two days ago?

Confusing. So... you are trying to view data in a table your job just loaded? Or your job is trying to source from an Oracle table you loaded elsewhere and returns no rows? The other confusing part is your query as posted is for a Reference Lookup (with the bind variable) not a source query. And def...

Welcome. :D By itself, it means nothing. Other than to understand that 'phantom' is a term meaning 'background process', and that everything runs as a background process or series of processes. You need to Reset your aborted job from the Director and then look for an entry in the log labelled 'From ...

No, it should take significantly less time - if done properly. You need to sort in a manner that supports the aggregation being done. Otherwise, your 'sort' time is wasted as the stage cannot utilize the data in the order you've sent it. You can tell you got an issue if you sort the data, assert tha...

That's... unfortunate. Unless someone more familiar with Windows Servers can step in here with specific instructions on how to 'shutdown' and 'restart' DataStage on that platform, I'm going to stick with my original suggestion: you go brute force and just shutdown/restart the whole dang box.

The fact that it's Read Only isn't a factor. How exactly are you 'running' the job? What exactly happens when you attempt this? Are there any messages in the job's log?

Does the job run fine in your Dev project? You *did* promote out to a different project, like a Test project, yes?

Close. It's a command to remove the ^M characters. Problem is it's not quite right. To enter control characters, you first press Ctrl-V and then the character in question. To get a 'control M' you don't type an 'M' - you press ENTER after the Ctrl-V. You would do this before saving. Best to get the ...

sjordery wrote:Actually I have not specified any fixed width size.

Which is exactly the problem. Reread the error message, it's not that hard to understand, especially in light of Ray's comments.

There were 'multi-job compilers' available before the official one from Ascential. They were much more light weight and so ran much faster, I wonder if any of them are still around. MJC is like, the slowest. Didn't DSC offer such a thing at one point? Also, Kenneth Bland's Job Control Utilities incl...

Wow... I thought Ray only ever threw that out there as a teaser.

Only time I use it is to create artifacts for Support - "send me the job log". Otherwise, one typically seeks a more automated solution. Glad that worked for you.

Yes, you 'promote' the older version wherever it needs to go. Note you may need to uncheck the Read Only option if you are pushing back into Development. All 'materials' for Version Control install with the product. You'll find a pdf in your Docs directory that explains all. Only other excellent sou...

If you want to see if it's possible, take one job. Export it to a .dsx file. Make the changes to OCI. Export again. Check the difference between the two. If it looks like something you could automate, you could export the whole project and make it all one mass change. At the very least, would make f...

Nice to know about the COPY command and NEWACC. About the only time I end up using ED is when something has gone all twisty and I'm being walked through it - usually by Ms Powers.

Yes.

Mel Brooks included that line in "History of the World, Part One" during the French Revolution piece.

"Sire, the peasants are revolting!"

"They certainly are! They stink on ice. Pull!"

Sadly, Part Two never materialized.

As noted, you can change the default in the Director. Note also this means you must do this on all workstations that could be running jobs. And one last note - nothing changes the default when running jobs from the Designer - it always defaults to unlimited there. While convienent it really should b...