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!
Search found 1419 matches
- Thu Feb 16, 2006 2:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: A mandatory value has not been entered
- Replies: 9
- Views: 3438
- Wed Feb 15, 2006 9:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need workaround - No error codes being returned from DB2
- Replies: 12
- Views: 7936
Getting DB2 error codes / reject links to work
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...
- Wed Jan 18, 2006 11:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Will PX work with dynamically allocating LPAR's on AIX/DB2?
- Replies: 4
- Views: 2149
Will PX work with dynamically allocating LPAR's on AIX/DB2?
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 ...
- Wed Jan 11, 2006 1:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need workaround - No error codes being returned from DB2
- Replies: 12
- Views: 7936
and another thing...
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...
- Wed Jan 11, 2006 11:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need workaround - No error codes being returned from DB2
- Replies: 12
- Views: 7936
API Not Working
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...
- Tue Jan 10, 2006 9:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need workaround - No error codes being returned from DB2
- Replies: 12
- Views: 7936
Blog
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...
- Tue Jan 10, 2006 10:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need workaround - No error codes being returned from DB2
- Replies: 12
- Views: 7936
Re: Db2 w/no error code on loads
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...
- Tue Jan 10, 2006 1:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need workaround - No error codes being returned from DB2
- Replies: 12
- Views: 7936
Need workaround - No error codes being returned from DB2
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...
- Fri Oct 07, 2005 9:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hawk/Serrano Release
- Replies: 4
- Views: 3151
Correction to Newsletter
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...