I am NOT suggesting this, but for accuracy you *can* use such
notation and do joins if you, 1) turn your account(s) into UniVerse
Schemas and 2) use UniVerse SQL instead of retrieve.
Of course, then constraints are enforced (you WILL properly mark your
field S or M, etc.), datatypes are enforced, and so forth. In other
words, while it sounds lovely, in the Real Word of UniVerse inherited-
from-who-knows-where applications, the application usually ties its
shoe laces together and tries to run down-hill.
It gets vewy, vewy, ugly.
I've helped clients do this, so if anyone wants to consider it,
contact me direct, off list.
--
Regards,
Clif
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER & ASSOCIATES
Tel: +1 619 460 5678 Web: www.oliver.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
On Jul 13, 2007, at 6:48 PM, Bob Woodward wrote:
If I understand what you're asking for, I'm not aware of a way to
use two
dictionaries in one Retrieve statement. You would, instead, create
dictionary entries in your primary file that accomplish the
"linking" to
other files for an attribute by attribute connection. Look up
xlate or
trans to be used in i-descriptor dictionary entries.
You're not in SQL-Kansas an more, Toto. :-)
BobW
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Friday, July 13, 2007 5:35 PM
To: [email protected]
Subject: [U2] syntax for joining two files in Retrieve statement using
Universe
I would like to populate a Retrieve statement in Universe joining
two files
linking common fields in those two files. What would be the syntax
to use to
accomplish my need? If I want to list in that Retrieve statement,
dictionary and non-dictionary items, is it just enough to Prefix
the file
name with a period after -example PM.PMID, POLI.VENDOR.
Thanks for the help.
Krish
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
