SQL*Loader question
Date: 1996/11/11
Message-ID: <567rv3$5qp_at_news.mr.net>#1/1
We are running Oracle 7.3.2.2 on an HP-UX 10.10 system. We have a file which was ftp'd from our IBM system and is in EBCDIC format that we want to load with SQL*Loader. We are using the CHARACTERSET we8ebcdic500 parameter on the LOAD DATA statement and use the POSITION parameter to identify the starting and ending positions of each column. When we execute SQL*Loader we get SQL_Loader error-510 Physical record in datafile <filename> is longer than the maximum (65535). The same file loads just fine into our Redbrick database. Apparently, UNIX doesn't recognize the end of record delimiters since the file is EBCDIC because I can't get the file with 'vi' either. We also tried the RECSIZE parameter on the INFILE statement to specify the size of each record. When we did that we got SQL*Loader error-500 Unable to open file <filename>.
Thank you in advance.
Jerry Wolfe
General Mills, Inc.
P.O. Box 1113 M/S 2EW
Minneapolis, MN 55440-1113
phone: (612) 540-7257
email: wolfe001.mail.genmills.com
Received on Mon Nov 11 1996 - 00:00:00 CET