CrazyBird Posted July 22, 2008 Share Posted July 22, 2008 Hello!I have the following situation:I have a positional file and a databse table and join them togehter (file is main, db table is lookup) using the inner join option.It's clear, that in this constellation there are only arriving sentences in the output where there exists data in both, the db table AND the file.But now I need to know which data records have been skipped out from the postional file because they where not able to be joined for logging purposes (because this is a data error of the input file).Is there any possibillity to do this? Thanks in adavnce for your answers,Stefan Mackovik Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now