Take off the <> from the DELETE line. Add a DATA Y
before the REPEAT and it should do what you want.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita
Sent: 08 December 2004 14:54
To: [EMAIL PROTECTED]
Subject: [U2][UD] How to access a partic
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
Thank you so much Adrian.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews
Sent: Wednesday, December 08, 2004 9:50 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2][UD] How to access a particular ID in a select list
Take off the <> fr
Thank you so much guys.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Lance Jahnke
Sent: Wednesday, December 08, 2004 9:52 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2][UD] How to access a particular ID in a select list
SELECT XCF.SAV.TEST WITH @ID >
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
Se
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
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
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 t