DSXchange

I don't believe so. I've never been directly involved with mainframes but was exposed to Index Sequential files back in the 80's. Spend a goodly number of years working for a Texas Instruments VAR and their 990 'minis' (which interestingly enough ran an OS called 'DX10') supported these - aka ISAM f...

If you have to use DataStage to do this, then search the forum for the many posts on using ODBC to read the .xls file directly. You'll see mention of setting up a DSN, reading 'system tables', handling worksheets, etc - this only works on a Windows server, by the way. Well, not 'only', but for UNIX ...

Didn't you already ask this question?

A single 'row' or 'element' in this XML file is 2M characters or the entire file is? I'm curious exactly how you have set up the parsing. Are you using the XML Input stage? What methodology is it using to read the file - is the XML source column option set to XML document or URL/File path ? If you a...

I was under the impression that the most recent version is either 7.5.1A or 7.5.2 depending on your platform. Never heard of 7.6 either unless it is in the pipeline. That being said, the versions I mentioned are available now so I see no reason to start with 7.1. Regardless, there are a substantial ...

And if you have speakers, make sure they are not up too loud.

Not for Oracle.

'Mask the userid' in what sense? They will still own the PIDs generated and show up on any kind of process scan or query, so I'd be suprised if it's possible. But then I've been surprised before.

There is the same routine in the Enteprise Edition. I'm assuming you mean is there a similar routine / function specifically for PX jobs? Don't believe so, but will let others more knowledgable in that area answer that.

I think both of those issues can be resolved by installing something like the MKS Toolkit. It won't help with the performance hit you are probably going to take, however.

Interesting... I know they have one for Informatica but hadn't heard of one for Abinitio. Curious what comes of that investigation.

I'm out of suggestions at this point other than to reimage your machine, but that sounds a little drastic. You should open a case with Ascential Support at this point and see what they have to say about the issue.

Not that I've ever seen... unless something like your database cares.

Ok, then something specific to your installation. I'd suggest you completely uninstall the DataStage client. Make sure the directories it installed are completely removed and then reinstall the client.

See if that helps.

Why would you need to do this? What's wrong with using the functionality built into the Job Activity stage - "Reset if required, then Run" rather than a plain "Run"? That makes it automatic.