<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
John:<br>
<br>
How about...<br>
<br>
Read the doc-char file and output doc-char for each record where the
part="12844161".<br>
<br>
Then link the original file with this new file by doc-char and in the
case where there is no record in the linked file you extract the
details you need from the original file. If on the otherhand the link
finds the record in both files, then ignore all the doc-char in the
original file.<br>
<br>
Now, about creating the actual quiz code, it has been awile and I don't
have the manual handy.<br>
<br>
Olav.<br>
<br>
<br>
Pickering, John (NORBORD) wrote:
<blockquote
cite="midA9C59E8229335F4DA2F204E736E151680D2ED0A6@torexc251.norbord.com"
type="cite">
<div><font color="navy" face="Arial" size="2">Thanks for that
additional info -- I think I understand the problem. Let me state it
again -- if the doc-char contains part 12844161 in any record then you
do not want to select that doc-char. <br>
<br>
If that is the case then you will need two passes through the data. The
first pass should create a subfile with the key for the file and a flag
indicating the existence of part 12844161. The second pass reads this
subfile and gets the data for the desired records. <br>
<br>
In Quiz you could do something like:<br>
>Acc apmisumi<br>
>Define d-want char*1 &<br>
> = "N" if part = 12844161 &<br>
> Else ""<br>
>Sort on doc-char on d-want<br>
>Set subfile name sf1 at doc-char<br>
>Report summary doc-char &<br>
> D-want maximum<br>
<br>
This will create a subfile with all of the doc-char values and a flag
with either a blank or the letter "N". If the flag is "N" then the part
12844161 was found for this doc-char value and you don't want records
with this doc-char value. <br>
<br>
In the second pass you would start with this subfile, select only the
records with a blank d-want flag and link back to the original data
file. Something like:<br>
<br>
>Acc *sf1 link to apmisumi<br>
>Select sf1 if "" = d-want<br>
<br>
Hope this helps. <br>
<br>
Regards,<br>
JWP<br>
<br>
</font></div>
<br>
<div>
<hr tabindex="-1" align="center" size="2" width="100%"><font
face="Tahoma" size="2">
<b>From</b>:
<a class="moz-txt-link-abbreviated" href="mailto:powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com">powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com</a>
<a class="moz-txt-link-rfc2396E" href="mailto:powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com"><powerh-l-bounces+john.pickering=norbord.com@lists.sowder.com></a>
<br>
<b>To</b>: <a class="moz-txt-link-abbreviated" href="mailto:o.kappert@qc.aibn.com">o.kappert@qc.aibn.com</a> <a class="moz-txt-link-rfc2396E" href="mailto:o.kappert@qc.aibn.com"><o.kappert@qc.aibn.com></a>
<br>
<b>Cc</b>: Nisha B Pawar <a class="moz-txt-link-rfc2396E" href="mailto:nispawar@in.ibm.com"><nispawar@in.ibm.com></a>;
<a class="moz-txt-link-abbreviated" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a> <a class="moz-txt-link-rfc2396E" href="mailto:powerh-l@lists.sowder.com"><powerh-l@lists.sowder.com></a>
<br>
<b>Sent</b>: Sun Mar 14 04:31:48 2010<br>
<b>Subject</b>: Re: Problem in screen design
<br>
</font><br>
</div>
<br>
<font face="sans-serif" size="2">Olav</font>
<br>
<br>
<font face="sans-serif" size="2">The doc-char which contains that
part
should not be selected. Here the doc-char 000000000225071 contains
other parts along with 12844161 Hence it should not be selected.
Where as only doc-char 000000000301004 should be selected. </font>
<br>
<br>
<br>
<br>
<br>
<font face="sans-serif" size="2">Thanks & Regards<br>
Pandurang Rajpurohit,<br>
-----------------------------------------------------------------<br>
Project Manager <br>
GM - Powerhouse Tower (DDS)<br>
IBM Global Services India Pvt. Ltd. Pune<br>
Contact No : +91 020 40116372<br>
Mobile No : +91 9049009973<br>
EMAIL : <a class="moz-txt-link-abbreviated" href="mailto:pandurang.rajpurohit@in.ibm.com">pandurang.rajpurohit@in.ibm.com</a> <br>
<br>
</font>
<br>
<br>
<br>
<table width="100%">
<tbody>
<tr valign="top">
<td width="40%"><font face="sans-serif" size="1"><b><a class="moz-txt-link-abbreviated" href="mailto:o.kappert@qc.aibn.com">o.kappert@qc.aibn.com</a></b>
</font>
<p><font face="sans-serif" size="1">03/14/2010 04:42 AM</font>
<table border="1">
<tbody>
<tr valign="top">
<td bgcolor="white">
<div align="center"><font face="sans-serif" size="1">Please
respond to<br>
<a class="moz-txt-link-abbreviated" href="mailto:o.kappert@qc.aibn.com">o.kappert@qc.aibn.com</a></font></div>
</td>
</tr>
</tbody>
</table>
<br>
</p>
</td>
<td width="59%">
<table width="100%">
<tbody>
<tr valign="top">
<td>
<div align="right"><font face="sans-serif" size="1">To</font></div>
</td>
<td><font face="sans-serif" size="1">Pandurang
Rajpurohit/India/IBM@IBMIN</font>
</td>
</tr>
<tr valign="top">
<td>
<div align="right"><font face="sans-serif" size="1">cc</font></div>
</td>
<td><font face="sans-serif" size="1"><a class="moz-txt-link-abbreviated" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a>,
Nisha B Pawar/India/IBM@IBMIN</font>
</td>
</tr>
<tr valign="top">
<td>
<div align="right"><font face="sans-serif" size="1">Subject</font></div>
</td>
<td><font face="sans-serif" size="1">Re: Problem in
screen design</font></td>
</tr>
</tbody>
</table>
<br>
<table>
<tbody>
<tr valign="top">
<td>
<br>
</td>
<td><br>
</td>
</tr>
</tbody>
</table>
<br>
</td>
</tr>
</tbody>
</table>
<br>
<br>
<br>
<font size="3">Maybe I am missing something but....<br>
<br>
Based upon the info provided, </font><font face="sans-serif" size="2">part
12844161 is not in the report generated; therefore everything works as
you wanted it to.<br>
<br>
Olav.</font><font size="3"><br>
<br>
Pandurang Rajpurohit wrote: </font>
<br>
<font face="sans-serif" size="2"><br>
All</font><font size="3"> <br>
</font><font face="sans-serif" size="2"><br>
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.</font><font
size="3">
<br>
</font><font face="sans-serif" size="2"><br>
Here is example</font><font size="3"> <br>
<br>
</font><font face="sans-serif" size="2"><br>
> acc apmisumi</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
> show item</font><font size="3"> <br>
</font><font face="sans-serif" size="2"><br>
INPUT OUTPUT</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
APMISUMI
TYPE SCALE SCALE DEC
PICTURE</font><font size="3"> </font><font face="sans-serif" size="2"><br>
APMISUMI-KEY
CHAR
X(43)</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
* .DOC-CHAR
CHAR
X(15)</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
.SOURCE-CODE
CHAR
X(16)</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
.GM-PART
CHAR
X(12)</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
DOC-TYPE
CHAR
X(2)</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
ORD-NUM
CHAR
X(13)</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
CUST-ORD
CHAR
X(20)</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
ORD-TYPE
CHAR
X(2)</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
ORD-PART
CHAR
X(20)</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
PART-QTY
NUM 0
0 0 ^.^^^.^^^</font><font size="3"> </font><font
face="sans-serif" size="2"><br>
WHM-QTY-ORD
NUM 0 0
0 ^^^^^^^^</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
WHM-QTY-REC
NUM 0 0
0 ^^^^^^^^</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
SHIP-DATE
DATE
YYYY/MM/DD</font><font size="3"> </font><font
face="sans-serif" size="2"><br>
WHM-REC-DATE
DATE
YYYY/MM/DD</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
FLAG-905
CHAR
X(1)</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
PRIC-UNIT
NUM 3
0 3 ^.^^^.^^^.^^...</font><font size="3"> </font><font
face="sans-serif" size="2"><br>
VAT-CODE
CHAR
X(2)</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
CURR-CODE
CHAR
X(3)</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
ACT-COST-L
NUM 4
0 4 ^^^.^^^.^^^,...</font><font size="3"> </font><font
face="sans-serif" size="2"><br>
ACT-COST-F
NUM 4
0 4 ^^^.^^^.^^^,...</font><font size="3"> </font><font
face="sans-serif" size="2"><br>
AVC-COST
NUM 3
0 3 ^.^^^.^^^.^^...</font><font size="3"> </font><font
face="sans-serif" size="2"><br>
BEAF-INV
CHAR
X(1)</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
LOC-CUST
CHAR
X(9)</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
TOT-LINES
NUM 0
0 0 ^.^^^</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
WHM-PLAN-CODE
CHAR
X(4)</font><font size="3"> </font><font face="sans-serif" size="2"><br>
WHM-IN-TYPE
CHAR
X(4)</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
FILLER
CHAR
X(42)</font><font size="3"> <br>
<br>
</font><font face="sans-serif" size="2"><br>
> acc apmisumi</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
> select if source-code = "632654450" and gm-part = "
12844161"</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
> rep doc-char source-code gm-part flag-905</font><font size="3"> </font><font
face="sans-serif" size="2"><br>
> go</font><font size="3"> </font><font face="sans-serif" size="2"><br>
2010/03/13 OPEL
P&A DATA DICTIONARY
PAGE 1</font><font size="3"> <br>
</font><font face="sans-serif" size="2"><br>
Document number SOURCE CODE Gm Part
Flag</font><font size="3"> </font><font face="sans-serif" size="2"><br>
905</font><font size="3"> <br>
</font><font face="sans-serif" size="2"><br>
000000000225071 632654450
12844161 C</font><font size="3"> <br>
<br>
<br>
</font><font face="sans-serif" size="2"><br>
> acc apmisumi</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
> select if source-code = "632654450" and gm-part <>
" 12844161" and (flag-905="P" or flag-905="C")</font><font size="3">
</font><font face="sans-serif" size="2"><br>
> rep doc-char source-code gm-part flag-905</font><font size="3">
</font><font face="sans-serif" size="2"><br>
> go</font><font size="3"> </font><font face="sans-serif" size="2"><br>
2010/03/13 OPEL
P&A DATA DICTIONARY
PAGE 1</font><font size="3"> <br>
</font><font face="sans-serif" size="2"><br>
Document number SOURCE CODE Gm Part
Flag</font><font size="3"> </font><font face="sans-serif" size="2"><br>
905</font><font size="3"> <br>
</font><font face="sans-serif" size="2"><br>
000000000225071 632654450
4726568 C</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
000000000225071 632654450
5064431 C</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
000000000225071 632654450
5325626 C</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
000000000225071 632654450
5409420 C</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
000000000225071 632654450
9121795 P</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
000000000225071 632654450
12790592 C</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
000000000225071 632654450
13219393 C</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
000000000225071 632654450
13253738 C</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
000000000301004 632654450
5333794 P</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
000000000301004 632654450
11609598 P</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
000000000301004 632654450
12762510 P</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
000000000301004 632654450
12767670 P</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
000000000301004 632654450
12797804 P</font><font size="3"> </font><font face="sans-serif"
size="2"><br>
000000000302065 632654450
9270120 P</font><font size="3"> <br>
<br>
<br>
</font><font face="sans-serif" size="2"><br>
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</font><font
size="3">
<br>
</font><font face="sans-serif" size="2"><br>
Can any one help me</font><font size="3"> <br>
</font><font face="sans-serif" size="2"><br>
Thanks & Regards<br>
Pandurang Rajpurohit,<br>
-----------------------------------------------------------------<br>
Project Manager <br>
GM - Powerhouse Tower (DDS)<br>
IBM Global Services India Pvt. Ltd. Pune<br>
Contact No : +91 020 40116372<br>
Mobile No : +91 9049009973<br>
EMAIL : </font><a href="mailto:pandurang.rajpurohit@in.ibm.com"><font
color="blue" face="sans-serif" size="2"><u>pandurang.rajpurohit@in.ibm.com</u></font></a><font
face="sans-serif" size="2">
<br>
</font>
<br>
</blockquote>
</body>
</html>