Has anyone developed or know of a way to do the equivalent of a UNION query in
UniData? I have 2 files, one is a daily file and the other is a monthly file.
At night the daily records get moved into the monthly file and the daily file
gets cleared. At month-end, the monthly data gets moved
MERGE.LIST has a UNION option.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Burwell, Ed
Sent: Wednesday, May 16, 2007 9:09 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] [UD] Union Query
Has anyone developed or know of a way to do the equivalent of a
All,
Please strip down unneeded parts of the quoted message. Some people
have size limits on email, some has slow connections, some use the
digest, some search the archives, and none of those people benefit from
over quoting.
- Charles Barouch, Moderator U2-Users, U2-Community,
Ed,
When I face this, I build a little BASIC program which builds a UNION
file which is keyed by file * item and then I do the Query against
that file. You could probably build the UNION file from triggers and
always keep it current.
Here's how it works:
If DAILY.FILE has three
I'm with you, Charles. We face this all the time, since Prelude's ADS
splits data into open and history files. Merging lists is all well and
good, but I still have to retrieve data from two separate files. I
always wind up writing Basic to do it, making independent selects from
each file and
Has anyone developed or know of a way to do the equivalent of a UNION query
in UniData? I have 2 files, one is a daily file and the other is a monthly
file. At night the daily records get moved into the monthly file and the
daily file gets cleared. At month-end, the monthly data gets moved into
A few months ago someone mentioned that a paper was forthcoming from IBM re
recommendations on running UniData on a SAN. Does anyone know the status of
this paper? I don't see anything out there yet.
tia
Brad
--
Not sure if sql is an option for you... but there is a union construct
in it. Both files have a '1' id. The ids are not shown in second
example.
j
SELECT @ID,DT FROM DAILY UNION SELECT @ID,DT FROM MONTHLY;
DAILY.DT1...
1 12-30-2001
1 08-12-2010
2
Question for everyone then: Should IBM invent a method to extend the Query
languages of UniData/UniVerse to do this 'Temporal File' - a Cross Data
File SELECT/LIST/SORT?
That is, should the logic for handling multiple datafiles with a common
dictionary basis be 'native' to the processes? Would
Keith,
I addition to the Universe database, you should have also downloaded the
associated Clients pkg.
This includes UniAdmin for administering Universe as well as Dynamic
Connect, a telnet client used to connect with Universe with any one of a
number of terminal emulations.
You can install
Amen David. My only interest in this is to do SORTs and LISTs. I haven't even
thought about the SELECT and READNEXT thing.
Ed
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of David Wolverton
Sent: Wednesday, May 16, 2007 12:26 PM
To:
David,
I'd vote for that! Here's the language I'd suggest:
SORT, LIST, SELECT, SSELECT (at minimum) should allow for data in
multiple data levels as an option. The keyword SPANNING would be used to
indicate which data levels or SPANNING ALL for all data levels. When
Spanning is used,
Hello
I was at a U2 Convention in Anaheim a few years ago, the first year U2
was part of the IBM. I had an opportunity to speak to a couple U2
engineers, sorry I've forgotten now who they were. I asked them if
they'd ever considered implementing this. Their reaction was pretty
much Why would
I vote no. The UV/UD query language is fundamentally designed to work
against one file with correlatives/I-types pointing to any other tables
from which we require related data. This is something at the core of our
environment. The problem here is, shall we say, problematic database
design.
I see you started the ball rolling on this... Does this also need to go to
U2AskUs?
That is, how much influence does BnB have on product direction?
Or does IBM need to hear this request directly from multiple VARs? (Which
we could probably coordinate in a day!)
DW
-Original Message-
I'd have to second David on this. I wish in Unibasic there was a
program/function to create temporary user files that get cleaned-up on exit and
let UD/UV determine the area to create these on the file system.
Donald Verhagen
Never clean my room when I was younger either
--
Donald Verhagen
Chuck:
Does UV have multi-level files? I thought it was restricted to UD and even
UD documentation doesn't recommend the structure because it's too Pick-like.
:-)
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Charles Barouch
Sent: Wednesday,
We know that's the CURRENT fundamental design... We're talking an extension
to that design for those who would find it useful. I never use many parts of
UniData - should those be removed because I don't see the need? g
The issue is that UniData (where we all are) does NOT have a PartFile. If
we
We have one customer very happy with their LeftHand Networks SAN, and
another about to install one.
I think IBM is squeamish with the competition for bandwidth - at the IOD
last year, they in particular said that Exchange places such a heavy demand
on the disk subsystem, that it should not be
Hello All,
Does anyone have any information or experience with software written for
Unidata, in this case on windows 2003, that does form generation for formatted
reporting? Say for example payroll checks, w2's, ap checks, etc.
If so I'd like to check it out.
Thanks,
Terry
---
u2-users
Which we were you speaking of? Just kidding, seemed like such a great
sentence I could not resist.
Anyway, since it already exists in Universe my guess would be that
implementing multi part files would be easier, and less kludgey, than
implementing some sort of file spanning, temp file
Bill,
Sure does.
CREATE.FILE ML
CREATE.FILE DATA ML,TOO
You end up with one DICT and two DATA levels.
- Chuck Just Retested It Barouch
Bill Haskett wrote:
Does UV have multi-level files?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
We use PlanetPress Suite from Objectif Lune - http://www.objectiflune.com
It is great software - I spool data to it as if it were a printer. A process
identifies what form the data should be merged into, where it should be
printed, if a PDF should be created, etc.
In our shop we print letters
Does anyone know how this is handled and what the syntax is in other
database reporting tools? That might be a good start for an implementation
on U2. I for one do not know.
Tom Dodds
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny
Sent:
Hi all,
IBM tech support just made me aware of an apparently
undocumented feature that was added to SET.INDEX in release 10.1
allowing a relative path for the index file.
SET.INDEX filename TO RELATIVE.PATH
This command will set the index pathname to ./I_filename eliminating
Check out UnForm from Synergetic Data Systems (http://www.sdsi.com). It's a
great product with great support. I've implemented it in a UniData on Unix
environment. It uses an external rule file to mark up the page, so you
don't need to make any changes to your programs. The latest version
The COPYing of files and the failure to perform the set SET.INDEX command
after the copy, has caused numerous system failures. (One site failed
just last week.)
Jeff Fitzgerald's excellent e-mail is a must be read by all UV shops.
You may wish to consider changing every index you have on your
27 matches
Mail list logo