dbload utility
I am trying to load an ascii file into a table. This ascii file does
not contain delimiters, so I tried using the dbload utility.
This is the command file:
file "emiex"
(fld1 1-2, fld2 3-4, fld3 5-6, fld4 7-12, fld5 13-14, fld6 15-24, fld7 25-27,
fld8 28-29, fld9 30-39, fld10 40-45, fld11 46-46, fld12 47-47, fld13 48-49,
fld14 50-51, fld15 52-52, fld16 53-54,fld17 55-56, fld18 57-58, fld20 59-60,
fld21 61-64, fld22 65-66, fld23 67-67, fld24 68-69, fld25 70-71, fld26 72-74,
fld27 75-77, fld28 78-78, fld29 79-79, fld30 80-80, fld31 81-81, fld32 82-82,
fld33 83-83, fld34 84-84, fld35 85-85, fld36 86-86, fld37 87-87, fld38 88-88,
fld39 89-89, fld40 90-90, fld41 91-91, fld42 92-92, fld43 93-93, fld44 94-94,
fld45 95-95, fld46 96-96, fld47 97-97, fld48 98-98, fld49 99-99, fld50 100-100,
fld51 101-101, fld52 102-103, fld53 104-109, fld54 110-112, fld55 113-122,
fld56 123-132, fld57 133-134, fld58 135-144, fld59 145-146, fld60 147-148,
fld61 149-149, fld62 150-152, fld63 153-157, fld64 158-158, fld65 159-159,
fld66 160-160, fld67 161-161, fld68 162-162, fld69 163-163, fld70 164-164,
fld71 165-165, fld72 166-166, fld73 167-167, fld74 168-175);
insert into regular
values
(0,0," ",fld1,fld2,fld3,fld4,fld5,fld6,fld7,fld8,fld9,fld10,fld11,fld12,fld13,
fld14, fld15, fld16,fld17, fld18, fld20,
fld21, fld22, fld23, fld24, fld25, fld26,
fld27, fld28, fld29, fld30, fld31, fld32,
fld33, fld34, fld35, fld36, fld37, fld38,
fld39, fld40, fld41, fld42, fld43, fld44,
fld45, fld46, fld47, fld48, fld49, fld50,
fld51, fld52, fld53, fld54, fld55,
fld56, fld57, fld58, fld59, fld60,
fld61, fld62, fld63, fld64, fld65,
fld66, fld67, fld68, fld69, fld70,
fld71, fld72, fld73, fld74);
The 0's represent a serial column, a money field, and the " "
represents a char field...
I get the following error when running this
"Segmentation fault (core dumped)"
Does this mean my datafile is too extensive for this utility or what?
--
-jcm@nccom.com CALL Phone Vision! FREE and Fun!
-John C. Musselman, Systems Engineer San Diego, CA........ (619) 220-4884
-North County Communications Phoenix, AZ.......... (602) 265-6100