of
the problem.
Any ideas on how to go about diagnosing this? Or thoughts as to what
might be the problem?
It would be awfully nice to have a log of all of the queries being
executed and how long they took, such as you can easily get from other
databases, like mysql, or PostGresql.
--
Geoffrey
able to claim
greenness and because of the price of gas.
Susan
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
--
Geoffrey Mitchell
Programmer/Analyst
Home Decorator's Collection
314-684-1062
---
u2-users mailing list
u2
.
Suggestions would be appreciated.
--Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
--
Geoffrey Mitchell
Programmer/Analyst
Home Decorator's Collection
314-684-1062
---
u2-users mailing list
u2-users
/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
--
Geoffrey Mitchell
Programmer/Analyst
Home Decorator's Collection
314-684-1062
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe
, but I thought I would throw it out.
There are similar Open Source products for Unix, though I have not had
experience with them.
--
Geoffrey Mitchell
Programmer/Analyst
Home Decorator's Collection
314-684-1062
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please
/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
--
Geoffrey Mitchell
Programmer/Analyst
Home Decorator's Collection
314-684-1062
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http
@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
--
Geoffrey Mitchell
Programmer/Analyst
Home Decorator's Collection
314-684-1062
---
u2-users mailing list
u2
, but this is my
understanding, and waht I have found to work.
--
Geoffrey Mitchell
Programmer/Analyst
Home Decorator's Collection
314-684-1062
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
records, unfortunately as many as 100 at a time. Is there a way to do
the query without locking records? We're not updating anything.
Pam
--
Geoffrey Mitchell
Programmer/Analyst
Home Decorator's Collection
314-684-1062
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe
://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
--
Geoffrey Mitchell
Programmer
be confident
that benchmark results are valid across all (similar?) implementations.
Because relational forbids knowing anything about the implementation,
any benchmark is valid for that one configuration only.
--
Geoffrey Mitchell
Programmer/Analyst
Home Decorator's Collection
314-684-1062
---
u2
empirical tests.
--
Geoffrey Mitchell
Programmer/Analyst
Home Decorator's Collection
314-684-1062
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
this before? Any ideas?
I have checked, and the Xalan library *is* there and appears to be
globally readable and executable.
--
Geoffrey Mitchell
Programmer/Analyst
Home Decorator's Collection
314-684-1062
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http
though.
-Original Message-
From: Geoffrey Mitchell [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 27, 2006 11:38 AM
To: Jerry Banker
Subject: Re: [U2] Question of permissions UV Linux
Are you creating the files from unix in the same directory that they are
being created in from UV
My guess would be that it is a literal equate. Search through the
includes and see if you can find where it is equated.
[EMAIL PROTECTED] wrote:
Are you sure it's not meant to go through a pre-compiler?
Hth
Colin Alfke
Calgary Canada
-Original Message-
From: Barry Rogen
To
Try replacing your READ's with READL's, or using TRANS(). In order to
preserve the integrity of the transaction, Universe requires certain
lock levels to be used within SQL transactions. If I remember
correctly, both READL and TRANS will work, as will SQL selects.
Jeff Marcos wrote:
Hi
To me, this is an issue of readability and maintainability. If I read
'IF VOID = THEN DEPOSITED ELSE *Voided*', I can make a reasonable
guess at what it is trying to do, without knowing anyghing about the
file structure. If you use numeric references to fields, you will
probably have to do
I have successfully used a stored procedure on UniVerse (not UD). I
have only called the procedure from a JDBC connection. When I try using
the same statement at the console, I get 'Illegal verb CALL.' It
works fine from JDBC, though. *shrug*
You might try using a parameter marker (?)
This doesn't work (at least on UV). The sample happens before the sort,
not after.
Otherwise, however, it's an ingenious idea. Incidentally, you could do
the same thing (at least in UV) without creating a new dictionary, by
using EVAL.
i.e.,
SELECT MYFILE BY EVAL RND(@TIME)
That way you
Have you checked the output of the select when performed from inside the
I-type? My guess is that it is generating a big ugly error, which is
why you are getting no records back. From my experience, performing
external selects from within an I-type is more than just a bad idea,
it's illegal.
Before you try to roll your own versions of all the various unix
utilities you may need, check out this: http://unxutils.sourceforge.net/
Joe Walter wrote:
Thanks Colin.
That sounds like a good approach - creating windows verions of the unix
commands
that is.
I might be able to pull that
Try doing echo $LIBPATH before and after setting it. I think that you
will see your problem.
Single quotes, in most shells I know, prevent variable expansion. If
you don't know what I mean, you will after you do the echo's.
Geoff
Metherall, Arthur wrote:
I'm trying to install the Easysoft
The correct syntax should be:
CREATE.TRIGGER trigger_name [BEFORE | AFTER] UPDATE ON file_name FOR EACH ROW
CALLING 'subroutine';
Note the semi-colon. All SQL commands end with one. Failure to include it will result
in the SQL+ prompt that you got.
The file does not have to be an SQL table,
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
List UV_USERS to find the initially configured administrator user. On
our system it is uvsql. I'm not sure if that is a standard or
something that we setup. At any rate, if you haven't done anything with
SQL, there should only be one user in there, but you are looking for
someone with
Richard Taylor wrote:
One other thing to watch out for is when you make an account into a Schema
normal, non-sql users, will not have access to the files anymore. If you
want to use the account as a Schema and as a regular UV account you can do
so but you will need to grant permissions to the
The help for END TRANSACTION says:
Use the END TRANSACTION statement to specify where processing is to
continue after a transaction ends.
This implies to me that there must be exactly one end transaction for
each begin transaction. It also implies that if you do a rollback,
execution will
,
at least...have not tested exhaustively) on the table. While the
trigger is there, it inserts the records with text mark separators
instead of my alternate separator. If I drop the trigger, the problem
goes away.
Has anyone else witnessed this?
--
Geoffrey Mitchell
Actually, the separator becomes a null character (char zero), not a text
mark
On Wed, 2004-08-11 at 17:31, Geoffrey Mitchell wrote:
OK, this is a strange one:
Platform: UV 10.0.16 / HP-UX 11.11
I have an SQL table with a multi-part primary key for which I have
specified an alternate
please visit http://listserver.u2ug.org/
---
[This E-mail scanned for viruses by Declude Virus]
--
Geoffrey Mitchell 314-684-1062
Programmer/Analyst [EMAIL PROTECTED]
Knights Direct
---
u2-users mailing list
[EMAIL
]
To unsubscribe please visit http://listserver.u2ug.org/
---
[This E-mail scanned for viruses by Declude Virus]
--
Geoffrey Mitchell 314-684-1062
Programmer/Analyst [EMAIL PROTECTED]
Knights Direct
---
u2-users
with that url? I tried searching on
u2ug.org but came up empty handed.
Perry
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Geoffrey
Mitchell
Sent: Monday, August 02, 2004 9:27 AM
To: [EMAIL PROTECTED]
Subject: Re: [U2] [UV] 10.x File Triggers
Search
http://listserver.u2ug.org/
---
[This E-mail scanned for viruses by Declude Virus]
--
Geoffrey Mitchell 314-684-1062
Programmer/Analyst [EMAIL PROTECTED]
Knights Direct
---
u2-users mailing list
[EMAIL PROTECTED
to this e-mail.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
[This E-mail scanned for viruses by Declude Virus]
--
Geoffrey Mitchell 314-684-1062
Programmer/Analyst
by replying to this message and delete this e-mail immediately.
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
---
[This E-mail scanned for viruses by Declude Virus]
--
Geoffrey Mitchell 314-684-1062
Programmer
35 matches
Mail list logo
