Problem in screen design

[Pandurang Rajpurohit]

All

I am on screen design where a record which do not contain data passed are 
only be selected. Could you please help with query how can achieve.

Here is example


> acc apmisumi
> show item

                                             INPUT OUTPUT
APMISUMI                                TYPE SCALE SCALE  DEC PICTURE
  APMISUMI-KEY                          CHAR                  X(43)
* .DOC-CHAR                             CHAR                  X(15)
  .SOURCE-CODE                          CHAR                  X(16)
  .GM-PART                              CHAR                  X(12)
  DOC-TYPE                              CHAR                  X(2)
  ORD-NUM                               CHAR                  X(13)
  CUST-ORD                              CHAR                  X(20)
  ORD-TYPE                              CHAR                  X(2)
  ORD-PART                              CHAR                  X(20)
  PART-QTY                              NUM     0     0    0  ^.^^^.^^^
  WHM-QTY-ORD                           NUM     0     0    0  ^^^^^^^^
  WHM-QTY-REC                           NUM     0     0    0  ^^^^^^^^
  SHIP-DATE                             DATE                  YYYY/MM/DD
  WHM-REC-DATE                          DATE                  YYYY/MM/DD
  FLAG-905                              CHAR                  X(1)
  PRIC-UNIT                             NUM     3     0    3 
^.^^^.^^^.^^...
  VAT-CODE                              CHAR                  X(2)
  CURR-CODE                             CHAR                  X(3)
  ACT-COST-L                            NUM     4     0    4 
^^^.^^^.^^^,...
  ACT-COST-F                            NUM     4     0    4 
^^^.^^^.^^^,...
  AVC-COST                              NUM     3     0    3 
^.^^^.^^^.^^...
  BEAF-INV                              CHAR                  X(1)
  LOC-CUST                              CHAR                  X(9)
  TOT-LINES                             NUM     0     0    0   ^.^^^
  WHM-PLAN-CODE                         CHAR                  X(4)
  WHM-IN-TYPE                           CHAR                  X(4)
  FILLER                                CHAR                  X(42)


> acc apmisumi
> select if source-code = "632654450" and gm-part = "    12844161"
> rep doc-char source-code gm-part flag-905
> go
2010/03/13                  OPEL P&A DATA DICTIONARY PAGE   1

  Document number  SOURCE CODE       Gm Part       Flag
                                                   905

  000000000225071  632654450             12844161   C



> acc apmisumi
> select if source-code = "632654450" and gm-part <> "    12844161" and 
(flag-905="P" or flag-905="C")
> rep doc-char source-code gm-part  flag-905
> go
2010/03/13                  OPEL P&A DATA DICTIONARY PAGE   1

  Document number  SOURCE CODE       Gm Part       Flag
                                                   905

  000000000225071  632654450              4726568   C
  000000000225071  632654450              5064431   C
  000000000225071  632654450              5325626   C
  000000000225071  632654450              5409420   C
  000000000225071  632654450              9121795   P
  000000000225071  632654450             12790592   C
  000000000225071  632654450             13219393   C
  000000000225071  632654450             13253738   C
  000000000301004  632654450              5333794   P
  000000000301004  632654450             11609598   P
  000000000301004  632654450             12762510   P
  000000000301004  632654450             12767670   P
  000000000301004  632654450             12797804   P
  000000000302065  632654450              9270120   P



I need select only doc-char which does not contain part  12844161 for 
source code 632654450 but with this query the doc-char 000000000225071 is 
also selected even though it contain part 12844161

Can any one  help me

Thanks & Regards
Pandurang Rajpurohit,
-----------------------------------------------------------------
Project Manager 
GM - Powerhouse Tower (DDS)
IBM Global Services India Pvt. Ltd. Pune
Contact No : +91 020 40116372
Mobile No : +91 9049009973
EMAIL : pandurang.rajpurohit at in.ibm.com 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20100313/ade6ad81/attachment.htm