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/
