fast extracting vison files

[deef]

Hi ,

I am working at an insurance company
We have an application thats is developed in acucobol.

whe have large vision file (3 gigabyte) on a hp-ux machine that we need to dump to a sql server database.
The problem is that the cocobol application doens't make good use of timestamping so whe need to dump everything.

i have tried it with transoft odbc and acucobol but none give me the fast extraction that i really need.
I am not familiar with cobol so
i have two questions

1 does anyone one know or recommend good tools to fast extract acucobol files into sql server
2 is there a way to monitor the transactions in acucobol so that we can use for example microsoft biztalk

I hope that you guys can help me ,

 

[fdf]

You may need to handle this as an application level issue.

Add a new key field to your data records - date change. All record updates should drop the current dateinto this field.

When you extract your data, process using the date changed key, starting at the desired cut off date, thereby skipping records not updated since the cut off date.

For a full refresh, just use earliest possible date.

 

[MuadDubby]

One of the fastest ways of extracting data from a vision file and then putting it into SQL Server is by using the Bulk Copy Process (BCP). Just write a dumb little pgm that extracts all the data from your vision file and writes it to a comma (or tab) delimited text file. Once that is completed, import that file into SQL Server by using the import facilities it provides.

I guarantee you that creating a text file and then using BCP will be WAY faster than using ODBC ...

Let me know how it works.
.DaviD.