450 Lynx formatting failed: open3: exec of lynx --stdin --dump --force_html
--hiddenlinks=ignore --localhost --image_links --nolist --noredir --noreferer
--realm failed at /etc/smrsh/demime line 1519
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
Dear all,
I have a problem with an I-type used in an association. Here is my
I-descriptor :
SUBR('SQ_CAL_SUB','GQ.COD.TAB',@RECORD3,@MV:'|':'TMDEFN':'|':'CT.ES');
SUBR('SQ_CAL_SUB','OEM2ANSI',@1)
When I use this descriptor in a select (through ODBC), I get this :
[EMAIL PROTECTED]E
And I wouldn't muck around in the stuff plumbers do for $120 an hour! ;^)
Regards,
Charlie Noah
[EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) writes:
My plumber chargers 60 an hour
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson
Re,
Inside a I-Type; SUBR is called only one time. The first.
You need to return a mv'ed dynamic array.
That the reason why there is many functions to manage mv'ed field.
Functions are usually postfixed by S like CHAR and CHARS.
You must have :
Chuck, I feel your pain. I've spent the good part of the last two weekends
fixing a similar problem. I'm not sure how big *very* large is in your world
is, in mine it was about 3GB.
Guide didn't find an error in the file but it would coredump when certain items
were filed. Programs trying to
I just came out of a meeting where it was stated that MV databases allow
non-unique keys.
Now I have been working in the VM world since 1983 and although I can
remember a time when some of the implementations had 'problems' with
hash and specific data in keys .. i can not think of a time when MV
Hi David,
It ain't so Joe!
All keys must be unique.
If I have a record with the ID of JoeItAintSo and I try to add another
record with the same key, it will just overwrite the original record. I can
have JoeItAintSo, JoeItAintSo1, JoeItAintSo2, etc., that works, maybe that
was what they were
Well certainly you have have two records with the same ID, but only if
there is more than a single file in play. I can have record X in both
file A and file B, but I cannot have a record with a key of X twice in
file A without some file corruption.
There is uniqueness within a single file, but
The person who had the comment has worked in the MV world for how long.
The only time I have seen this was when a file was corrupted.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 10:38 AM
To: U2 Users
I don't recall an MV implementation that intentionally allowed non-unique
primary keys. Were the people in the meeting thinking of secondary keys
(aka indexes) in which non-unique keys are quite possible?
The only other thing I can think of would be the old (and non-intentional!)
problems with
The only time I've seen duplicate key values in UniVerse files is when the file
has become corrupted. I suspect that doesn't fall into the assertion made in
your meeting, which is just plain wrong. Hashing algorithms wouldn't be as
effective as they are if duplicate key values were allowed.
The only other thing I can think of, using Universe Pick flavor account,
I can make a key of JOE and a key of joe which it thinks are two
different records. So keys are case sensitive.
That'd be the closest I can think of non-unique keys.
-Original Message-
From: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 1:37 PM
I just came out of a meeting where it was stated that MV databases allow
non-unique keys.
snip
Secondary keys perhaps, if you're considering the indexes as keys, but not
the primary key. Primary keys are by definition unique.
thanks for the early replies ..
it is good to know that i have not been wrong for the last 20 years g
.. well at least in this instance G
DSig
David Tod Sigafoos
SigsSolutions, Inc.
Original Message
Subject: RE: [U2] Unique Ids
From: Allen E. Elwood [EMAIL PROTECTED]
Perhaps they were referring to indexes? Such as a customer type field within
the customer file. You could have customer 123 and customer 456 with the same
customer type of WHL and the index on Customer Type would have WHL in there
'twice', once for each customer.
Thanks,
Marilyn A. Hilb
Indexes don't have to be unique. Is that what they were referring to ?
Anthony
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 1:38 PM
To: U2 Users List
Subject: [U2] Unique Ids
I just came out of a
However.. you now need to share those Twinkies.
Thanks,
Marilyn A. Hilb
Value Part, Inc
Direct: 847-918-6099
Fax: 847-367-1892
[EMAIL PROTECTED]
www.valuepart.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 2:03 PM
To:
Susan,
This is the approach I took with the speaker. There was a period of
time 'in the good old days' where the has could go goofy either through
corruption or keys containing system delimiters ..
But as the speaker (supposidly with the same term of experieince as I)
was teaching the benefits
I often wonder about SQL. scratching bald spot on head
BobW
-Original Message-
From: [EMAIL PROTECTED] [mailto:owner-u2-
[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, March 08, 2005 12:26 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Unique Ids
Dave:
Since D3 can be case-insensitive, it's possible to:
1) Create an item in (VOC) named Joe
2) Edit an item named JOE, which is the item Joe, and file it.
So, from a certain perspective, one could say that D3 allows an item named
JOE, JOe, joe, jOE, etc to share the same record key of Joe;
Aha - the 'same term of experience', but apparently not the same level of
understanding! Reminds me of a description by Jane Austen of a person
whose university experience had consisted of keeping the necessary number of
terms, but forming no useful acquaintance there... G
Susan Lynch
F.W.
Now you could have a situation where you brought a part file online that had
a duplicate key.
- Original Message -
From: Bob Woodward [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Tuesday, March 08, 2005 2:41 PM
Subject: RE: [U2] Unique Ids
I often wonder about SQL.
David,
I just came out of a meeting where it was stated that MV databases allow
non-unique keys.
perhaps the person was refering to multivalues?
If you were modelling parents and children in an SQL database you might
use a PARENTS table and a CHILDREN table. Usually neither table would
allow
How would you 'create' the part file to begin with having a non-unique
key.
If you are talking about say .. a csv file that is imported .. the csv
could have duplicate keys .. but i bet after the import the 'mv' table
will not have any duplicate keys.
DSig
David Tod Sigafoos
SigsSolutions,
The actual definition (relational or sql?) requires a unique column(or
set of columns). It is possible in *all* implementations to allow for
this to be missing. It is frowned upon .. but it is possible. Lots of
little 'features' depending on the implementation.
Like languages that are 'typed'
David,
If you added a new part to an existing distributed file, and the
new part already had records in it, you could potentially have records
in this new part whose item-id should be in another part based on the
partitioning algorithm. Then you could create that item-id in the
proper
You can do it with a Universe SQL table (Make MV values unique, that is).
In traditional UV tables, however, you are correct. The uniqueness in
this case is a combination of the primary key and the MV position.
I would also guess that the person in question was referring to
multivalues since
Vincent,
I am not sure why you get a one character answer one way and a full
word the other. I assume that's either in the nature of how your
SQ_CAL_SUB is written called, or from formatting applied differently
in the 2 methods. I think we need more context. Manu Fernandes seems
to be
Yes .. UV sql does allow that, and so does most Sql *servers* available
now. In fact Oracle has an inbedded structure now. Haven't played
with it .. i try to stay away from Oracle if I can.
I would also guess that the person in question was referring to
multivalues since traditional MV
The relevant code ( I am VERY sure source matches object):
072: BEGIN CASE
073: CASE ANS MATCHES '0N' ANS0
074: IF MITM5,ANS# THEN
075: IF MITM7,ANS# THEN GOSUB 200 ; IF ERR THEN GOTO 15
287: 200:*Subroutine For Password Check.
291: IF MITM7,ANS[1,1] = # THEN
310: IF
I'm glad I read through the rest of the messages before replying. Thank you
Ron for the explanation on my behalf.
- Original Message -
From: Pingilley, Ron [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Tuesday, March 08, 2005 4:33 PM
Subject: RE: [U2] Unique Ids
David,
If
Goo'day, Charles,
At 18:25 08/03/05 -0500, you wrote:
The relevant code ( I am VERY sure source matches object):
072: BEGIN CASE
073: CASE ANS MATCHES '0N' ANS0
074: IF MITM5,ANS# THEN
075: IF MITM7,ANS# THEN GOSUB 200 ; IF ERR THEN GOTO 15
287: 200:*Subroutine For Password
I'm not familiar with the Pick(r) DUMP command, but you can peer into a
group with fileview...
Simple syntax:
$UDTBIN/fileview -g1 VOC
You can dump blocks using the -b option (useful for overflow blocks -
chasing the links).
Different arguments for part files in dynamic files, etc.
Also - Colin
072: BEGIN CASE
073: CASE ANS MATCHES '0N' ANS0
074: IF MITM5,ANS# THEN
075: IF MITM7,ANS# THEN GOSUB 200 ; IF
I saw a case similar to this. There was this program
code which was looking for an address. There was an
index per building where the city code, civic number
Thanks Wally. I keep forgetting that I can use fileview. The good thing about
UniData is that I don't need it nearly as often :-). Dump is just like a hex
file viewer. Plus will follow the links backwards and forwards. Read only so
not dangerous.
I meant to not give quite enough details to
Hi Charles,
Thanks a lot for your help and explanation. Know, I understand the use
of the @MV in an I-descriptor. In my case, I can't use a BY-EXP clause
because I'm working with SQL statements sent through ODBC to Universe.
Finally, I made the modifications suggested by Manu Fernandes in my
We are in the process of upgrading a 800+ Universe system from 10.0.7 to
10.1.4, is anyone aware of any functionality that works at the previous
release but no longer at the upgrade release.
Many thanks,
Tim Franklin
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe
In UniData the '.' and '-' will evaluate as numeric. You might want to check
how these would fall through your logic in UniVerse.
hth
Colin Alfke
-Original Message-
From: Stevenson, Charles
The relevant code ( I am VERY sure source matches
Hi Tim
I think you'll have to reinstall ODBC drivers on each client. I don't
see anything else.
Best regards,
Vincent MASSON
Infodata Sarl
Tel : (352) 33 16 48
Fax : (352) 33 75 55
-Message d'origine-
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] De la part de Tim Franklin
Envoyi
I believe in a previous email I have read that it is possible to specify a
user name that you can supply on the command line to the PHANTOM command and
this user will be used to log on to run the command. Does anyone have the
details?
Tim Franklin
---
u2-users mailing list
40 matches
Mail list logo
