Not sure where to toss this into this thread so I'll start at the beginning. I wanted to see the solutions that would be offered. I blogged on exactly this topic back in 2008. The solution I published for D3 uses @environment variables to allow us to do inner queries with a tiny bit of simple and reusable code, no dict items, no work files, and no save-lists. Perhaps someone can describe the UD/UV-specific equivalents so that we can accomplish this here using similar methods? I'll be happy to add the U2 solution to the blog for future reference. http://Nebula-RnD.com/blog/tech/mv/2008/03/d3shell1.html
Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog http://LinkedIn.com/in/TonyGravagno http://Twitter.com/TonyGravagno http://PickWiki.com http://groups.google.com/group/MVDBMS http://www.LinkedIn.com/groups/Pick-Users-Group-64935 http://BitBucket.org/FOSS4MV/ > From: Hilk, Brandon > UniVerse 10.1, HP/UX, Pick. > Is there a way I can build a save-list from a selection from one file > X.INFO (where the record ID is an 8 digit number) and use that list to > select from file Y.INFO (where that 8 digit number is not the record ID > but does exist as a "foreign key" elsewhere in the file). In SQL this > would be considered a join and would look something like this: > > select * > from X.INFO, Y.INFO > where X.INFO.packet.id=Y.INFO.packet.id > and X.INFO.status='ccc'; > > I can run this in TCL and have it return the results I want but can't build > a save-list from it because I don't know the UniVerse/SQL syntax to do > so. > > So to summarize, is there a way to use a save-list built from X.INFO to > make another save-list comprised of the record ID's from Y.INFO? _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
