RE: InValid Characters

2004-02-09 Thread Bob Witney
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

UV secondary index

2004-02-09 Thread Margus.Kandelin
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

RE: UV secondary index

2004-02-09 Thread Anthony Youngman
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

RE: uvsql

2004-02-09 Thread Barry Rogen
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

Standard Deviation

2004-02-09 Thread Ray Buchner
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

Joseph Baker/Columbus/IBM is out of the office.

2004-02-09 Thread Joseph Baker
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]

Re: Wintegrate message box

2004-02-09 Thread Bryan Thorell
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

RE: UV command failing mystery

2004-02-09 Thread Vance Dailey
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

Re: InValid Characters

2004-02-09 Thread Timothy Snyder
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

MBSII or Profi'C

2004-02-09 Thread Glenn W. Paschal
(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

Secondary Indices on Distributed Files

2004-02-09 Thread gcanedy
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

Re: InValid Characters

2004-02-09 Thread Susan Lynch
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

Batch Mode Scanners

2004-02-09 Thread Karl L Pearson
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,

Re: using locate in compound true/false statement

2004-02-09 Thread Mats Carlid
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

Re: InValid Characters

2004-02-09 Thread Timothy Snyder
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

Re: [ADMIN] The aforementioned and promised NAG about OVERQUOTING

2004-02-09 Thread Ray DeGennaro at Eaglerock IS
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

RE: Help wanted creating an efficient SELECT statement

2004-02-09 Thread Ray DeGennaro at Eaglerock IS
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

Re: InValid Characters

2004-02-09 Thread Susan Lynch
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

Re: Batch Mode Scanners

2004-02-09 Thread Kent Walker
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

UNCLASSIFIED RE: UV secondary index

2004-02-09 Thread HENDERSON MICHAEL MR
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

RE: Wintegrate message box

2004-02-09 Thread Charlie Rubeor
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

Real Time Data Warehouse

2004-02-09 Thread Tom Firl
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

Tuning Tru64

2004-02-09 Thread kafsat taiyus
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,

Re: Real Time Data Warehouse

2004-02-09 Thread Results
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

Re: U2 System Guru

2004-02-09 Thread KAbraha454
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

Fred Finken is out of the office.

2004-02-09 Thread ffinken
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

Robert Ruschak is out of the office.

2004-02-09 Thread rruschak
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