Hi Folks
I was asked today the following:
<immediate question>
Recently I have been given to understand that DFSORT is capable of
processing 2 flat files to mimic
1. DB2 inner join on a given key and drop non-matching records.
2. DB2 not exists - drop records in file 1 if the key matches to a
record in file 2
My very quick reading of the DFSORT manual this morning suggests that
this is not the case.
>From your experience, cold anyone please advise whether you believe that
DFSORT is capable of this functionality.
If you have example control statements, then that would also be much
appreciated.
</immediate question>
****************************************************************
IMPORTANT
The information transmitted is for the use of the intended recipient only and
may contain confidential and/or legally privileged material. Any review,
re-transmission, disclosure dissemination or other use of, or taking of any
action in reliance upon, this information by persons or entities other than the
intended recipient is prohibited and may result in severe penalties. If you
have received this e-mail in error please notify the Privacy Hotline of the
Australian Taxation Office, telephone 13 28 69 and delete all copies of this
transmission together with any attachments.
****************************************************************
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
