sekhu_da

 Profile Answers by sekhu_da Questions by sekhu_da

• Nov 13th, 2006

 

Lookup -

looking up the data ...

suppose you have input it consits of emp_id

in lookup file it will be hving all the employes of the company..

u will seach ur input file aganist the lookup file ,so that the files your processing is ryt employes or not ..

most of the time input files comes from different loc..

in simple terms its like cross check

pradeep

• Nov 16th, 2006

 

lookup_next function is used for retrieving duplicates records of that particular record

abhi_fresh_as_dew

 Profile Answers by abhi_fresh_as_dew 

• Jun 29th, 2009

 

Use lookup_count for finding the duplicates and lookup_next for retrieving it.

If lookup_count (string file_label, [ expression [ , expression ... ] ] )>0

lookup_next ( lookup_identifier_type lookup_id, string lookup_template )

Njoi!!
Abhi - fresh as dew!