Re: SQLLoader won't load non-delimited EBCDIC file

From: Steve Helle <shelle_at_dbintellect.com>
Date: 16 Feb 1995 22:25:41 GMT
Message-ID: <3i0jd5$90c_at_potogold.rmii.com>


Andy,

Try the following after your INFILE clause

INFILE '.....' "FIX nnn"

where nnn is the fixed length of your records. This has always worked for me.

Steve

> ...
> Is there a way to tell the loader that each physical record is exactly x
> bytes long?
>
> Andy
> Andrew McAllister -- mcallister_at_grad.missouri.edu
> Office of Research, University of Missouri-Columbia
> The views above are my own, and NOT those of my employer.
Received on Thu Feb 16 1995 - 23:25:41 CET

Original text of this message