HELP: Problems with SQLLDR on NT

From: Ray Porter <ray_porter_at_unc.edu>
Date: Fri, 14 Apr 2000 08:13:23 -0400
Message-ID: <8d7213$4so$1_at_news2.isis.unc.edu>

[Quoted] Someone emailed me that the data, control and log file attachments didn't make it through last time so here they are again. We keep getting a partial record at end of file error (error 524) when we try and load this table. The data is generated by a mainframe program then ftp'ed to the NT server. Other tables in this database, using data generated and moved in the same manner (actually generated by the very same mainframe program), load without a hitch. This little table is important to the application and we have a rapidly approaching deadline so we need to get it loaded ASAP.

Any help will be most greatly appreciated.

--
================================================
Ray Porter
Applications Analyst Programmer
Administrative Information Services, UNC-CH
Phone: 966-5878
email: ray_porter_at_unc.edu
       dragon_at_email.unc.edu
Home Page: http://www.unc.edu/~dragon/

"Meddle not in the affairs of dragons,
for thou art crunchy and taste good with ketchup."



begin 666 career.dat
M,#$P06-C;W5N=&EN9R _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @#0HP,C!!9'9E<G1I<VEN9R]P=6)L:6,@<F5L871I;VYS(" @(" @
M(" _at_(" @(" @(" @(" -"C S,$%G<FEC=6QT=7)E(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @( T*,#0P07)C:&ET96-T=7)E(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @#0HP-3!!<G1S("AP97)F
M;W)M:6YG+"!C<F5A=&EV92D_at_(" @(" @(" @(" @(" @(" @(" -"C V,$%R
M=',_at_861M:6YI<W1R871I;VX@(" @(" @(" @(" @(" @(" @(" @(" @(" @
M( T*,#<P071H;&5T:6-S+W-P;W)T<R _at_(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @#0HP-S5!=61I;R!6:7-U86PO365D:6$_at_4V5R=FEC97,@(" @
M(" _at_(" @(" @(" @(" @(" -"C X,$%U9&ET:6YG(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @( T*,#DP0F%N:VEN9R @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0HQ,#!":6]L;V=I
M8V%L('-C:65N8V5S(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" -"C$Q
M,$)R;VME<F%G92]I;G9E<W1M96YT<R _at_(" @(" @(" @(" @(" @(" @(" @
M(" _at_( T*,3(P0G5S:6YE<W,_at_861M:6YI<W1R871I;VXO;6%N86=E;65N=" @
M(" _at_(" @(" @(" @#0HQ,S!#:&5M:6-A;"!R97-E87)C:"]D979E;&]P;65N
M=" _at_(" @(" @(" @(" @(" @(" -"C$T,$-O;6UU;FEC871I;VYS(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @( T*,34P0V]M<'5T:6YG+VEN
M9F]R;6%T:6]N(&UA;F%G96UE;G0_at_(" @(" @(" @(" @(" @#0HQ-C!#;VYS
M=6QT:6YG(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -
M"C$W,$-O;G1R86-T:6YG+V-O;G-T<G5C=&EO;B _at_(" @(" @(" @(" @(" @
M(" _at_(" @( T*,3_at_P0V]R<F5C=&EO;G,@(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @#0HQ.3!#;W5N<V5L:6YG+W1H97)A<'DO<'-Y8VAO
M;&]G>2 _at_(" @(" @(" @(" @(" @(" -"C(P,$1A=&$@<')O8V5S<VEN9R @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*,C$P1&5N=&%L(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0HR,C!%
M8V]N;VUI8W,_at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" -"C(S,$5D:71I;F<_at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @( T*,C0P161U8V%T:6]N("AA9&UI;FES=')A=&EO;BD@(" @
M(" _at_(" @(" @(" @(" @(" @#0HR-3!%9'5C871I;VX@*'1E86-H:6YG*2 @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" -"C(V,$5N9VEN965R:6YG(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*,C<P16YT97)T
M86EN;65N=" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0HR
M-S5%;G1R97!R96YE=7(_at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" -"C(X,$5N=FER;VYM96YT(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @( T*,CDP1FEN86YC92 @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @#0HS,#!&:6YA;F-I86P_at_86YA;'ES=" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" -"C,Q,$9O;V0_at_86YD(&)E
M=F5R86=E(&EN9'5S=')Y(" _at_(" @(" @(" @(" @(" @(" @( T*,S(P1F]R
M96EG;B!S97)V:6-E(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M#0HS,S!&;W)E<W1R>2 _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" -"C,T,$9U;F0@<F%I<VEN9R @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @( T*,S4P1G5N97)A;"!S97)V:6-E<R @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @#0HS-35'96]G<F%P:'D@(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"C,V,$=E;VQO9WD@
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*,S<P
M1V]V97)N;65N=" H96QE8W1E9"D_at_(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_#0HS.#!';W9E<FYM96YT+V-I=FEL('-E<G9I8V4@(" @(" @(" @(" @
M(" _at_(" @(" @(" -"C,Y,$AE86QT:"!P<F]F97-S:6]N<R H;F]T(&UE9"]D
M96YT+VYU<G,I(" _at_(" @(" @( T*-# P2&]M96UA:V5R(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @#0HT,3!);G-U<F%N8V4@(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"C0R,$EN=&5R
M:6]R(&1E<VEG;B _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*
M-#,P26YV97-T;65N=',_at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @#0HT-#!*;W5R;F%L:7-M("AB<F]A9&-A<W0I(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" -"C0U,$IO=7)N86QI<VT@*'!R:6YT*2 @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @( T*-#8P3&%W(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @#0HT-S!,87<@96YF;W)C
M96UE;G0_at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"C0X,$QE
M9V%L('-E<G9I8V5S(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M( T*-#DP3&EB<F%R>2]A<F-H:79A;"!S97)V:6-E<R _at_(" @(" @(" @(" @
M(" _at_(" @(" @#0HU,#!-86YU9F%C='5R:6YG(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" -"C4Q,$UA<FME=&EN9R @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @( T*-3(P36%T:&5M871I8W,@(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0HU,S!-961I8VEN
M92 _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"C4T
M,$UI;&ET87)Y(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_( T*-34P36EN:7-T<GDO<F5L:6=I;W5S('=O<FL@(" @(" @(" @(" @
M(" _at_(" @(" @(" @#0HU-C!-=7-E=6TO:&ES=&]R:6-A;"!P<F5S97)V871I
M;VX_at_(" @(" @(" @(" @(" @(" -"C4W,$YA='5R86P@<V-I96YC97,@(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @( T*-3_at_P3F]N+7!R;V9I="!M
M86YA9V5M96YT(" _at_(" @(" @(" @(" @(" @(" @(" @(" @#0HU.3!.=7)S
M:6YG(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -
M"C8P,$]P=&]M971R>2 _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @( T*-C$P4&5R<V]N;F5L+VAU;6%N(')E<V]U<F-E<R @(" @(" @
M(" _at_(" @(" @(" @(" @#0HV,C!0:&%R;6%C>2 @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" -"C8S,%!H>7-I8V%L('-C:65N8V5S
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*-C0P4'5B;&ES:&EN
M9R _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0HV-3!2
M96%L(&5S=&%T92 _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M(" -"C8V,%)E86P_at_97-T871E(&1E=F5L;W!M96YT(" @(" @(" @(" @(" @
M(" _at_(" @(" @( T*-C<P4F5C<F5A=&EO;B @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @#0HV.#!297-E87)C:"!A;F0_at_9&5V96QO<&UE
M;G0_at_(" @(" @(" @(" @(" @(" @(" @(" -"C8Y,%)E=&%I;"!S86QE<R]M
M97)C:&%N9&ES:6YG(" _at_(" @(" @(" @(" @(" @(" @( T*-S P4V%L97,@
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @#0HW
M,3!38VEE;G1I9FEC('-E<G9I8V5S(" _at_(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" -"C<R,%-E8W)E=&%R:6%L('-E<G9I8V5S(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @( T*-S,P4V]C:6%L('-E<G9I8V5S(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @#0HW,S53<&]R=',_at_36%R:V5T:6YG(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" -"C<T,%-T871I<W1I8W,@
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*-S4P4W1U
M9&5N=" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @
M#0HW-C!4<F%N<W!O<G1A=&EO;B _at_(" @(" @(" @(" @(" @(" @(" @(" @
M(" _at_(" @(" -"C<W,%1R879E;"!I;F1U<W1R>2 @(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @( T*-S_at_P571I;&ET:65S(" @(" @(" @(" @(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @#0HW.3!6971E<FEN87)I86X@(" @
M(" _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" -"C_at_P,%9O;'5N=&5E
J<B _at_(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @(" @( T*


`

end

begin 666 Career.ctl
M3$]!1"!$051!#0I)3D9)3$4_at_)T0Z7$]R86-L95-13%Q$871A7&-A<F5E<BYD
M870G#0I"041&24Q%("=$.EQ/<F%C;&5344Q<0F%D7&-A<F5E<BYB860G#0I$
M25-#05)$1DE,12 G1#I<3W)A8VQE4U%,7$1I<V-A<F1<8V%R965R+F1S8R<-
M"E)%4$Q!0T4_at_4%)%4T525D4_at_0DQ!3DM3#0I)3E1/(%1!0DQ%($%,340N4U50
M4%]#05)%15(_at_* T*("!355!07T-!4D5%4E]#1 E03U-)5$E/3B H,#$Z,#,I
M($-(05(L#0H_at_($-!4D5%4E]46%0)"5!/4TE424].("@P-#HT,RD_at_0TA!4BP-
M"B _at_55-%4E])1 D)0T].4U1!3E0@)T%,340G+ T*("!23U=?0U)%051?1%0)
C"5-94T1!5$4L#0H_at_(%)/5U]54$1?1%0)"5-94T1!5$4-"BD`


`

end

begin 666 Career.log
M#0I344PJ3&]A9&5R.B!296QE87-E(#_at_N,2XU+C N," M(%!R;V1U8W1I;VX@
M;VX_at_5&AU($%P<B Q,R Q-SHQ-3HR-2 R,# P#0H-"BAC*2!#;W!Y<FEG:'0@
M,3DY.2!/<F%C;&4_at_0V]R<&]R871I;VXN("!!;&P@<FEG:'1S(')E<V5R=F5D
M+_at_T*#0I344PJ3&]A9&5R+34R-#H@<&%R=&EA;"!R96-O<F0_at_9F]U;F0_at_870@
M96YD(&]F(&1A=&%F:6QE("A$.EQ/4D%#3$5344Q<4U%,3$]!1$527$-!4D5%
(4BY#5$PI#0H`


`

end

Received on Fri Apr 14 2000 - 14:13:23 CEST