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/
