RE: InValid Characters

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 PROTECTED]

UV secondary index

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 in

RE: UV secondary index

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 t

RE: uvsql

I was trying to avoid the UniVerse level of copy - since the file in question has over a million records. I was trying in Unix (cp) to take advantage of the speed I would realize. The ULIMIT is set to 128000 Barry Rogen Senior Programmer PNY Technologies (973) 515 - 9700 ext 5327 [EMAIL PRO

RE: uvsql

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 endeavor

Standard Deviation

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.

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] http://www.oliver.com/mailma

Re: Standard Deviation

This should work... Key note that this takes into account 'bias'. Bias is basically defined to be used to determine whether the input set is complete or a sampling, and has to do with the accuracy of the information. If the input set is a complete list of values (a popluation), set Bias = 0.

Re: Wintegrate message box

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 users

Re: InValid Characters - shameless plug...

If you're on universe you could use the Universe File manager, just click on the item with the weird characters and press delete.. Bryan Thorell Brutzman, Bill wrote: Following the comments from Susan and Dave, the following worked... SELECT PS WITH @ID < 1 2 records selected... D

RE: UV command failing mystery

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

Mark, You are correct about EDIT.LIST, but 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. I keep forgetting that someone one of the predecessor products decided to move a

RE: using locate in compound true/false statement

Actually, "LOOP WHILE LOCATE" is incorrect syntax, and will fail on compilation. You have to use the PICK flavor of LOCATE to do this. Still, you are correct in that "LOOP WHILE LOCATE()" works fine, but "IF LOCATE() THEN" will not compile. A side note, TRUE.FALSE.FLAG = LOCATE() also will not

Re: InValid Characters

> 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 someth

MBSII or Profi'C

(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

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 execu

Re: InValid Characters

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 EDIT.LIS

RE: UV secondary index

Margus, Wol's answer hit the nail on the head and will probably sort out the problem, but if it does not you might need to sit down and consider the variation in what you are indexing, as that is the main reason why an index will slow (if you have a million records and you are trying to index a fi

Batch Mode Scanners

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, the

Re: using locate in compound true/false statement

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 y

RE: Batch Mode Scanners

you might want to check into the Symbol spt1800 http://www.symbol.com/products/mobile_computers/mobile_palm_spt1800.html -Original Message- From: Karl L Pearson [mailto:[EMAIL PROTECTED] Sent: Monday, February 09, 2004 11:02 AM To: u2-users Subject: Batch Mode Scanners Background info:

RE: Batch Mode Scanners

or these which are not quite as ruggedized but cheaper http://www.symbol.com/products/mobile_computers/mobile_palm_spt1550.html -Original Message- From: Jeff Schasny [mailto:[EMAIL PROTECTED] Sent: Monday, February 09, 2004 11:15 AM To: U2 Users Discussion List Subject: RE: Batch Mode Sca

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

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] http://www.oliver.com/mailma

Re: Batch Mode Scanners

Karl, I don't know about the cost of a first born child these days (we're several years past that), and I don't think you can get both "good" and "cheap" at the same time. But, we did a project for a customer using the Symbol 8100 series with a cellular phone connection and then (to offer a lower

Re: InValid Characters

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 > "Susan Lynch" <[EMAIL PROTECTED]> > >Thanks - I just looked at CTLGTB and th

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

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: with some explanations of

RE: Help wanted creating an efficient SELECT statement

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 jus

Re: InValid Characters

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 sta

Re: Batch Mode Scanners

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

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 m

RE: Wintegrate message box

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 User

Re: Standard Deviation

I've done this in an I-descriptor. The downside is that it's SD for a particular field only. Also, to invoke it you must use CALC on the command line, to trigger the TOTAL() functions. In the following example the data field is called F4. id: SD.F4 0001: I Standard deviation of F4; use CALC

wIntegrate script- dialog box?

wIntegrate v4.2.3. Is it possible to create a dialog box in a client-side script that is Non-Modal? When I use the dialog box editor, I don't get a choice, and it always creates a script that has a line like this: Style WS_CAPTION|WS_POPUP|WS_VISIBLE|WS_SYSMENU|DS_MODALFRAME The docs I got from

Real Time Data Warehouse

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 "Extrac

Tuning Tru64

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, vm-ubcdirtypercent,

Re: Real Time Data Warehouse

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 soluti

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

Ray DeGennaro at Eaglerock IS [EMAIL PROTECTED] wrote: > > > with some explanations of why Netiquette is the way is it. Ray, thank you for the informative links. Interesting to discover that w

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

Susan, Curious, I find the reverse to be true. Since I usually read in threads, I find that having to scroll through the last part to get to the current part mildly annoying. With the post after, I find myself skipping replies because the top looks familiar when I scan through my mail. -

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

Results <[EMAIL PROTECTED]> wrote in news:[EMAIL PROTECTED]: > Susan, > Curious, I find the reverse to be true. Since I usually read in > threads, I find that having to scroll through the last part to get to > the current part mildly annoying. With the post after, I find myself > skipping

Re VPN and Samba problem

Thanks to all who suggested solutions to my problem of not being able to access samba shares through VPN. Unfortunately nothing really helped, so we'll just have to wait for our facilities management support to come up with a solution. David Norman Senior Systems Engineer

RE: Re VPN and Samba problem

David, Any chance you could repost your problem? I am a new user but I have samba running through a vpn. JT -Original Message- From: Norman, David (SAAS) [mailto:[EMAIL PROTECTED] Sent: Monday, February 09, 2004 4:21 PM To: 'U2 User List' Subject: Re VPN and Samba problem Thanks to a

RE: using locate in compound true/false statement

> Actually, "LOOP WHILE LOCATE" is incorrect syntax, and will fail on > compilation. You have to use the PICK flavor of LOCATE to do this. actually the ideal syntax works just fine. partA = 'a' ; subAssemblyB = 'a':@am:'y':@am:'z' loop while locate partA in subAssemblyB by 'al' setting glue do

Re: [UV] Scope of ASSIGN 1 TO SYSTEM(1017) : Prevents translation of "@FM" into "\n" (newline) when "WRITE" to Type 1/19 files

Hi Herve, sorry I took so long to reply, I needed time to write the test programs. It seems that your reading of the UV code is only partially correct (assuming I got my tests right). I have attached my test code for you to look at. Tests 3 and 5 did not work as I expected. (if anyone on the lis

U2 System Guru

Hello all, A client of mine is looking for a Universe on NT system expert. He got into a situation where a file grow to 2GB. Neither he or I knew of the file limit on 32 bit files. He would like someone to do a health check on his system. We contacted IBM but their prices are a bit steep. Than

Re: U2 System Guru

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 >

Re: U2 System Guru

I am curious. What size system are you running? How many users, hardware etc. How many records do you have in 80GB? Thanks Eugene - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, February 09, 2004 9:19 PM Subject: Re: U2 Syst

RE: Real Time Data Warehouse

Another possible name for a real-time data warehouse is Operational Data Store (ODS). You will want a really good handle on the requirements for this. I have worked in this arena with U2 for almost a decade. There are many possibilities, but the biggest bang for the buck from my perspective is s

Re: U2 System Guru

Phil, What part of the country (which country) and what sort of a guru do you want? We have a lot of sharp people here if you need a housecall. - Charles 'A Chicken in Every Pot and a Guru on Every Mountain Top' Barouch Phil Grant wrote: Hello all, A client of mine is looking for a Univ

RE: Real Time Data Warehouse

Tom, Just for some more background here is the real reason you are having to go through the ETL is so that the users can "play" with your data using 'standard' BI tools like Cognos against the SQL database ? Also, what USE is the information going to be put to ?! I remember one of the "cla

RE: Batch Mode Scanners

Hmmm - batch mode why not go real-time online ? For a low cost alternative, I'd check out Worth Data (aka Worthington Data Systems) Ross Ferris Stamina Software Visage – an Evolution in Software Development >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >

Fred Finken is out of the office.

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.

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

RE: Real Time Data Warehouse

Hi Tom We customise many strategic systems to achieve this sort of facility. I would question how real time the OLAP & BI tools are never mind the database. I would look at breaking the data in two components as some details such as financial require to be snapshoted to ensure the integrity of t