DB2 Connector stage rejects

hsahay · Post by **hsahay** » Tue Jan 03, 2012 2:47 pm

I'm updating a DB2 table using DB2 Connector stage.
My stage has 1 input link. I want to capture records in to a sequential file.
I have followed this thread and I did not find any reject tab.
I see a broken link when I drag a output link from the stage and I know that means a reject link.
I don't see column definitins defined for the output file.
I have also enabled RCP for new links.
Please let me know, what I'm missing in this context. I'm using v8.5.
Any input is appreciated. I saw this resolved topic, but unable to find answer.

qt_ky · Post by **qt_ky** » Tue Jan 03, 2012 11:41 pm

I think it's best for you to start a new topic and include a link back to this topic.

chulett · Post by **chulett** » Wed Jan 04, 2012 6:47 am

I agree... and done.

qt_ky · Post by **qt_ky** » Fri Jan 06, 2012 9:10 am

This is not very obvious at first.... Open your DB2 Connector stage and look in the top left navigator. It should show one input link, the stage icon, and one reject link. Click on the reject link in the picture. It will highlight yellow and your tabs will change to Properties, Columns, Reject, Advanced. These are your reject link properties.

Likewise, you can click the stage to get stage properties and the input link to see those properties, which are the default set you're used to seeing already.

On the Columns tab, select the RCP option. Note: It does not show the metadata.

On the Reject tab, choose to reject on one ore more options (else you won't get rejects). Choose any other settings you want also.

hsahay · Post by **hsahay** » Sun Jan 08, 2012 12:18 pm

qt_ky wrote:This is not very obvious at first.... Open your DB2 Connector stage and look in the top left navigator. It should show one input link, the stage icon, and one reject link. Click on the reject link in the picture. It will highlight yellow and your tabs will change to Properties, Columns, Reject, Advanced. These are your reject link properties.

Likewise, you can click the stage to get stage properties and the input link to see those properties, which are the default set you're used to seeing already.

On the Columns tab, select the RCP option. Note: It does not show the metadata.

On the Reject tab, choose to reject on one ore more options (else you won't get rejects). Choose any other settings you want also.

Thanks qt_ky!!
As you said its not showing the metadata, but I was able to write rejects in to sequential file and dataset.
Problem is view data is not enaled in both cases.
In case of text file, I can view it in editor, but how do I see the rejects, if I want to write in to a dataset??

Thanks again!!

pandeesh · Post by **pandeesh** » Sun Jan 08, 2012 12:27 pm

There are ways to view data from dataset.
use either dataset management option in designer or use orchadmin dump in command line.

qt_ky · Post by **qt_ky** » Sun Jan 08, 2012 8:47 pm

You're welcome!

View data is disabled because there's no metadata defined. You can use the options Pandeesh mentioned. Data Set Management is also available from the Director Tools menu. It also has a button to view the schema.

You can create a second job with a Sequential File stage or a Data Set stage as a source stage, define the metadata there, and then view data.

Or you can output the DB2 rejects to a Peek stage and view the reject records, by default, in the job log.

pandeesh · Post by **pandeesh** » Sun Jan 08, 2012 9:01 pm

qt_ky wrote:Data Set Management is also available from the Director Tools menu.

I am able to see in Designer tools menu also.

qt_ky · Post by **qt_ky** » Mon Jan 09, 2012 7:56 am

Yes Pandeesh, you mentioned that once before. Designer is not the only client you can use to access Data Set Management...