Reading from a file : FOCUS MAINFRAME

Hi,

I have two files. One input file which is a flat file in mainframes (sequential). Second file is a FOCUS DB file. The structures of the files are

Input tile:
Project #

FOCUS FILE:
Project #
Element code
Element value

For each project # in input file there are lots of records in the FOCUS file. The output should give me all records from FOCUS file for one record in Input file. So in this case I tried to do a match

Match file Input
Print *
By project id
run
file focus
print *
by project id
after match hold as hold1 old-and-new

this query is taking very long time to execute. I am not sure whether the query is correct or not. Is there any other easy way of executing this query.

Please Help..

Note :-The FOCUS file is very very huge.

Thanks
Sandesh

Posts: 16 | Registered: December 20, 2005

susannah

Expert

posted

Hide Post

Sandesh, if your flat file is in project id order, then
JOIN PROJECTID IN FLATFILE TO ALL PROJECTID IN BIGFILE AS J1
now if you run some sort of query on a selected project id , you should get 1 record from a and a few zillion appropriate records from file b.
If whatever your environment is wont let you join them, then TABLE FILE FLATFILE and make it into a temporary focus file for joining..
TABLE FILE FLATFILE
PRINT interesting fields BY PROJECTID
ON TABLE HOLD AS HFRED FORMAT FOCUS INDEX PROJECTID
END
..now do the join.
and..why not flip the join around?
JOIN PROJECTID IN BIGFILE TO PROJECTID IN HFRED AS J1
depending on what your query is, this is probably the best, if your flatfile contains alphabetic descriptors, stuff that doesn't mind being repeated every time it joins up with the host, such as:
JOIN CUSTOMER IN BIGTRANSACTIONFILE TO CUSTOMER IN LITTLENAMEADDRESSFILE AS JX
Any help?
-S