<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:r_ansi;
panose-1:2 11 6 9 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="Section1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D">How about building a record complex something like this Quiz code:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;
font-family:r_ansi">access apmisumi link (doc-char + source-code + "12844161") to APMISUMI-KEY of apmisumi alias xpart optional<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;
font-family:r_ansi">select if source-code of apmisumi = "632654450" and not record xpart exists<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;
font-family:r_ansi"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;
font-family:r_ansi">rep doc-char source-code gm-part flag-905
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D">Based on the premise that you want SOURCE-CODE to be “632654450” then for each APMISUMI record found it will try to find a match using the questionable GM-PART.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D">The select statement will only get the ones that do not match to the selected GM-PART.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D">Can a similar structure be built in QDESIGN? Probably, I’ll leave that unanswered.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D">Regards<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D">Jay Nalder.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> powerh-l-bounces+jnalder=ascprofiles.com@lists.sowder.com [mailto:powerh-l-bounces+jnalder=ascprofiles.com@lists.sowder.com]
<b>On Behalf Of </b>Pandurang Rajpurohit<br>
<b>Sent:</b> Saturday, March 13, 2010 1:00 AM<br>
<b>To:</b> powerh-l@lists.sowder.com; Nisha B Pawar<br>
<b>Subject:</b> Problem in screen design<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">All</span> <br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">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.</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Here is example</span>
<br>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">> acc apmisumi</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">> show item</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> INPUT OUTPUT</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">APMISUMI TYPE SCALE SCALE DEC PICTURE</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> APMISUMI-KEY CHAR X(43)</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">* .DOC-CHAR CHAR X(15)</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> .SOURCE-CODE CHAR X(16)</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> .GM-PART CHAR X(12)</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> DOC-TYPE CHAR X(2)</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> ORD-NUM CHAR X(13)</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> CUST-ORD CHAR X(20)</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> ORD-TYPE CHAR X(2)</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> ORD-PART CHAR X(20)</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> PART-QTY NUM 0 0 0 ^.^^^.^^^</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> WHM-QTY-ORD NUM 0 0 0 ^^^^^^^^</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> WHM-QTY-REC NUM 0 0 0 ^^^^^^^^</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> SHIP-DATE DATE YYYY/MM/DD</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> WHM-REC-DATE DATE YYYY/MM/DD</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> FLAG-905 CHAR X(1)</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> PRIC-UNIT NUM 3 0 3 ^.^^^.^^^.^^...</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> VAT-CODE CHAR X(2)</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> CURR-CODE CHAR X(3)</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> ACT-COST-L NUM 4 0 4 ^^^.^^^.^^^,...</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> ACT-COST-F NUM 4 0 4 ^^^.^^^.^^^,...</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> AVC-COST NUM 3 0 3 ^.^^^.^^^.^^...</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> BEAF-INV CHAR X(1)</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> LOC-CUST CHAR X(9)</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> TOT-LINES NUM 0 0 0 ^.^^^</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> WHM-PLAN-CODE CHAR X(4)</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> WHM-IN-TYPE CHAR X(4)</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> FILLER CHAR X(42)</span>
<br>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">> acc apmisumi</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">> select if source-code = "632654450" and gm-part = " 12844161"</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">> rep doc-char source-code gm-part flag-905</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">> go</span> <br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">2010/03/13 OPEL P&A DATA DICTIONARY PAGE 1</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> Document number SOURCE CODE Gm Part Flag</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 905</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 000000000225071 632654450 12844161 C</span>
<br>
<br>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">> acc apmisumi</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">> select if source-code = "632654450" and gm-part <> " 12844161" and (flag-905="P" or flag-905="C")</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">> rep doc-char source-code gm-part flag-905</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">> go</span> <br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">2010/03/13 OPEL P&A DATA DICTIONARY PAGE 1</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> Document number SOURCE CODE Gm Part Flag</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 905</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 000000000225071 632654450 4726568 C</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 000000000225071 632654450 5064431 C</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 000000000225071 632654450 5325626 C</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 000000000225071 632654450 5409420 C</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 000000000225071 632654450 9121795 P</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 000000000225071 632654450 12790592 C</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 000000000225071 632654450 13219393 C</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 000000000225071 632654450 13253738 C</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 000000000301004 632654450 5333794 P</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 000000000301004 632654450 11609598 P</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 000000000301004 632654450 12762510 P</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 000000000301004 632654450 12767670 P</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 000000000301004 632654450 12797804 P</span>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif""> 000000000302065 632654450 9270120 P</span>
<br>
<br>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">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</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Can any one help me</span>
<br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">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 : pandurang.rajpurohit@in.ibm.com </span><o:p></o:p></p>
</div>
<br>
<hr>
<font face="Arial" color="Gray" size="1"><br>
<br>
NOTICE - This message and any attached files may contain information that is confidential, legally privileged or proprietary. It is intended only for use by the intended recipient. If you are not the intended recipient or the person responsible for delivering
the message to the intended recipient, be advised that you have received this message in error. Any dissemination, copying, use or re-transmission of this message or attachment, or the disclosure of any information therein, is strictly forbidden. BlueScope
Steel Limited does not represent or guarantee that this message or attachment is free of errors, virus or interference.<br>
<br>
If you have received this message in error please notify the sender immediately and delete the message. Any views expressed in this email are not necessarily the views of BlueScope Steel Limited.<br>
</font>
</body>
</html>