I need to select data from tables in my database into a cursor using an SQL-SELECT statement. I save the resulting cursor to disk for transport and import into another installation. When the SQL cursor is written to disk as a separate file, I lose all the long field names. So when I import them on the other end, I have to reconstruct the fieldnames.

For example, MYTABLE.LongFieldName001, MYTABLE.LongFieldName002, and MYTABLE.LongFieldName003 becomes C_IMPORT.LongField1, C_IMPORT.LongField2, C_IMPORT.LongField3, etc.

Can anyone suggest a good method or technique for bringing records with shortened fieldnames from my C_IMPORT table into the destination table, one that still has its long fieldnames?