DSXchange

Sorry, somewhat spurious comment here... What would you rather it say? 99.9967% constant? (I left off a few 6s, btw) I'm guessing it decided to round it up for you. Or are you wondering if there is a way to not identify zero as a constant value? To treat it more like a null or unknown value, perhaps?

My requirement is to compile a job which is in aborted state and not all. As already noted, what you want to do is reset aborted jobs, not recompile them. Whatever you are using for Job Control should be able to handle that automatically. For example, Sequencer jobs can be set to 'Reset Then Run' o...

XML. That and .dsx are your two choices when exporting from a DataStage project.

I can't verify this right now, but I believe that there should be a pdf document for the stage in the 'Docs' folder underneath your DataStage client installation folder.

Well... The Sort stage by default puts the temporary files it uses in the current Project, which is not the best place for them. Jobs that generate a large volume of temp files can fill your Project partition and then you'll find yourself in all kinds of hurt. On the General / Properties tab of the ...

Before you go down the 'roll your own' path, why not use the methodologies already available to you? Specifically, there are several 'dsjob' options that allow you to get log information rather easily. Actually, why post this again? Ray is walking you through all of this in your post in the PX forum.

When i tested the routine i am getting answer as 'SQL'. Why is it. Your answer is not 'SQL', it has put up an additional SQL prompt because your statement is incomplete. Try adding a semi-colon to the end of your statement: CMD= "SELECT * FROM abcd;" It should make it run but I doubt you ...

On unix it was easy as we simply called a unix shell script that invoked dsjob with the appropriate parameters passed. We wish to replicate in Windows. Can you do the same via a windows .bat? The short answer to your question is yes - dsjob works just the same on Windows as it does on UNIX. The dif...

Are you running Windows XP with SP2 installed? If so, either uninstall SP2 or get the client patch from Ascential.

No. You can write a routine to compile jobs but there's no command line option.

There are configuration guides for all of the plugins that detail what you need to do to make them work, other than installing them. Look in your 'Docs' folder where you installed your client software for the appropriate pdfs. For example, InstConf.pdf for general information or Oraoci9.pdf for the ...

Wow... plagiarism. Probably should have just linked back to and referenced the original post this came from.

A SIGBUS error is simply a bus error. It could mean a hardware / memory problem or could indicate a problem in the software. I'd start by opening a case with Ascential Support to see if they've seen these errors before. Or possibly have a chat with your SAs.

I doubt it. Tricks like that can be used to migrate from the OCI8 to the OCI9 stage, for example, but I would think that there are enough differences between the two plugins to make a 'quick' solution impractical. You are probably going to need to define a 'cookbook' methodology for switching a job ...

Not sure what you are asking. Yes, the standard UNIX server installation requires a certain amount of 'temp' space be available where the contents of the CDROM are 'unpacked' and the installation actually runs from. No way 'round that, as far as I know. What kind of specific problem or errors are yo...