I love learning new things! I had never thought that MV ID were treated this way by a savedlists.
I can duplicate Philippe's results as he is using a common UniData application. PST.ROOM.ASSIGNMENTS is a MV field. SELECT PERSON.ST '0044560' SELECT PERSON.ST SAVING UNIQUE PST.ROOM.ASSIGNMENTS SAVE.LIST DWM.TEMP AE SAVEDLISTS DWM.TEMP000 001: 1606}2}1 002: 31}1}1 003: 3604}3}1 As Tom said doing a selection on the file the secondary IDs point to will strip the extra values. GET.LIST DWM.TEMP SELECT ROOM.ASSIGNMENT SAVE.LIST DWM.TEMP AE SAVEDLISTS DWM.TEMP 001: 1606 002: 31 003: 3604 Two more things I learned A: SELECT PERSON.ST '0044560' BY.EXP PST.ROOM.ASSIGNMENTS SAVE.LIST DWM.TEMP AE SAVEDLISTS DWM.TEMP000 001: 0044560}2}1 002: 0044560}1}1 003: 0044560}3}1 B: SELECT PERSON.ST '0044560' BY.EXP PST.ROOM.ASSIGNMENTS LIST ROOM.ASSIGNMENT Gives an error message, "Unable to find dictionary item for 35 SELECT PERSON.ST '0044560' BY.EXP PST.ROOM.ASSIGNMENTS" So, where does the savedlist store the information that the records stored in the list are associated with the field PST.ROOM.ASSIGNMENTS? David Morelli, UIS/Datatel Team -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, August 24, 2004 5:55 AM To: [EMAIL PROTECTED] Subject: Re: [U2] UNIDATA - SAVING UNIQUE and LIST.ALGEBRA > Date: 23 Aug 2004 16:26:54 -0300 > From: Philippe Parent <[EMAIL PROTECTED]> > ... > (where 'y' is the value marker) > > Why is there y1y1, y2y1, y3y1 appended at the end of > each ID? I'm guessing it has to do with the saving > unique feature or something? > ... > So first, what is the extraneous information at the end > of each ID in the SAVEDLISTS? ... The extra data is the attribute and value marks where the values were extracted. You can easily eliminate them by doing an EDIT-LIST (AE) and use the commands BD99999/^253 followed by a C99999/^253// If the data you're collecting are record IDs in a file, you can also select that file to get rid of the extra data. I suppose there's a good reason to keep the "source" info, but I wish there was a UDT.OPTION to turn it off... --Tom Pellitieri Century Equipment Toledo, OH ------- 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/
