DSXchange

User-defined SQL should be one of the Update Actions in the stage. In my version (7.5.1A) it is the last one listed, just after 'Call stored procedure'.

Unable to connect... because? If you don't have a userid and password to access ADN, you'll need to request it before the link will work for you. Start here:

http://developernet.ascential.com/home.php

Dang, "Technical Difficulties" connecting to ADN. If that's the issue, you'll just need to wait until the site comes back up...

I find it interesting that "many jobs" are stopping at the exact same point, after processing 2000 rows. I wonder if the ones that complete have less than 2000 rows to process in total? How are you running these jobs, Ravindra? As noted by Ray, it sure sounds to me that they were accidentally setup ...

Not directly from inside the job, no. If you know that each row sent down the link will update one record in the target table and you've properly tested your job so you have verified this is correct, then you can make an assumption that each row successfully sent to Oracle equates to one record bein...

Plus there's the fact that Oracle is perfectly happy updating zero rows. So a single update statement in your job could update zero, one or many rows in the target database. The only time you'll get any feedback is if your DML results in an Oracle error - and updating zero rows doesn't throw an error.

Are you actually recompiling the Sequence job before you restart it? If so - stop. That is what is resetting all of the checkpoint information. Simply restart it and it should pick up where it left off.

The answer would depend on the platform and the mail server being utilized. My answer of 'space' is how to handle it on a UNIX platform, missed the fact that you are on Windows. There it depends on what software you are using to do the actual mail send. Shouldn't be all that difficult to figure out.

I applied the patch.However,It did not make any difference. That would make sense as the patch is not meant for that particular problem at all. I'd suggest you uninstall and reinstall the client once more. Double-check in between that everything is actually being removed. Rebooting after the uninst...

Welcome aboard. This is a well known and well documented issue with Service Pack 2 for XP. There is a patch available for your client to resolve this on ADN. A quick search of the forum for 'SP2 patch' should turn up many posts in this subject, including the URL to the eServices website that hosts t...

ArndW wrote:BTW, this 32Kb inode limit is also present under AIX

Yikes... have to keep that in mind. They are contemplating moving some of the DS processing from H-PUX over to AIX here and this could definitely be an issue.

Search the forum for the use of COMO to capture that output. Ray also mentions REDIRECT I believe, as his preferred alternative.

Anyway, a search should turn them up. Both were fairly recent.

Reject links can have a constraint. There's a whole section on reject handling in the online help that goes through all that.

On the subject of the order that things happen in with a Transformer, the Full Wurlod on that particular subject is located here.

before i installed,i have delete all the directories and files in the datastage install directory and tmp. I would say this was their biggest problem, Ross. Unless it is uninstalled completely and correctly, DataStage will still know that it was installed and attempt to go into maintenance or upgra...

Ok... 1) How are you planning on fitting the NUMBER(22) into the CHAR(10) field? That answer would drive the transformation strategy. 2) DB2 (assuming you are using the plug-in, wants the date in internal format from what I recall. So it would be a simple IConv with the appropriate date mask, one th...

Was it that poorly worded?