Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sql*loader record-size problem
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_at_amex.tel.hr
Received on Wed May 05 1999 - 12:14:01 CDT