>Hi John
>
>No, there are no memo fields in the target table. I do think that I'm approaching the problem the wrong way though - I'm using the command
>
>APPEND FROM TEXTFILE.DAT TYPE SDF FIELDS MYTABLE.Account_no, MYTABLE.Acc_name, etc etc
>
>The problem is that the system trys to dump all the info into the first field "Account_no" and nothing into the next fields. I actually want the first 20 characters of the text line placed into field 1, the next 20 into field 2 etc...
Two things come to mind:
1) I never use any FIELDS clause when I do SDF file dumps, though that shouldn't matter...
2) If the lines are variable in length, there can be trouble. If a field being appended encounters a line feed (or similar), it may not copy any further fields...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.