SELECT XCF.SAV.TEST WITH @ID > 5 IF @SYSTEM.RETURN.CODE LE "0" THEN GO DONE DELETE XCF.SAV.TEST DONE:
You don't need a loop. The select statement will contain all the items selected and the delete will delete them. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: Wednesday, December 08, 2004 8: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/
