Thanks Paul.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Trebbien Sent: Wednesday, December 08, 2004 1:05 PM To: '[EMAIL PROTECTED]' Subject: RE: [U2][UD] How to access a particular ID in a select list Are you after something of this nature: 0001: * PROGRAM : PT.TEST 0002: ****************************************************************** 0003: * 0004: STMT=\SELECT INV-TABLE\ 0005: EXECUTE STMT 0006: SELECT TO LIST1 0007: EOF=0 0008: LOOP 0009: READNEXT ID FROM LIST1 ELSE EOF=1 0010: UNTIL EOF DO 0011: PRINT ID 0012: REPEAT 0013: PRINT '**** End of List ****' 0014: END Have a Great Day! > Paul Trebbien > Kore Technologies, Senior Support Tech. > "Solutions that work. People who care." > V 858.678.0030 F 858.300.2600 W www.koretech.com > -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Chauhan, Savita Sent: Wednesday, December 08, 2004 6: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: Is there a system variable that stores all the IDs in the select list? 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/