Xref: alice comp.databases.oracle.server:48324 comp.databases.oracle.tools:24375 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.cwix.com!130.185.14.36!torn!news1.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail Message-ID: <37307D40.73CD6FB0@sympatico.ca> From: Marc Mazerolle Organization: InforMaze Inc. X-Mailer: Mozilla 4.04 [en] (WinNT; I) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools Subject: Re: Sql*loader record-size problem References: <7gps7i$qrs$1@as102.tel.hr> Content-Type: multipart/alternative; boundary="------------46229BF3D74D68484533E861" Lines: 111 Date: Wed, 05 May 1999 17:14:01 GMT X-Trace: news20.bellglobal.com 925924441 207.236.163.193 (Wed, 05 May 1999 13:14:01 EDT) NNTP-Posting-Date: Wed, 05 May 1999 13:14:01 EDT --------------46229BF3D74D68484533E861 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Alen,

This is my control file :
load data characterset us7ascii
infile "whatever.dat" "fix 26"
append
into table dulf_data
(
car_number smallint ,
location_id char(7),
event_level_rev position(10) byteint "ROUND(:EVENT_LEVEL_REV/16)",
event_level_code position(10) byteint "MOD(:EVENT_LEVEL_REV,16)",
diagnostic_code smallint,
first_set integer "to_date('1970-01-01','YYYY-MM-DD')+(:FIRST_SET/60/60/24)",
last_set integer "to_date('1970-01-01','YYYY-MM-DD')+(:LAST_SET/60/60/24)",
last_reset integer
"decode(:LAST_RESET,0,null,to_date('1970-01-01','YYYY-MM-DD')+(:LAST_RESET/60/60/24))",
counter smallint
)

Note the "fix 26" in my infile parameter.... my file is 26 bytes long with no NL. I have not found any documentation on this feature but it works perfectly.

Regards,

Marc Mazerolle
InforMaze Inc.

Alen Selimbegovic wrote:

I'm loading data from file which have fixed-length
records, but no record delimiters (newline characters).
Does anyone knows is there solution within SQL*loader?
I've searched whole documentation, but nothing helps.
There isn't parameter in which we could specify number of bytes
in a single record (we could write small program for inserting NL
chars, but it is strange for such import utility not to have this simple
feature).
We are using AIX 4.3 based Oracle 7.3.4. server, and Win95 Pc
client side.
Alen Selimbegovic
PBZ American Express
alen.selimbegovic@amex.tel.hr

--------------46229BF3D74D68484533E861--