Hi All,

I am extracting the FOCUS database file and Put it into the flat file. The database contain the 300 to 400 fields. While extracting data from all the fields it giving the SOC4 abend. If we extracting below 167 fields it executing fine. Please let me know how to extract all the fields in the FOCUS database file.

Thanks,
Rajesh

Rajesh

are these 300/400 fields in one record or is it split into several segments.

You can split it in the following way
TABLE FILE SPLIT
PRINT firts 100 fields
BY KEYFIELDS
ON TABLE HOLD AS FIRST100
END

TABLE FILE SPLIT
PRINT second 100 fields
BY KEYFIELDS
ON TABLE HOLD AS SEC100
END

etc

But why are you doing this?
What will be the next step whit these 4 hold files....

The 300-400 fields are spread across segments.

We are planning to extract all the data from FOCUS and load it to a sequal server. Since this data will not be used very often, we are planning to create one row in SQL server for one record in FOCUS.

Thanks
Rajesh
FOCUS 7.1.1 -> Main Frames -> Flat files

This message has been edited. Last edited by: Rajesh Reddy,

Have you tried just print all your fields and the ON TABLE HOLD FORMAT SQLMSS? seems like this would be simpler then you could just move it (if necessary) and import it or associate it (or whatever the SQL server terminology is) in you SQL server database.

Information Builders also has a system called ETL, it's in fact a part of I-Way I think and that is build to Extract, Transform and Load data from one database into an other.

I think that would be much more efficient, since you do not have to write the load application.