Re: Querying ISAM files

In article <DF86Gr.D2r@cix.compulink.co.uk> akent@cix.compulink.co.uk ("Andy Kent") writes: >Subject: Re: Querying ISAM files >From: akent@cix.compulink.co.uk ("Andy Kent") >Date: Wed, 20 Sep 1995 22:29:15 GMT >> >Has anyone succeeded in using SQL under SE to query ISAM files used by >> a >Cobol application? >... Snip ... >> I have done it with files using c-isam from a C application. I too had >> trouble with numberic fields. I ended up defining all numerics as >> integers or floats and copying the isam files over the top of the >> database files that I set up. I do this every time. Just a straight >> copy. Works fine! >Yes, C-ISAM maybe. But these are Microfocus Cobol ISAM. >To be honest I'm surprised that I get it to work with the CHAR columns. >Unscrambling the COMP-3s would be really nice. >akent@cix.compulink.co.uk (Andy Kent) >------------------------------------------------ >Freelance Informix Database Specialist, >Redland, Bristol, England At my site we've also done this in C-ISAM on MicroFocus files (SunAccount application). We had a problem with a conflict of file locking; if the C-ISAM program opened the file SunAccount claimed the whole file was locked and vice versa. We now maintain a copy of the information we need in OnLine and synchronize the two overnight using hash values to deterrmine where things have changes. We had to sort out the numeric fields in order to make the extracts. I don't have code to hand but I could find it and post it if this will help you. Ian