EXPLAIN is Universe-only, not Unidata. Sorry about that.
It goes anywhere on the RetrieVe command line.
If run from tcl, output is to the screen.
-Original Message-
From: Don Verhagen
Charles,
What is the syntax for the "EXPLAIN" keyword I don't see it documented
in Unidata (6.X)
I t
Traditional Sql (rdbms) doesn't support multi valies. You have to create tables
and relationships in sql to handle what a mv database can do in one record. I
have seen benchmarks where a mv db out performs oracle and other relational
databases simply because you don't have the "cost of joins" in
Thank you Kevin
The results were close and congratulations and appreciation must be given to
Kevin and other members who stood for election.
When we first started setting up the user group I was greatly concerned that
there would not be enough people volunteering and I am very pleased to see
th
Hi Dave
SQL Server like Oracle, DB2 and other RDBMS are limited to a 2 dimensional
table row * Column. There are a number of 3rd party products that attempt
to create a multidimensional environment on top particularly for data
warehousing but the underlying architecture is 2 dimensional.
Jbase
We use both Unidata and SQL. I wanted to see if SQL has the equivalent
of multivalues in Unidata. Or how does SQL handle mv's for instance.
David Jordan <[EMAIL PROTECTED]> wrote:
Do you want something to justify UniData to management or for evaluation for
development purposes.
Regards
David Jord
Do you want something to justify UniData to management or for evaluation for
development purposes.
Regards
David Jordan
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave S
Sent: Friday, 25 February 2005 9:30 AM
To: u2-users@listserver.u2ug.org
Subject:
This is a typical socket address condition that can't be safely overridden by
hand. If you look at your net stats, the socket in
question is probably in a CLOSE_WAIT state. This is a subsystem status that
says the remote has shutdown and it's waiting for the
socket to close and cleanup. If the s
Charles,
What is the syntax for the "EXPLAIN" keyword I don't see it documented in
Unidata (6.X)
I tried:
SELECT MY.FILE WITH MY.FILE="SOMETHING" EXPLAIN
All it did was select the records, does it EXPLAIN in a log file or somewhere
else?
Thanks,
--
Donald Verhagen
Application Deve
Under Universe 9.6, I found that it was much faster to do two selects,
the first one with just the index and then the second for the rest of
the conditions.
The new versions are supposed to optimize for indexing and also for
tfile conversions.
Roger
Kevin King wrote:
As I understand it, the q
[EMAIL PROTECTED] wrote:
I'm not sure this will help, but in Linux there's the /proc filesystem. In
that filesystem there's a file that represents everything that's going on.
Whenever I have a similar problem, I use fuser -k /proc/whatever/file and
that essentially 'closes' the process.
Karl
You ca
Does anyone know where I can get a document that explains the key
differences between the Unidata and SQL database ?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---
u2-users mailing li
I agree with Kevin's answer. Also, it may depend on which U2
product/pick-like product you are using.
I always try to order the WITH statements so the one selecting the
fewest records is first. However, I always place the fields with
translates last since I know that translates are much more exp
Generally speaking, you've got it right, John.
A few caveats, notes, gotchas:
- Use EXPLAIN keyword to get RetrieVe to show you what it is going to
do.
- If a field is indexed, and no select list is active when the retrieve
command starts, the index will be applied before any actual select &
da
> Is anyone aware of a way to force a socket port to close at the
> operating system level. We are currently using Sun 9.xx. We have a
> process that opens a port and accepts socket connections. Whenever we
> stop it and try to restart it, we get a port in use message. The only
> way that I've
As I understand it, the query optimizer can shuffle things around as
necessary, but the real issue is whether any of the fields are
indexed. If the fields are indexed you might get better response by
selecting those using an index first, and then subselecting the
remaining ones after the initial s
Is anyone aware of a way to force a socket port to close at the
operating system level. We are currently using Sun 9.xx. We have a
process that opens a port and accepts socket connections. Whenever we
stop it and try to restart it, we get a port in use message. The only
way that I've been able
Hi All,
Does the order of criteria matter in a select or list statement,
or is the execution order arbitrary?
For example, if I wanted to select vendors who sell apples in Denver,
is "Select vendors with location='Denver' and products='Apples'"
the same as "Select vendors with products=
I have UniData PE 6.0 installed on Windows XP and working like a champ.
I had been using it quite extensively for development. All of the
sudden I've started getting "invalid user name or password" when trying
to login. I've stopped the UniDataBase Service but when I try to start
it again I get an
> but with that syntax, wont PROGRAM2RUN execute regardless of whether
or not the SELECT returns results?
Yes. Like I said, it was "for the record".
I've deleted the original post, but I think the question was about this
syntax sometimes failing:
CLEARDATA
DATA 'PROGRAM2RUN'
EXECUTE 'S
Hey all,
All of this talk of web interfaces has gotten me to experiment with
InterCall .. I'm trying to get a sample program running InterCall to work on
a RedHat machine talking to a UDT database on an AIX machine .. I've
successfully gotten the ICTEST program to work native on the AIX machine,
an
but with that syntax, wont PROGRAM2RUN execute regardless of whether or not
the SELECT returns results?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Stevenson,
Charles
Sent: Thursday, February 24, 2005 8:32 AM
To: u2-users@listserver.u2ug.org
Subject: RE:
And, just for the record, you can also stack as many commands as you
wish like this:
COMMANDS = 'SELECT FILE'
COMMANDS<-1> = 'PROGRAM2RUN'
EXECUTE COMMANDS [ append optional parameters here ]
[snip]
> > Generally I prefer this syntax
> > EXECUTE "SELECT FILE",//IN. < PROGRAM2RUN
[snip]
> EXECU
22 matches
Mail list logo