I do not have any constraints in the input file but have a database error or warning, how do I write those records to a reject file. Based on a couple of suggestions and the help menu, I have tried the linkname.REJECTED option and created a new output link.
Thanks for all of your input and advice, I am learning a lot as this is a new thing for me.
Constraints and Rejected Rows in Server jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 29
- Joined: Mon Aug 16, 2004 8:12 am
-
- Participant
- Posts: 40
- Joined: Tue May 18, 2004 10:51 pm
Oh Boy, what a coincidence, right now I'm working on the same thing, I need to find out how to do this, I'm trying different stuff but nothing seems to work,
Try this one: just check the checkboc Reject Row in the secondlink(or rejcet link) which has to be the last one and mention no constraint in this one either, see if this works it didn't work for me though.
Good luck
James
Try this one: just check the checkboc Reject Row in the secondlink(or rejcet link) which has to be the last one and mention no constraint in this one either, see if this works it didn't work for me though.
Good luck
James
-
- Participant
- Posts: 29
- Joined: Mon Aug 16, 2004 8:12 am
Yeah, that was the first thing I tried. Thanks for the reply.Jamesvanam wrote:Oh Boy, what a coincidence, right now I'm working on the same thing, I need to find out how to do this, I'm trying different stuff but nothing seems to work,
Try this one: just check the checkboc Reject Row in the secondlink(or rejcet link) which has to be the last one and mention no constraint in this one either, see if this works it didn't work for me though.
Good luck
James
-
- Participant
- Posts: 29
- Joined: Mon Aug 16, 2004 8:12 am
My worked by resetting the target array size to correct amount.phillip.small wrote:Yeah, that was the first thing I tried. Thanks for the reply.Jamesvanam wrote:Oh Boy, what a coincidence, right now I'm working on the same thing, I need to find out how to do this, I'm trying different stuff but nothing seems to work,
Try this one: just check the checkboc Reject Row in the secondlink(or rejcet link) which has to be the last one and mention no constraint in this one either, see if this works it didn't work for me though.
Good luck
James