SQLLoader won't load non-delimited EBCDIC file

From: Andrew McAllister <mcallister_at_grad.missouri.edu>
Date: Wed, 8 Feb 1995 19:53:31
Message-ID: <mcallister.28.0013E4ED_at_grad.missouri.edu>


I have a datafile from an IBM mainframe that I need to load into Oracle on a Unix box.

The SQL*Loader claims to be able to do character conversion on the fly from a specified character set to the instance's character set. So I have copied a 42meg datafile from our mainframe to our Unix box, using binary ftp. (ASCII ftp loses some binary data stored in the file)

I'm getting the error message: SQL*Loader-510: Physical record in data file
(filename) is longer than the maximum(65535)

I presume that this is because the Loader cannot find any end of record marks in the file's EBCDIC character set. All of the file's records are fixed length
(224bytes) and NOT delimited with a CRLF or any other delimiter.

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 Wed Feb 08 1995 - 19:53:31 CET

Original text of this message