<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hi All <BR>
<BR>
<BR>
I think the following would work in Qdesign.<BR>
<BR>
file apmisumi<BR>
select if source-code = "632654450" and gm-part <> " 12844161" &<BR>
and (flag-905="P" or flag-905="C") <BR>
<BR>
file apmisumi secondary alias bad_part <BR>
access via <FONT face=Arial>APMISUMI-KEY &</FONT><BR>
<FONT face=Arial> using doc-char +"632654450" + " 12844161" </FONT><BR>
<FONT face=Arial></FONT> <BR>
<FONT face=Arial></FONT> <BR>
<FONT face=Arial> Procedure Find</FONT><BR>
<FONT face=Arial> Begin</FONT><BR>
<FONT face=Arial> Get apmisumi</FONT><BR>
<FONT face=Arial> Get bad_part optional</FONT><BR>
<FONT face=Arial> If NOT NEWRECORD of bad_part</FONT><BR>
<FONT face=Arial> then error " "</FONT><BR>
<FONT face=Arial> End</FONT><BR>
<FONT face=Arial></FONT> <BR>
<FONT face=Arial>Regards,</FONT><BR>
<FONT face=Arial>Peter</FONT><BR>
<FONT size=2 face=Verdana></FONT> <BR>
<BR>
<FONT size=2 face=Verdana></FONT> <BR>
<FONT size=2 face=Verdana>rep doc-char source-code gm-part flag-905 <BR><BR></FONT>
<BR>
<BR> <BR>
<HR id=stopSpelling>
To: peterbateman808@hotmail.com<BR>CC: jnalder@ascprofiles.com; powerh-l@lists.sowder.com; powerh-l-bounces+pandurang.rajpurohit=in.ibm.com@lists.sowder.com; vidyasagar.goparaju@kewill.com<BR>Subject: RE: Problem in screen design<BR>From: pandurang.rajpurohit@in.ibm.com<BR>Date: Wed, 17 Mar 2010 11:26:54 +0530<BR><BR><BR><FONT size=2 face=sans-serif>I think this query doesn't work in screen (QDESIGN). Need query in designing screen</FONT> <BR><BR><FONT size=2 face=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 <BR><BR></FONT><BR><BR><BR>
<TABLE width="100%">
<TBODY>
<TR vAlign=top>
<TD width="40%"><FONT size=1 face=sans-serif><B>Peter Bateman <peterbateman808@hotmail.com></B> </FONT><BR><FONT size=1 face=sans-serif>Sent by: powerh-l-bounces+pandurang.rajpurohit=in.ibm.com@lists.sowder.com</FONT>
<FONT size=1 face=sans-serif>03/16/2010 11:59 PM</FONT> <BR>
<TD width="59%">
<TABLE width="100%">
<TBODY>
<TR vAlign=top>
<TD>
<DIV align=right><FONT size=1 face=sans-serif>To</FONT></DIV>
<TD><FONT size=1 face=sans-serif><vidyasagar.goparaju@kewill.com>, <jnalder@ascprofiles.com>, PowerHouse List <powerh-l@lists.sowder.com></FONT>
<TR vAlign=top>
<TD>
<DIV align=right><FONT size=1 face=sans-serif>cc</FONT></DIV>
<TD>
<TR vAlign=top>
<TD>
<DIV align=right><FONT size=1 face=sans-serif>Subject</FONT></DIV>
<TD><FONT size=1 face=sans-serif>RE: Problem in screen design</FONT></TR></TBODY></TABLE><BR>
<TABLE>
<TBODY>
<TR vAlign=top>
<TD>
<TD></TR></TBODY></TABLE><BR></TR></TBODY></TABLE><BR><BR><BR><FONT size=2 face=Verdana>Hi All:<BR><BR>I think the following should eliminate the doc_char records if any one has the bad gm part. I once drove an Opel, a nice car!<BR><BR>acc apmisumi link ( doc-char +"632654450" + " 12844161" ) to </FONT><FONT size=2 face=Arial>APMISUMI-KEY </FONT><FONT size=2 face=Verdana>of apmisumi alias bad_part optional<BR>select apmisumi if source-code = "632654450" and gm-part <> " 12844161" and (flag-905="P" or flag-905="C") <BR>select if not record bad_part exists<BR>rep doc-char source-code gm-part flag-905 <BR>go<BR><BR></FONT>
<HR>
<FONT size=2 face=Verdana>Subject: RE: Problem in screen design<BR>Date: Mon, 15 Mar 2010 11:50:45 -0400<BR>From: Vidyasagar.Goparaju@kewill.com<BR>To: JNalder@ascprofiles.com; powerh-l@lists.sowder.com<BR></FONT><BR><FONT color=#000080 size=2 face=Arial>This is a single file, simple query. If you say don’t select a record that has part-number = ‘x’ it should not select it…it is that simple.</FONT> <BR><FONT color=#000080 size=2 face=Arial> </FONT> <BR><FONT color=#000080 size=2 face=Arial>Only thing that I can think of is the gm-part field that you see on the report is different from what is in your select statement. I guess it is that white space in front of the part number.</FONT> <BR><FONT color=#000080 size=2 face=Arial> </FONT> <BR><FONT color=#000080 size=2 face=Arial> </FONT> <BR><FONT color=#000080 size=2 face=Arial>Thy the following:</FONT> <BR><FONT color=#000080 size=2 face=Arial> </FONT> <BR><FONT size=2 face=Arial>acc apmisumi</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR>select if source-code = "632654450" and “12844161” <> </FONT><FONT color=#ff00ff size=2 face=Arial><B>TRUN(LJ(gm-part))</B></FONT><FONT size=2 face=Arial> and (flag-905="P" or flag-905="C")</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR>rep doc-char source-code gm-part flag-905</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR>go</FONT><FONT size=2 face=Verdana> <BR></FONT><BR><FONT color=#000080 size=2 face=Arial> </FONT> <BR><FONT color=#000080 size=2 face=Arial> </FONT> <BR><FONT color=#000080 size=2 face=Arial> </FONT>
<DIV align=center>
<HR>
</DIV><BR><FONT size=2 face=Tahoma><B>From:</B> powerh-l-bounces+vidyasagar.goparaju=kewill.com@lists.sowder.com [mailto:powerh-l-bounces+vidyasagar.goparaju=kewill.com@lists.sowder.com] <B>On Behalf Of </B>Nalder, Jay<B><BR>Sent:</B> Monday, March 15, 2010 10:28 AM<B><BR>To:</B> powerh-l@lists.sowder.com<B><BR>Subject:</B> RE: Problem in screen design</FONT> <BR><FONT size=3 face="Times New Roman"> </FONT> <BR><FONT color=#004080 size=2 face=Calibri>How about building a record complex something like this Quiz code:</FONT> <BR><FONT color=#004080 size=2 face=Calibri> </FONT> <BR><FONT size=2>access apmisumi link (doc-char + source-code + "12844161") to APMISUMI-KEY of apmisumi alias xpart optional</FONT> <BR><FONT size=2>select if source-code of apmisumi = "632654450" and not record xpart exists</FONT> <BR><FONT size=2> </FONT> <BR><FONT size=2>rep doc-char source-code gm-part flag-905 </FONT><BR><FONT color=#004080 size=2 face=Calibri> </FONT> <BR><FONT color=#004080 size=2 face=Calibri>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.</FONT> <BR><FONT color=#004080 size=2 face=Calibri>The select statement will only get the ones that do not match to the selected GM-PART.</FONT> <BR><FONT color=#004080 size=2 face=Calibri> </FONT> <BR><FONT color=#004080 size=2 face=Calibri>Can a similar structure be built in QDESIGN? Probably, I’ll leave that unanswered.</FONT> <BR><FONT color=#004080 size=2 face=Calibri> </FONT> <BR><FONT color=#004080 size=2 face=Calibri> </FONT> <BR><FONT color=#004080 size=2 face=Calibri>Regards</FONT> <BR><FONT color=#004080 size=2 face=Calibri>Jay Nalder.</FONT> <BR><FONT color=#004080 size=2 face=Calibri> </FONT> <BR><FONT color=#004080 size=2 face=Calibri> </FONT> <BR><FONT size=2 face=Tahoma><B>From:</B> 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<B><BR>Sent:</B> Saturday, March 13, 2010 1:00 AM<B><BR>To:</B> powerh-l@lists.sowder.com; Nisha B Pawar<B><BR>Subject:</B> Problem in screen design</FONT> <BR><FONT size=3 face="Times New Roman"> </FONT> <BR><FONT size=2 face=Arial><BR>All</FONT><FONT size=2 face=Verdana> <BR></FONT><FONT size=2 face=Arial><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=2 face=Verdana> <BR></FONT><FONT size=2 face=Arial><BR>Here is example</FONT><FONT size=2 face=Verdana> <BR><BR></FONT><FONT size=2 face=Arial><BR>> acc apmisumi</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR>> show item</FONT><FONT size=2 face=Verdana> <BR></FONT><FONT size=2 face=Arial><BR> INPUT OUTPUT</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR>APMISUMI TYPE SCALE SCALE DEC PICTURE</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> APMISUMI-KEY CHAR X(43)</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR>* .DOC-CHAR CHAR X(15)</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> .SOURCE-CODE CHAR X(16)</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> .GM-PART CHAR X(12)</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> DOC-TYPE CHAR X(2)</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> ORD-NUM CHAR X(13)</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> CUST-ORD CHAR X(20)</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> ORD-TYPE CHAR X(2)</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> ORD-PART CHAR X(20)</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> PART-QTY NUM 0 0 0 ^.^^^.^^^</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> WHM-QTY-ORD NUM 0 0 0 ^^^^^^^^</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> WHM-QTY-REC NUM 0 0 0 ^^^^^^^^</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> SHIP-DATE DATE YYYY/MM/DD</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> WHM-REC-DATE DATE YYYY/MM/DD</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> FLAG-905 CHAR X(1)</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> PRIC-UNIT NUM 3 0 3 ^.^^^.^^^.^^...</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> VAT-CODE CHAR X(2)</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> CURR-CODE CHAR X(3)</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> ACT-COST-L NUM 4 0 4 ^^^.^^^.^^^,...</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> ACT-COST-F NUM 4 0 4 ^^^.^^^.^^^,...</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> AVC-COST NUM 3 0 3 ^.^^^.^^^.^^...</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> BEAF-INV CHAR X(1)</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> LOC-CUST CHAR X(9)</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> TOT-LINES NUM 0 0 0 ^.^^^</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> WHM-PLAN-CODE CHAR X(4)</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> WHM-IN-TYPE CHAR X(4)</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> FILLER CHAR X(42)</FONT><FONT size=2 face=Verdana> <BR><BR></FONT><FONT size=2 face=Arial><BR>> acc apmisumi</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR>> select if source-code = "632654450" and gm-part = " 12844161"</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR>> rep doc-char source-code gm-part flag-905</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR>> go</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR>2010/03/13 OPEL P&A DATA DICTIONARY PAGE 1</FONT><FONT size=2 face=Verdana> <BR></FONT><FONT size=2 face=Arial><BR> Document number SOURCE CODE Gm Part Flag</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> 905</FONT><FONT size=2 face=Verdana> <BR></FONT><FONT size=2 face=Arial><BR> 000000000225071 632654450 12844161 C</FONT><FONT size=2 face=Verdana> <BR><BR><BR></FONT><FONT size=2 face=Arial><BR>> acc apmisumi</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR>> select if source-code = "632654450" and gm-part <> " 12844161" and (flag-905="P" or flag-905="C")</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR>> rep doc-char source-code gm-part flag-905</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR>> go</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR>2010/03/13 OPEL P&A DATA DICTIONARY PAGE 1</FONT><FONT size=2 face=Verdana> <BR></FONT><FONT size=2 face=Arial><BR> Document number SOURCE CODE Gm Part Flag</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> 905</FONT><FONT size=2 face=Verdana> <BR></FONT><FONT size=2 face=Arial><BR> 000000000225071 632654450 4726568 C</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> 000000000225071 632654450 5064431 C</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> 000000000225071 632654450 5325626 C</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> 000000000225071 632654450 5409420 C</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> 000000000225071 632654450 9121795 P</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> 000000000225071 632654450 12790592 C</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> 000000000225071 632654450 13219393 C</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> 000000000225071 632654450 13253738 C</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> 000000000301004 632654450 5333794 P</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> 000000000301004 632654450 11609598 P</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> 000000000301004 632654450 12762510 P</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> 000000000301004 632654450 12767670 P</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> 000000000301004 632654450 12797804 P</FONT><FONT size=2 face=Verdana> </FONT><FONT size=2 face=Arial><BR> 000000000302065 632654450 9270120 P</FONT><FONT size=2 face=Verdana> <BR><BR><BR></FONT><FONT size=2 face=Arial><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=2 face=Verdana> <BR></FONT><FONT size=2 face=Arial><BR>Can any one help me</FONT><FONT size=2 face=Verdana> <BR></FONT><FONT size=2 face=Arial><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 : pandurang.rajpurohit@in.ibm.com </FONT><BR><FONT size=3 face="Times New Roman"> </FONT>
<DIV align=center>
<P>
<HR>
</DIV><BR><FONT color=#808080 size=1 face=Arial><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.</FONT> <BR><FONT color=#c0c0c0 size=1 face=Verdana> </FONT> <BR><FONT color=#2f2f2f size=1 face=Arial>IMPORTANT NOTICE: This email is intended solely for the use of the individual to whom it is addressed and may contain information that is privileged, confidential or otherwise exempt from disclosure under applicable law. If the reader of this email is not the intended recipient or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify us by telephone at (978) 482-2500 and return the original message to us at the listed email address. In accordance with Kewill policy, emails sent and received may be monitored. Kewill accepts no responsibility for any loss or damage should this email contain any virus, or similar destructive or mischievous code. Thank You. Copyright © 2009 by Kewill Inc.</FONT><FONT size=1 face=Arial> </FONT>
<P><FONT size=2 face=Verdana><BR></FONT>
<HR>
<FONT size=2 face=Verdana>Don’t miss a beat </FONT><A href="http://go.microsoft.com/?linkid=9712961"><FONT color=blue size=2 face=Verdana><U>Get Messenger on your phone</U></FONT></A><TT><FONT size=2>-- <BR>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<BR>Mailing list: powerh-l@lists.sowder.com<BR>Subscribe: 'subscribe' in message body to powerh-l-request@lists.sowder.com<BR>Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to powerh-l-request@lists.sowder.com<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>This list is closed, thus to post to the list you must be a subscriber.<BR>Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.</FONT></TT>
<P><BR> <br /><hr />IM on the go with Messenger on your phone. <a href='http://go.microsoft.com/?linkid=9712960' target='_new'>Try now.</a></body>
</html>