RE: DDS WITH SELECT

Shannon,

Omit the 2nd 'S' as below.
Although I back the suggestion to use Omit over Select is in this
situation because you'd be omitting less records than you'd be selecting
(less work by the system).


A          R IMHISTF                   PFILE(IMHIST)
 * 
A          K ITNBR 
A          K HOUSE 
A          K TRNDT                     DESCEND 
 * 
A          S TCODE                     COMP(NE 'CU')
A            TCODE                     COMP(NE 'PH')

Kurt Anderson
Application Developer
Highsmith Inc

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Shannon.Wolf@xxxxxxxxxx
Sent: Friday, July 29, 2005 7:15 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: DDS WITH SELECT 

In the following DDS I am trying to exclude records with certain
transaction types.  To do this you'll see I put a select with a "COMP(NE
'CU')".  When I look at the file or run the program that uses this DDS,
I still get records with 'CU' and 'PH' transactions.  Am I forgetting
something?
A          R IMHISTF                   PFILE(IMHIST)
 * 
A          K ITNBR 
A          K HOUSE 
A          K TRNDT                     DESCEND 
 * 
A          S TCODE                     COMP(NE 'CU')
A          S TCODE                     COMP(NE 'PH')
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.