Yes, I know load places a table lock, it's for that I do it with differents temporary tables. I mind, if more that one Load (in differents tables) on the same DB can give me a problem. As far I know it's possible, but I think the problem cames when you use a ascii files (maybe there's a problem between NT and R:base?)
On Wed, 10 Sep 2003 14:00:06 -0700 "Dan Goldberg" <[EMAIL PROTECTED]> wrote: > The "Load from" command places a table lock. So you might have to do it > using a different command. > > I use the following to import my ups tracking data: > > 1. PROJECT TEMPORARY tablename from upstracking using * where limit = 0 > > 2. GATEWAY IMPORT CSV daily.csv REPLACE tablename > > 3. append tablename to upstracking > > > upstracking is my destination table. tablename is the temporary table to > hold the imported data. > > You might have to change from CSV to something else depending on what kind > of ascii format. You can check R:syntax for details on these commands. > > Dan Goldberg > > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Wednesday, September 10, 2003 1:30 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - loading ascci files > > > Firts of all, tx for all your answers on my question about locks in > R:Base. > > This question is on the same way, because I read my code with your > suggesttions but I think my problem come from another think. > Firts I explain my situation: > > The apx files are compiled in Rbase 6.5 ++ and executed with Rtime > unlimited. We are using a NT server/ W2000 and 10 PC's workstations > with W98. > During the normal work all are good, the problems we have with the > "nigth process" this process collect invoices, process orders, > stadistics and so on. > > We collect invoices from our PDA (about 300 PDA #invoices around 5000 > per day). The data comes in ascci files and we use instruccions like > LOAD &tdv FROM &vout4 to do it, where &tdv is a different temporary > table for each sales office (up to 10) we process that using 4 PC's, each > PC process one different sales office at time. > Like all is using differents tables my only point that I think maybe > it's the cause of the message "waiting to access to a required resource > 25%" and keeps > until I push cancel button is the LOAD instruccion. > > Maybe there's a limit to simultaneous LOAD (ascii files)? and haw can I > solve that? > > > Best regards, > > Ramon Guardiola > fermatic Three system > Best regards Ramon Guardiola fermatic Three system
