Re: Converting data to Informix from PICK! (fwd)

Mike Segel writes: } } } First PICK comes in on many flavors. PC, UNIX, RT ect .... } For the most part, PICK is ASCII based not EBCDIC. } } OK so lets assume that its unix based. } } 1) Find out the tape format and blocking factors. } 2) use dd to read the first section in. } 3) use od to determine the file layout } 4) based on this information develop your table structures } 5) determine the subtable layouts based on either tagging } the fields of the master record, or just create a serial } column. } 6) Write the C program to read the tape in and pull the data off. } All very good points...but, there's also another potential "gotcha"... variable-length records/fields. Rather COBOL-eze, I'd say. But, it's still not un-doable. - Corinne -- Corinne Gregory, Consulting Services Manager ASIX, Inc. 777 108th Ave. NE, Suite 1830, Bellevue WA 98004-5118 corinne.gregory@asix.com