Thanks.
If I add the no.optimize keyword, it changes all joins to an outer cartesian
join. So that's even worse ... (I haven't tried actually running it :-)
If a LEFT JOIN and LEFT OUTER JOIN are the same thing, that adds another
little oddity to the mix :-) Why is the optimiser using both
I tried using that but as you referred to, many sql environments do not
like, and to be redundant UV Sql
does not like the MAX reference
Barry Rogen
PNY Technologies, Inc.
Senior Programmer/Analyst
(973) 515 - 9700 ext 5327
[EMAIL PROTECTED]
There is a discussion here to either do completely away from UniVerse to
SQL because 99% of our servers are windows applications and our network
administrator doesn't know much about Linux and believes because we have
to open up telnet for UniVerse and an old application on a Solaris box
of Mumps
On your original point about telnet - I have not used telnet for years - I
ssh in to universe for a terminal session, uniadmin uses uniobjects, my
program editor uses uniobjects, and all my front ends connect via uniobjects
or uniobjects.net.
As far as going from linux to windows - I am sure
Brenda,
Have you considered turning off telnet and using ssh to log into
Universe/MUMPS? It should just be a simple .profile (or .bash_profile)
change. That will give you PCI compliance.
rex
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
Without actually knowing what you're really trying to achieve (as the
two queries are markedly different in what would be produced)... It
seems the second query should be an INNER JOIN - perhaps?
Seeing the EXPLAIN output of your original queries and the second one
with a INNER JOIN could be
Try:
uvSession.EncryptionEnabled = 1
True evaluates to -1 in VB usually.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jason Lin
Sent: Saturday, 19 July 2008 9:51 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Question about Uniobject and session
We do use .ssh to login to UniVerse. As far as Mumps I know little
about that, it may be that it is because it is such an old version and
old box that telnet can't be turned off for that. It is an extremely
old and antiquated dialer system that uploads data from the UniVerse and
returns usage
Telnet behind your own firewalled, secure Enterprise, IS PCI compliant.
Telnet across a non-secured, unencrypted connection is not.
As Rex stated, you could simply turn on SSH if you want added comfort.
On the subject of unencrypted communication, consider that MANY credit card
clearing houses
-Original Message-
From: [EMAIL PROTECTED] [mailto:owner-u2-
[EMAIL PROTECTED] On Behalf Of Brenda Price
Sent: Monday, July 21, 2008 10:10 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] converting from UniVerse on Redhat Linux to UniVerse on
Windows
There is a discussion here
10 matches
Mail list logo
