In UNIDATA, I can type this query:
LIST FILENAME WITH EACH DOODADD # AAA (Pick Flavor) or LIST FILENAME
WITH EVERY DOODAD # AAA (Unidata Flavor)
This would show me the items where **no** value in the Multivalue DOODAD
Attribute is AAA --
How do I achieve the same WITH EACH command work in
Hi David
You probably want to look at BY.EXP and WHEN for dealing with multivalues in
UniVerse
Regards
David Jordan
Managing Consultant
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Try:
LIST FILENAME WITHOUT EVERY DOODADD = AAA
This also allows you to list the excluded items, eg AAABBB
HTH
Brett
David Wolverton [EMAIL PROTECTED] wrote in message news:[EMAIL
PROTECTED]...
In UNIDATA, I can type this query:
LIST FILENAME WITH EACH DOODADD # AAA (Pick Flavor) or LIST
We may have an opportunity for a suitable U2 A/P to come and support our
existing systems for 18 months or so and then be cross trained to .Net
C# SQL and various other whizzy new technologies ahead of some major
development work.
Anyone interested (we are in Hampshire UK) email me ([EMAIL
I believe the Prime Information version of UniVerse acts like you'd expect.
The Pick version is like Prime Information with one hand tied behind its
back.
-- Louie
Some cause happiness wherever they go; others whenever they go.
- Oscar Wilde, 1854 - 1900
(from www.qotd.org)
---
Just to say my 2 pennies on that one - personally I much prefer Wintegrate to
Accuterm - Accuterm from the word go feels like an old vb 5 product - the
splash screen is straight out of the nineties, it all feels dare I say very
American :o . Wintegrate seems to have a much more modern approach,
I create VOC pointers:
PH for PH
SL for SAVEDLISTS
CO for COMO
HO for HOLD
On 10/11/07, Ron Hutchings [EMAIL PROTECTED] wrote:
The sites I've been around someone creates a voc pointer to SAVEDLISTS
named
SVL or SLV to save keystrokes.
---
u2-users mailing list
Have you tried Accuterm's WED (windows editor) or GED (Graphical design
environment) or are you just comparing it as an emulator.
I did a comparison between Accuterm Wintegrate 2 years ago for a client
and Accuterm won hands down. Plus, despite the features winning, the price
was phenomonal.
Is anyone using Accuterm in the Unidata environment (7.1)?
I downloaded an evaluation. The terminal emulation works OK, but when I
try to start the wED, I get this message
At ECL the computer complains about FTTCL not being a verb. I emailed
Accuterm support, but have gotten no response.
Where I work, we have recently installed Universe 10.2.25 which is supposed to
have the connection pooling functionnality for webservices.
Is the connection pooling option just something to turn on in Universe options
or must a new version of Uniobjects dll be used ? We use version 1.1.7073.0
Praise the Lord there are plenty of emulators to choose from.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
This is shifting into a less technical zone, so I am going to ask you
to move it to community.
Also, *Please, Please, Please* remember to trim quotes when
responding.
Apparently people are filtering out messages from the moderator, because
this topic won't die and people insist on
David,
LIST FILENAME WITHOUT DOODADD # AAA
David Wolverton wrote:
In UNIDATA, I can type this query:
LIST FILENAME WITH EACH DOODADD # AAA (Pick Flavor) or LIST FILENAME
WITH EVERY DOODAD # AAA (Unidata Flavor)
This would show me the items where **no** value in the Multivalue DOODAD
In UniData, I like using this statement for extraction:
LIST FILENAME WITH NOT(DOODADD EQ AAA)
There was something with negative extractions and that you need to watch
out for (forgot - UniData 6.x???) but using the NOT statement cleared
that problem. IDK how to this statement in UniVerse but
Charles,
I have used Accuterm in 7.1 since its release and before that 6.1.
It sounds like you did not get a good install.
Make sure you have the latest install programs - my Accuterm version
is 5.3.131. I think I download the latest when I first installed.
Also, did you type BASICTYPE P at TCL
Charles,
There is software you have to install into UniData before WED or GED
will work. Check the AccuTerm website for details. If you are still
stuck, e-mail me and I'll get you the instructions.
- Chuck
[EMAIL PROTECTED] wrote:
Is anyone using Accuterm in the Unidata environment
_
From: Roy Beard [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 16, 2007 12:17 PM
To: 'u2-users@listserver.u2ug.org'
Subject: Size of Key Question
Can someone comment on what effect if any the length of the key has on the
speed of disk access? The software I am working with has
The latest release is 5.3c (5.3.304), I just downloaded it Friday.
Brenda
-Original Message-
From: George R Smith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 16, 2007 10:40 AM
To: u2-users@listserver.u2ug.org
Cc: [EMAIL PROTECTED]
Subject: RE: Re[2]: [U2] Over-coming EDitor
I wouldn't expect much difference in file access speed with long record
keys versus short keys. What are you doing with the file that seems
slow? -- i.e. random reads of individual records, updates, sequential
selects and processing, etc. If the slowness is seen in an application
program, are
I came across a labor data file which I can perform the command...
LIST EPT.XREF F1 F2 F3 F4 F5 F6 F7 F8 F9 F10
EPT.XREF. 1-82613 (Work.Order.ID)
F1... 11231*215 (Date*Employee.ID)
F2... 11236*349
F3... 11239*214
F4... 11240*214
F5... 11245*354
Random reads and updates on a file with ~2 million records. I separated the
reads and writes to a separate program that only does this processing to no
avail.
Topas shows 100% disk usage during this process and all other users are
affected.
-Original Message-
From: [EMAIL PROTECTED]
Is F11 in the VOC ?
You may need to create it!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: Tuesday, October 16, 2007 1:23 PM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] LIST DICT F11
I came across a labor data file which I
ED VOC
Record name = F1
6 lines long.
: SAVE F11
F11 filed in file VOC.
: Q
File name= VOC
Record name = F11
6 lines long.
ED VOC F11
Brutzman, Bill wrote:
I came across a labor data file which I can perform the command...
LIST EPT.XREF F1 F2 F3 F4 F5 F6 F7 F8 F9 F10
EPT.XREF. 1-82613 (Work.Order.ID)
F1... 11231*215 (Date*Employee.ID)
F2... 11236*349
From what I can see this is technical discussion about interfacing with
U2.
-Original Message-
From: Timothy Snyder [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 16, 2007 10:08 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Over-coming EDitor shortcomings
This is shifting
Are you on Universe?
If so, the F1 etc records need to exist in VOC (not DICT VOC - just VOC)
to be accessible in all list commands.
Laure Hansen,
City of Redwood City
Information Technology
1017 Middlefield Road
Redwood City, CA 94063
Tel 650-780-7087
Fax 650-556-9204
[EMAIL PROTECTED]
Good answer. F11 was NOT in the VOC. The others... F2 thru F10 were IN the
VOC.
Thanks.
--Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of roy
Sent: Tuesday, October 16, 2007 1:50 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] LIST DICT F11
and the FILE.STAT?
On 10/16/07, roy [EMAIL PROTECTED] wrote:
Random reads and updates on a file with ~2 million records. I separated the
reads and writes to a separate program that only does this processing to no
avail.
Topas shows 100% disk usage during this process and all other users are
list EPT.XREF EVAL CONVERT(@FM,@VM,@RECORD)
(unidata)
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of roy
Sent: Tuesday, October 16, 2007 1:50 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] LIST DICT F11
Is F11 in the VOC ?
You may need to
To see the data unformatted use LIST-ITEM EPT.XREF.
-Original Message-
From: Brutzman, Bill [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 16, 2007 10:23 AM
To: 'u2-users@listserver.u2ug.org'
Subject: [U2] LIST DICT F11
I came across a labor data file which I can perform the
LIST.ITEM and SELECT * FROM can also be useful for qdirty.
On 10/16/07, roy [EMAIL PROTECTED] wrote:
Is F11 in the VOC ?
You may need to create it!
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: Tuesday, October 16, 2007
CT VOC F1
will show you the format of the items you need to add to the voc to create
more of these for your needs. You could just write a small program to add a
couple hundred of them and be done with it forever
*=aee=*
-Original Message-
From: [EMAIL PROTECTED]
It MAY be the case that there are 'unexpected' data types, in one,
possibly even two of our files. Occasionally (maybe 100 times per
second), a PHANTOM executed ITYPE will cause a message to be written
to the errlog, stating:
Tue Oct 16 07:14:53 0 user name Program .ITYPE.: pc = 38,
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of john reid
Sent: Tuesday, October 16, 2007 2:17 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Size of Key Question
and the FILE.STAT?
File name = SALES-HIST-BR1
File type
From what I can see this is technical discussion about interfacing with
U2.
OK - granted. But what about over-quoting? People are reminded about
this on a regular basis, and sometimes a special mention is made, as in
this case. Still they continue to include the entire history.
Tim Snyder
Using VB.NET (VS2005) with Uniobjects (IBMU2.UODOTNET)
The following code works fine, except when the select returns a list with
ONE item.
*
Public Function T4mGetSelectList(ByVal strCommand As String) As String()
Dim ECMD As
Some of us work for a living glancing at the emails offering help if we
can. In our haste we sometimes don't notice that the email has grown in
size. This is also one reason that I don't like in-line remarks. If I
don't see what they want at the top I delete it.
Jerry
-Original Message-
In general, the main problem with large, compound keys is that said keys do
not hash well; and by hash well I mean that they do not hash to proximate
groups, as for example, sequential numeric keys would.
There is read-ahead logic and RAM in your disk drive(s). There is read-ahead
logic and RAM
We are running UniData 7.1.10 on AIX 5.1. We set a TIMEOUT set for 1800
seconds in the LOGIN paragraph. If any user encounters a break condition,
that condition seems to turn off the TIMEOUT requirements. We have
attempted to use ONABORT to turn on the TIMEOUT but the re-setting does not
seem
This is a pretty ugly file! Here's what I see:
1) Modulo is way too big! 3 million groups for .9 million records;
1.6 GB physical space for 150 MB of data. Note the large number of
empty groups in the 25% column at the bottom of the FILE.STAT report.
Probably the modulo was pushed to TRY to
Wow, that's bizarre. I was able to replicate it on 7.1.9 by logging on,
setting the TIMEOUT, then starting SB+, then breaking, and the TIMEOUT is
gone. However, if I login, set the timeout, do NOT start SB+, but then
break and quit from TCL, the timeout is not lost.
So next I wrote a quick
Yes (agreeing with Jeff on file sizing isn't a very reckless thing to do),
except I'd stress this: don't use a seperation of 1. Go to 4, at least. If it
turns out that a high percentage of the records are over 2K, then try a sep of
8. In certain cases, you may want to go to 16, but this isn't one
Jeff F. will certainly have better critique, but it appears that the key
structure and hash-algorithm aren't very well suited to each other.
You have 883,026 records in 3,000,017 groups, and one of the groups has 7,417
records in it, so you have at least 2,124,407 empty groups.
I believe every
We are not running SB+, I know shame :-)
Tom
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kevin King
Sent: Tuesday, October 16, 2007 4:19 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Timeout and the break key.
Wow, that's bizarre. I was
Instead of ON.ABORT, have you experimented with ON.BREAK to reset it?
Seems like its been quite a while since any TIMEOUT behavior issues have
come across my desk.
IIRC we use the signal handler for TIMEOUT, so may not be too hard to
change the current behavior (though signals can be touchy).
Sounds like the file may be V E R Y poorly sized, as Jeff F suggested
Was this process fast previously? What has happened on the system
around the time it started to get slow? Are there any triggers on the
file
Ross Ferris
Stamina Software
Visage Better by Design!
-Original Message-
46 matches
Mail list logo