Re: Querying ISAM files

In article <DF3o4J.AJt@cix.compulink.co.uk> akent@cix.compulink.co.uk ("Andy Kent") writes: >Has anyone succeeded in using SQL under SE to query ISAM files used by a >Cobol application? > >I can get SE to see all the columns from the file as CHAR type, but the >COMP-3 numeric fields, not surprisingly, contain non-printing characters. > >I know you're not supposed to be able to do this; but I'm not too worried >about support implications as the system is being wound down anyway. I >just wondered whether anyone had come up with a kludge (a C routine, >perhaps) to unscramble the COMP-3 fields. > >To extract the data from the ISAM files and load it into a Real database >just takes too long. > 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!