Hey Anthony, I am trying to do the later. Thanks for asking, but someone on the list already clarified this for me. Thanks anyway.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Dzikiewicz Sent: Wednesday, December 08, 2004 10:06 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UD] How to access a particular ID in a select list Reading this Im confused. Are you looking to 'tweak' something already saved in &SAVEDLISTS& or are you trying to SELECT records in a file, delete them and then repeat the operation ? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Wednesday, December 08, 2004 9:54 AM To: [EMAIL PROTECTED] Subject: [U2][UD] How to access a particular ID in a select list Hi, Is there a way to access a particular ID in a select list? I want to write a para to do the following: Select a file with certain Ids and delete these selected records. I was thinking of writing something like the following (to delete all the records whose ID is greater than 5, say), but don't know what to replace <<FIRST.SELECTED.ID>> with in the following: LOOP SELECT XCF.SAV.TEST WITH @ID > 5 IF @SYSTEM.RETURN.CODE = 0 THEN GO DONE DELETE XCF.SAV.TEST <<FIRST.SELECTED.ID>> REPEAT DONE: I learned not to rely on @SYSTEM.RETURN.CODE for this. I remember getting burned by this. It had something to do with the record grouping - I really forget. I now write programs to do this kind of thing. I find it much easier. Is there a system variable that stores all the IDs in the select list? You could simply read the &SAVEDLISTS& file in a program and modify it that way. I don't think there is a system variable. The only thing that comes close is the default SAVEDLIST. Thanks Savita. ------- 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/
