select the file
save the list
create a work file
edit the list
delete the invalid keys from the list
save the list
get the list
copy file 1 to work file
clear file 1
copy workl to file1 all
if i understood the problem
bob
-Original Message-
From: Brutzman, Bill [mailto:[EMAIL
Hello,
I have distributed UV file with total size about 2.5Gb.
I made secondary index
CREATE. INDEX file field1 ... field6
BUILD.INDEX file field1 ... field6
After that, rows inserting takes very long time.
(4000 rows. Server so busy, that other users can't do anything.
If I removed index then
Two tricks to speed things up ...
Firstly, would the NO.NULLS keyword speed things up? I'm guessing your
fields can often be blank, and in this case you will have a single huge
record knocking your index for six!
Secondly, would the pause and resume indexing commands work? During the
day, while
a. yes b. no c. yes and no d. yes
Barry Rogen
Senior Programmer
PNY Technologies
(973) 515 - 9700 ext 5327
[EMAIL PROTECTED]
_
The quality of a person's life is in direct
proportion to their commitment to excellence
regardless of their chosen field of
Is there a Universe Basic command to calculate standard deviation? If not,
does anyone have a sub?
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
I will be out of the office starting February 9, 2004 and will not return
until February 10, 2004.
I will be out of the office February 9. Please leave me a voice mail
message at (614) 659-7457 if your message is urgent.
--
u2-users mailing list
[EMAIL PROTECTED]
You could do it if your application has a single piece of code that
handles the input of data, in this area you could have it loop and check
for a message that needed to pop up when not getting characters. You
may also be able to tap into the windows messenger service to send
messages to
We upgraded our system from a 16 processor AV2 to an 8 processor
AV25000. Because each block of 4 cpus can only support 4gb of memory our
upgrade was going to cut our memory in half. So, the main purpose of the
changes was to cut the memory requirements of the universe lock tables. And
in fact
the systems I work on don't have EDIT-LIST, and I never think
to change the punctuation and try the revised form of the
commands - I grew up on EDIT-LIST and SAVE-LIST, etc.
The ECL parser should accept the dashed versions of these commands. Any
chance you have a VOC entry (or something
(sorry, last message had no subject... Resending.)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Glenn W. Paschal
Sent: Sunday, February 08, 2004 4:27 PM
To: [EMAIL PROTECTED]
Subject: (no subject)
Hello, group!
Can anyone tell me if they have used
I've got a Distributed File that I'm trying to create indices on. Four of
the fields are D-Types, and CREATE.INDEX runs fine for them. Three fields
though, are I-Types (that are compiled and working), where CREATE.INDEX
gives the following error:
I-descriptor must be compiled before
Tim,
Thanks - I just looked at CTLGTB and there is an entry there for both.
EDIT-LIST looks like this:
M
0
@UDTHOME/SYS_BP EDIT-LIST
root
EDIT.LIST looks the same, but has EDIT.LIST instead of EDIT-LIST.
In UDTHOME, we have a sys directory, which contains a SYS_BP file, which
contains
Background info:
We are considering the purchase of some type of handheld scanner that
will save our outside sales force the paper-pencil solutions they are
currently using.
Our idea is to have them enter a customer account number, then scan
barcodes affixed to bins where our product is kept,
Dangerous syntax this pick style locate.
It ooks like a function but it isn't.
Actually it is a statement with THEN ELSE clauses.
Once you realise that it's crystal clear .
You can't write IF READ ... and you can't write IF LOCATE() ...
but you can write WHILE READ and WHILE LOCATE()
as
I tried to respond a while ago, but my message came back with The
message's content type was not explicitly allowed. I'll try a different
cut-and-paste approach. Hopefully this isn't a duplicate for anybody
snip
Susan Lynch [EMAIL PROTECTED]
Thanks - I just looked at CTLGTB and there
If you are replying to several points, do not top-post.
This one really should be:
Don't Top-Post, especially if the reply is already Right Posted.
Here's two links:
http://www.netmeister.org/news/learn2quote.html
http://www.greenend.org.uk/rjk/2000/06/14/quoting
with some explanations of why
At 05:26 + 2004/02/06, Marco Manyevere wrote:
Short and easy to follow but N is not always numeric.
You can add a regular old variable to hold all of the prefixes, use a
LOCATE() to find the field number of the prefix and then use that to
access the array N. Going through all this, might
Tim,
UD 6.0.6 (but, if I remember correctly, this was true on the release 5 that
we came from as well, and our standard policy is to uninstall and re-install
Unidata for a new release, which should have replaced CTLGTB). This being
my first experience with the Unidata flavor, I thought it was
I've had success with Hand Held Product's Dolphin 7200 batch
scanner. The Dolphin is a very small, lightweight unit. The C language
compiler in their development kit is easy to use and the kit has several
templates which can be used to create applications like you apparently
need. The unit
Margus,
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Monday, 9 February 2004 10:23 p.m.
To: [EMAIL PROTECTED]
Subject: UV secondary index
Hello,
I have distributed UV file with total size about 2.5Gb.
I made
Many thanks! I am still having a little trouble with an extra carriage
return, but I am able to use most of the code you sent from either unibasic
or a posix script.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 07, 2004 1:40 AM
To: U2
So, I'm moving on from my encrypted database problem (that was put on hold) and now
I have a new, interesting problem. I'm looking at a proposal that seems to demand a
solution that is a cross between a data replication system and a data warehouse.
The system needs to be able to Extract data
Hello everybody,
We are running Unidata 5.2 on AlphaServer ES45 Model 2 Operating System:
Compaq Tru64 UNIX V5.1A
If we run sys_check it returns following suggestions.
Virtual Memory and Swap
Operational: Check the values of ubc-maxpercent, ubc-minpercent,
ubc-borrowpercent,
Tom,
Sixty to ninety days from now, I'll have a solution for you ::sigh:: I
have the UniVerse side in my Tier I product (Zeus) but the SQL won't be
until Tier II (in development) and I may or may not have the jBASE bits
by then.
You may want to look at writing a straight SQL read/write
Convert the file to a Distributed File type where each part file can be up to 2GB. We
had some distributed files with 40+ parts, yielding a 'logical' file of about 80GB.
ken
===
In a message dated 2/9/2004 10:38:23 PM Eastern Standard Time, [EMAIL PROTECTED]
writes:
Subj: U2 System Guru
I will be out of the office starting 02/09/2004 and will not return until
02/23/2004.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
I will be out of the office starting 02/09/2004 and will not return until
02/12/2004.
I will respond to your message when I return .Thank you
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
27 matches
Mail list logo