DSXchange

Yah, Support. Sorry. The whole link-wants-me-to-log-in thing seems to be about the 'www' part of the URL. If you connect to the site using 'dsxchange.com' then it seems that links will only work for you if they don't contain the 'www.' part. If, like most people I believe, you connect to 'www.dsxcha...

kris007 wrote:You cannnot perform range lookup's from a hashed file.

Actually, you can. Once you grasp the concept, it is very cool.

Also you need to enable Restartability for the project from Datastage Administrator- It is in the Properties>> Sequence tab..enabling this would also put checkpoints in your process. Actually, no. That just controls the defaults when a new Sequence job is created, whether those options default to b...

As noted, yes - you'll need to 'Add to schedule' for every hour of the day you want it to run and hope it never takes more than an hour to run.

Unfortunately, no. It was an issue I'd seen in the past but haven't had it reoccur in quite some time. When I reported it to Ascential support way back when, they were as baffled as I was. As noted in the other linked thread (which does work, btw, if you add 'www' to it) it went away all on its own ...

Hi again. I tried sorting the staging table and it's now worse because the sort process is eating up most of the free space on the DS Server machine's boot drive C: (now less than 1GB). I was monitoring free drive C: space while runing the sorting job and I had to stop the job before the server fre...

No specific options. The 'fix' is to simply use one target stage instead of two so they are aware of each other and run in the same transaction - this will resolve your deadlock issue. As long as your constraints and update actions are fine, having both links run into a single stage should be the on...

When it works for you from the command line, does it prompt you for anything, a question you need to answer perhaps? That is the typical cause of a 'hang' like this as there's no-one there to answer it when run from a job. If so, look to see if there are any additional command line options to overri...

Some random thoughts in the middle of the night as I'm not able to sleep... * Depending on the size of your XML file, the traditional 'two fields in the Folder stage' approach may not work. I've had XML jobs abort reading files over 40 or 50 MBs from what I recall. Switching to a single field in the...

I don't see anything especially goofy with what you posted. I wouldn't worry about using a custom stylesheet, I've found very few times where it was necessary and that was only for complex transformations that normal XPath expressions couldn't handle. Your message is probably a mismatch between your...

Do you have an .xsd you could import the metadata from or just the file itself? That can usually work better...

You might also post the first few lines of your source XML so that we can see if anything about its format seems to be 'invalid'.

There are quite a large number of threads on this topic if you search for them. How long did you wait after the shutdown before you started it back up again? I suspect not long enough to allow any hung sockets to clear. This is typically what causes the RPC deamon to not start, generating a 'bind b...

Yes, even I had implemented this in a Server job. Here I am using a single transformer stage having 2 output links, one for delete & other for Insert and executed in that order. But No Luck. Actually, I meant using one Oracle stage connected to both links from your Transformer. This allows them...

This file isn't actually 'sent' by DataStage, it's an artifact of using Exchange as far as I know as that's the only time it shows up. Best to talk to whomever is managing your Exchange server and see if there is anything that can be done about it on that end. Let us know if you find out anything!

Performance is a relative thing and depends on many different factors. One man's poor is another man's just fine. It's simple enough to setup the Merge stage - give it a shot and see how it handles your two files on your system. For multiple files, you could setup a series of Merge stages, I suppose...