DSXchange

I have found that you can enter "" (two double quotes) for that parameter and it will send an empty string to the job, which satisfies the compiler.

Odd that it demands all parameters have an entry, but this works for me!

Ok, here's the scoop, straight from Ascential: In a PX Server job, you can get the error codes (hence the reject link) to work if you set the transaction size to 1 and the array size to 1. Basically this means that you have to perform a commit after every write. If you are transferring more than a s...

I've just gotten a question from one of our Architects here I thought I'd run by everyone. We are running 7.5.1a PX on AIX 5.1 with DB2 8.2.2. The question is will DataStage handle a change in CPU and memory via the AIX dynamic allocation resource? In other words, if they reduce the memory or CPU's ...

One of the locals that used to work at The Gap informed me that they encountered the same problem there. He said that they found that the error codes being returned from the Enterprise stage were inconsistent at best. They ended up setting DB2 load jobs to fail on warnings and then started parsing l...

Well, you can tell I wasn't exactly hitting on all cylinders at midnight last night. I got up this morning and the first thing that hit me was "Doh - the Reject link on the DB2 API stage comes off the Transformer Stage ! not the table". Idiot me (or just very, very tired me). However, I ju...

Vincent, I think I'll be spending some time over the weekend trying it out in PX. The Project Architect probably won't get a good night of sleep until we find a solution! Thanks for the blog entry, it should be helpful when we try that route. I also forwarded your "Guide to Ignoring Data Qualit...

Arnd - I'm using a simple transform to move data from a seqential file to its equivalent in DB2. The reject box is checked. We've also tried several other different ways to get it to reject based on the SQL return codes that are mentioned as standard return codes from the interface. And yes - this w...

This is a problem with some Server jobs that are created on the EE version of DataStage (version 7.5.1.a) with DB2 8.2.2 on AIX. What is happening is that we aren't getting any reject rows from the DB2 table inserts on AIX. We've also checked all of the error codes and they are coming back zero or b...

The info you were referring to in the newsletter has been corrected (take a look at it now). We apologize for the confusion it caused. However, in general, let me state a couple of personal observations from interactions with Ascential / IBM. They are heavily promoting Enterprise Edition (PX) in all...