Re: Automatic Commits?
Close. You should be able to create a pipe and output your data from A
to the pipe, and tell dbload to read from that pipe. That should work if
your databases are on the same machine, otherwist your pretty much stuck
with either (a) unload/ftp/dbload, or (b) writing that esql/c program.
David
---------------------- Forwarded by David Coburn/ISG/WVUS/WorldVision on
12/13/96 09:35 AM ---------------------------
(Embedded
image moved Con Woodall <cwoodall @ vth4.vth.colostate.edu> at
to file: WVUS-SMTP
PIC001.PCX) 12/13/96 08:50 AM
To: elderbox @ teleport.com at WVUS-SMTP@CCMAIL
cc: informix-list @ rmy.emory.edu at WVUS-SMTP@CCMAIL (bcc: David
Coburn/ISG/WVUS/WorldVision)
Subject: Re: Automatic Commits?
Check out dbload in Informix Guide to SQL:Reference.
--
Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; Ft. Collins CO 80523,
USofA; 970-491-1244 FAX 970-491-4100 cwoodall@vth1.vth.colostate.edu
"Ask me about my vow of silence!"
--
On Thu, 12 Dec 1996 elderbox@teleport.com wrote:
}
} Another database engine which we had a while ago and which I don't care
} name here allowed us to specify that during an sql insertion I
} want the engine to automatically do a commit after say 100 rows have been
} inserted. We are now very happily using Online Version 7.1, but cannot
} find a way to do this. This is a problem for us since we have a need to
} periodically transfer as many as 200k rows from one database to another
} and must have logging turned on. We run out of log space and locks.
}
} We didn't want to have to write an esql/c program to do this chore. We
do } not have 4GL at this time. Does anyone know of a way to accomplish
this?
}
} elderbox@teleport.COM Public Access User --- Not affiliated with Teleport
} Public Access UNIX and Internet at (503) 220-1016 (2400-28800, N81)
}
}
The following is an attached File item from cc:Mail. It contains
information that had to be encoded to ensure successful transmission
through various mail systems. To decode the file use the UUDECODE
program.
--------------------------------- Cut Here ---------------------------------
begin 644 PIC001.PCX 12/13/96 09:40 AM
M"@4!"`````!H`"P`````````````````````````````````````````````
M```````````````````````````!:0`!````````````````````````````
M``````````````````````````````````````````````````#U$]L3S1/'
M$\\,3PA/U$]L3S1/'$\\,3PA/U$]L3S1/'$\\,3PA/U$]L3S1/'$\\,3PA/U$]L3
MS1/'$\\,3PA/U$]L3S1/'$\\,3PA/U$]L3S1/'$\\,3PA/U$]L3S1/'$\\,3PA/U
M$]L3S1/'$\\,3PA/P$PS(!@S8$\\P3QA/#$\\(3[A/.!M<3S!/&$\\,3$^P3P@;"
M!P;"$@;"$@;"$L4&UA/+$\\83PQ,3ZA,,P@8'P@+"`P(2P@?$$L,"PP;5$\\L3
MQ1/#$Q/I$\\,&`P<"!P,"PA+#!\\(2P@(2P@+#!M43RA/%$\\,3$^@3P@('`\\("
M$PX##@+#$\\42PP+"$,(&U!/*$\\43PQ,3YQ,"`P<#`@X3#@(3P@(2#\\(2#\\(2
M!1("$<("PP;4$\\H3Q1/"$Q/F$P8"!P,"#@(.P@+#$Q(3$A/"$@\\&Q@+#!M,,
M#`?)$\\03PA,3YA,&PP(3!@,"#A+%$P\\2$\\(2!@(#PA(#$L,&!],#QPP'Q1/#
M$Q/E$P8'`A$2`@\\"PA,/PA,/Q!,/Q1(0P@(#`@,"!M,#QP/$#`?#$\\(3X1,'
MPPS"!@+"$A,"#Q+($\\,2#\\,2PP(0`P(#!@?2#,D#P@/"#`?"$Q/;$P?&#,(#
M#`('$1(3$A,2PQ,/PQ,/PQ/#$@(#`@,"PP,"!@S1$P?'#,8##,(3$]83!\\4,
MR`,&!\\("!A+#`L83$A,2$Q(/PA('`@<"`P40`@81!@?2$\\43!\\0,P@,,PA,3
MTA,'Q`S+`\\(,!L(2#Q$2$Q(3`PX#Q!,2$Q(3PQ("!P/"`L,##,(&!](3R1,'
MPPS"$Q//$P?##,D#Q0P'PA,&!Q(3`A$"$P,.`@[#$Q(3#Q,/PQ(#`@,"!P,"
M#`81!@?2$\\D3PA/"#,(3$\\P3!\\,,QP/$#,('QQ,&Q!+#`@X##@(&P@_($@(#
MP@(#`@P"$,(&!](3R1,'#`<,PA,3RA,'P@S&`\\,,P@?,$P8'PA+"$`(.`@X"
M#A##`A(/QA(%`@7#`@4"$08'TA/'$P?"#`</#,(3$\\@3!\\(,Q0/##`?0$P;#
M$A#$`A`.$`X0P@+&$@<2!A(&!<,"!<(&!]`3!\\4,$P?"#`\\'#PP'PA,3QA,'
MP@S$`\\,,!],3!@?"$A`#$,("#A`.$,("$0(#QQ(&!P;"`@4"$08'RQ,'Q`P'
MPA,'$PS"$P</!P\\,!\\,3$\\43!PS$`\\(,!]83!L02$`,"`\\4"$0(#`@/#$@<2
M!@?"!@40`A#"!@?&$P?$#`?&$\\(-$PS"$P\\'P@P'PQ/"$\\03!PS#`\\(,!]@3
M!@?$$A`"$,8"$0(#`L02!A+#!L("$`+"!@?"$P?##`?*$P?"#1,'PA/"#`?$
M$\\(3$\\,3!PS"`\\(,!]H3#!('PQ+##!$#Q0(#`@/#$@82!@?"!@(0`A`&#`?"
M$PS#$\\,'R1,'PA/"!Q,'Q1/#$Q/#$PS"`PP'W1,&QQ("$0/#`@,"`\\,2!A(&
M!P8,!A`"$`(&#,,3#!/"!\\83PP?'$P?&$\\,3PA/#$PP##`?>$P8'QQ("$0/#
M`@,"PA(&$@8'!@P&$`(0`L(&!\\,3#,83PP?*$PS&$\\,3PA/#$\\(,!]\\3#!+"
M!\\42`@,1Q`(2!\\(2!@<&#`80!A`&$`8,!\\,,!\\D3PP?'$PS&$\\,3PA/#$PP/
MP@S?$P82!\\(2!\\(2`A$"`P(#$@<2!P8'!@P&$`80Q@S##\\('Q1/#!\\D3!PS&
M$\\,3PA/#$PS##\\0,W!/"!A(&PQ(&`A$"`P('!@<&R`S)#Q,'S1,'PPP'QQ/#
M$\\(3PQ,'#,8/QPP'U!,&$@82!A++#,X/PPP3#,<3P@?$#`?)$\\03PA,3Q!,'
MP@S+#]L,TP_&#`?#$PS#$P?$#`?+$\\83PQ,3QA,'Q`SM#\\@,!@?($\\0,!\\X3
MQQ/#$\\(3RA,'QPS;#\\L,$`4,!<(,P@8'U1/*$\\43PQ,3T1,'VPP&$`80!A`"
M!0P%#`4,!@P'!@?6$\\L3Q1/#$Q/N$P8,!A`&$`(&#`8,PP8'UQ/+$\\83PQ,3
M\\!/*!@?8$\\P3QA/#$Q/U$]L3S1/'$\\,3PA/U$]L3S1/'$\\,3PA,,````@```
M`(``@(````"`@`"``("`P,#`P-S`ILKP__OPH*"D@("`_P```/\\`__\\```#_
M_P#_`/______````@````(``@(````"`@`"``("`P,#`P-S`ILKP__OPH*"D
M@("`_P```/\\`__\\```#__P#_`/______````@````(``@(````"`@`"``("`
MP,#`P-S`ILKP__OPH*"D@("`_P```/\\`__\\```#__P#_`/______````@```
M`(``@(````"`@`"``("`P,#`P-S`ILKP__OPH*"D@("`_P```/\\`__\\```#_
M_P#_`/______````@````(``@(````"`@`"``("`P,#`P-S`ILKP__OPH*"D
M@("`_P```/\\`__\\```#__P#_`/______````@````(``@(````"`@`"``("`
MP,#`P-S`ILKP__OPH*"D@("`_P```/\\`__\\```#__P#_`/______````@```
M`(``@(````"`@`"``("`P,#`P-S`ILKP__OPH*"D@("`_P```/\\`__\\```#_
M_P#_`/______````@````(``@(````"`@`"``("`P,#`P-S`ILKP__OPH*"D
M@("`_P```/\\`__\\```#__P#_`/______````@````(``@(````"`@`"``("`
MP,#`P-S`ILKP__OPH*"D@("`_P```/\\`__\\```#__P#_`/______````@```
M`(``@(````"`@`"``("`P,#`P-S`ILKP__OPH*"D@("`_P```/\\`__\\```#_
M_P#_`/______````@````(``@(````"`@`"``("`P,#`P-S`ILKP__OPH*"D
M@("`_P```/\\`__\\```#__P#_`/______````@````(``@(````"`@`"``("`
MP,#`P-S`ILKP__OPH*"D@("`_P```/\\`__\\```#__P#_`/______````@```
J`(``@(````"`@`"`__OPH*"D@("`_P```/\\`__\\```#__P#_`/______
end