First, I would check the character variable you created to see if theres
really a numbers in the field. If so, then check to see what the actual
data looks like by displaying positions 1 through 3 of your import
variable and editing the file with some editor that will read raw data.
My experience tells me that you have more than numbers in your field. I
have not used the unformatted option on the import for raw data. When I
read an ascii file, I know where each record ends and begins. So I use
the quoter utility to quote my entire records, then break them up by
position according to the layout used the send the data.
I have had problems before where garbage was embeded (actual ascii
characters) in the record, They where there but you could not see the
characteds because they where control characters. We were doing a
conversion from an HP3000 MPE to a DEC 5900 Ultrix. The HP uses a CR as a
record seperator, but UNIX uses CR/LF as a record seperator. The
developer knew this, and to compensate for it he embeded a CR/LF at the
end of each record. However, the MPE OS embeded a CR at the end of each
record in addition to his CR/LF.
When I looked at the record in VI, I could display the record seperator
with the (L) option and discovered there was a CRCR/LF at the end of each
record. When I tried to read a record, I could never find where one
record ended and one began. Progress treated the file as if I were trying
to read one record.
I hope this helps
Mike Riley
KeyWest Software, Inc.
11107 Gainsborough Court #9
Fairfax, Va. 22030
(703) 591-8315
(703) 591-1830