1) SQL Statement.
Select * From LIB/MEMBER A
Where RRN(A) >
(Select Min(RRN(B)) From LIB/MEMBER B
Where A.LastName = B.LastName)
-------------------------------------------------------------------------------------------------
2) Series of Operation
We can use the simple CPYF (Copy File) command.
- Create the same file under a different name and define the whole field as key. Also define the key as UNIQUE.
- CPYF the original file to the new file with ERRLVL(*Nomax).This will copy only the FIRST occurence of duplicate records.
- After the CPYF finished, you could copy the new file's contents back to the original file with MBROPT(*Replace).
- After that, the original file WILL NOT contain any duplicate records.
Please Convey your Special Thanks to
Mr Shyam Sunder Reddy, (shyamgssr@gmail.com)
27 comments:
hi
best place to buy xanax online xanax sleeping pill side effects - xanax overdose withdrawal symptoms
tramadol 50mg tramadol dosage 25mg - buy tramadol online paypal
buy tramadol online tramadol and addiction - where to buy tramadol in the usa
buy tramadol online tramadol for dogs and people the same - 4 50 mg tramadol
where to buy xanax online no prescription 2mg xanax 2 beers - xanax 2 mg with v
generic xanax xanax fluoxetine drug interactions - what does 1mg xanax do
buy tramadol online tramadol hcl pills - buy tramadol online cod
alprazolam online xanax and alcohol dangers - alprazolam0 5mg germed ms
buy tramadol online buy tramadol online with visa - tramadol sr 100 mg side effects
buy tramadol online tramadol online no prescription overnight cod - how can i buy tramadol online
buy cialis online cialis online fast shipping - buy cialis 20mg
cialis online buy cialis online without rx - generic cialis yahoo answers
http://landvoicelearning.com/#57594 tramadol 100mg - buy tramadol online overnight usa
http://buytramadolonlinecool.com/#56411 buy tramadol online without prescriptions usa - tramadol withdrawal flu symptoms
http://buytramadolonlinecool.com/#30807 buy tramadol england - tramadol for dogs can humans take it
buy tramadol cod online tramadol hydrochloride xr 100mg - tramadol 100mg tablets
http://landvoicelearning.com/#63987 can buy tramadol online legally - where to buy tramadol in usa
learn how to buy tramdadol buy tramadol 100 - can dog overdose tramadol
buy tramadol tramadol hcl side effects in dogs - 6 50 mg tramadol
buy tramadol ultram vs tramadol - tramadol withdrawal vertigo
tramadol 100 mg order tramadol online no rx - tramadol effects
buy generic tramadol no prescription what is tramadol high like - buy tramadol powder
buy tramadol tramadol liquid - tramadol hcl 50 mg tab amn
ativan price 0.5 mg ativan and alcohol - xanax vs ativan social anxiety
http://staam.org/#90873 . tramadol 100mg nebenwirkungen - tramadol dosage levels
http://staam.org/#56821 tramadol 100mg/1ml - where to buy tramadol online forum
Post a Comment