I have a simple job outputing to a SqlSever Enterprise stage
What is the best practice for code the job to pickup any rejected rows - as it is not an option to have a reject link from the SQLServer enterpise stage
This problem relates to version 8 of datastage
Thanking you all in advance
Reject load for SQLServer Enterprise Stage
Moderators: chulett, rschirm, roy
Re: Reject load for SQLServer Enterprise Stage
Hi,
Use LookUp to catch the rejected rows.U take two Target Tables.So that u
can pass matched values to one table and rejected rows to another table.
Regards,
Use LookUp to catch the rejected rows.U take two Target Tables.So that u
can pass matched values to one table and rejected rows to another table.
Regards,
gangula.narayan reddy
Re: Reject load for SQLServer Enterprise Stage
Can you please explain exactly what you meangnreddy wrote: Use LookUp to catch the rejected rows.U take two Target Tables.So that u
can pass matched values to one table and rejected rows to another table.
Original job would have been
sequential file stage --> Transform stage -> Sql server enterprise stage
Thanking you in advance
Re: Reject load for SQLServer Enterprise Stage
Can you please explain exactly what you meangnreddy wrote: Use LookUp to catch the rejected rows.U take two Target Tables.So that u
can pass matched values to one table and rejected rows to another table.
Original job would have been
sequential file stage --> Transform stage -> Sql server enterprise stage
Thanking you in advance
Re: Reject load for SQLServer Enterprise Stage
My SQL Server stage is a target and not a lookup so I do not understand why I would need to include a lookup stage. All I am interested in is capturing the RDBMS rejects and the RDBMS reject codesecclesr wrote:gnreddy wrote: Use LookUp to catch the rejected rows.U take two Target Tables.So that u
can pass matched values to one table and rejected rows to another table.
My job would have been
sequential file stage --> Transform stage -> Sql server enterprise stage
Thanking you in advance