My suggestion would for Krish to get a very good understanding of what normal outputs are available in Retrieve and to understand the way our post-dictionary items work. AFAIK, all queries function on a primary data file and everything is relative to that file. Therefore, the answer is NO, you can not just type PM.PMID or POLI.VENDOR and the desired results magically appear.
His illustrated suggestions indicate that he comes from a different database where the file<dot>field style is normal and virtually required. Him learning that our applications do not need all the fields defined at the dicitonary level in order to work in Data/Basic will be one of his first surprises. From there he can learn that there's really 2 sides to the database: The unregulated updates from Basic and the later usage using retrieval languages. Therefore, the data/basic program need not know of the dictionary item called VENDOR to put data in the proper attribute assumed to be the vendor. It updates the field by field number, not by field name. While this may not cover his exact question, it should lay the foundation for learning how MV works in general and to begin to identify the differences between MV and SQL-style databases. If anyone is using a 4GL or other hamburger helper that performs the functions, then it should be made aware that these are private extensions of the MV data model and not MV by itself. My 2 cents Mark Johnson ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, July 13, 2007 8:35 PM 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/
