<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 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
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;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
tt
{mso-style-priority:99;
font-family:"Courier New";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:878276255;
mso-list-template-ids:706225878;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></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-CA" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Thanks Nicolas,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">This seems to have done the trick. Way to simple!<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>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Comic Sans MS";color:#1F497D">Thanks!<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-family:"Calibri","sans-serif";color:#1F497D">Alan Thurston</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> (Independent Contractor)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Working for the Ministry of Jobs, Tourism and Skills Training, and Responsible for Labour
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">250-882-4623 (cell)<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> nicholas.arniakos@externe.bnpparibas.com [mailto:nicholas.arniakos@externe.bnpparibas.com]
<br>
<b>Sent:</b> Tuesday, January 24, 2017 10:40 PM<br>
<b>To:</b> Thurston, Alan JTST:EX<br>
<b>Cc:</b> powerh-l@lists.sowder.com; powerh-l-bounces+nicholas.arniakos=bnpparibas.com@lists.sowder.com<br>
<b>Subject:</b> Re: Powerhouse screen failing to set value on detail record<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p style="margin-bottom:12.0pt"><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Good morning</span><br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Try to change the sequence of the PUT commands in update procedure in the loop. First
</span><tt><span style="font-size:10.0pt">HEARING_DATE</span></tt><span style="font-size:10.0pt;font-family:"Arial","sans-serif""> then
</span><tt><span style="font-size:10.0pt">MEETING</span></tt><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">.</span><br>
<br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Regards, Nicholas</span><br>
<br>
<br>
<img width="16" height="16" id="_x0000_i1025" src="cid:image001.gif@01D276EE.3DDC56B0" alt="Inactive hide details for Alan.Thurston---24/01/2017 20:45:36---A high level view of the business is that a CASE may have a HEA"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#424282">Alan.Thurston---24/01/2017
20:45:36---A high level view of the business is that a CASE may have a HEARING. The hearing may happen over sev</span><o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="1%" style="width:1.0%;padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><img width="80" height="1" id="_x0000_i1026" src="cid:image002.png@01D276EE.3DDC56B0"><br>
<img width="80" height="1" id="_x0000_i1027" src="cid:4__=4EBB0A20DFB71DE18f9e8a93d@bnpparibas.com"><o:p></o:p></p>
</td>
<td width="100%" style="width:100.0%;padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><img width="1" height="1" id="_x0000_i1028" src="cid:image003.png@01D276EE.3DDC56B0"><o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif"">Powerhouse screen failing to set value on detail record</span></b><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal" style="margin-left:36.0pt"><span style="display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;margin-left:36.0pt" id="tmpdisplaysendto">
<tbody>
<tr>
<td width="35%" style="width:35.0%;padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><img width="1" height="1" id="_x0000_i1029" src="cid:image003.png@01D276EE.3DDC56B0"><br>
<b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#E26200">(Internet)</span></b><br>
<b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#E26200">Alan.Thurston
</span></b><o:p></o:p></p>
</td>
<td width="1%" style="width:1.0%;padding:0cm 0cm 0cm 0cm" id="dst1">
<p class="MsoNormal"><img width="12" height="1" id="_x0000_i1030" src="cid:image004.png@01D276EE.3DDC56B0"><o:p></o:p></p>
</td>
<td width="65%" valign="top" style="width:65.0%;padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><img width="1" height="1" id="_x0000_i1031" src="cid:image003.png@01D276EE.3DDC56B0"><o:p></o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%">
<tbody>
<tr>
<td width="1%" valign="top" style="width:1.0%;padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><img width="91" height="1" id="_x0000_i1032" src="cid:image005.png@01D276EE.3DDC56B0"><br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#929292">To:</span><o:p></o:p></p>
</td>
<td width="100%" valign="top" style="width:100.0%;padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><img width="1" height="1" id="_x0000_i1033" src="cid:image003.png@01D276EE.3DDC56B0"><br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif"">powerh-l</span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
<td width="0%" style="width:0%;padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><img width="1" height="1" id="_x0000_i1034" src="cid:image003.png@01D276EE.3DDC56B0"><o:p></o:p></p>
<p class="MsoNormal" align="right" style="text-align:right"><span style="font-size:7.5pt;font-family:"Arial","sans-serif"">24/01/2017 20:45</span><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%" id="detailsTbl">
<tbody>
<tr>
<td width="100%" style="width:100.0%;padding:0cm 0cm 0cm 0cm">
<p class="MsoNormal"><img width="1" height="1" id="_x0000_i1035" src="cid:image003.png@01D276EE.3DDC56B0"><br>
<span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#929292">Sent by :
</span><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#E26200"><a href="mailto:powerh-l-bounces+nicholas.arniakos=bnpparibas.com@lists.sowder.com">powerh-l-bounces+nicholas.arniakos=bnpparibas.com@lists.sowder.com</a></span></b><o:p></o:p></p>
</td>
<td width="1%" style="width:1.0%;padding:0cm 0cm 0cm 0cm" id="dt1">
<p class="MsoNormal"><img border="0" width="141" height="1" id="_x0000_i1036" src="cid:image006.png@01D276EE.3DDC56B0"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<p><o:p> </o:p></p>
<div class="MsoNormal">
<hr size="2" width="100%" noshade="" style="color:#B4BFCB" align="left">
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><br>
<br>
<br>
<tt><span style="font-size:10.0pt">A high level view of the business is that a CASE may have a HEARING. The hearing may happen over several days (HEARING_DATE) and on each of those dates there will be a MEETING.</span></tt><span style="font-size:10.0pt;font-family:"Courier New""><br>
<tt>The MEETING record has an attribute HRG_ID which stores the HRG_ID of the HEARING_DATE.</tt><br>
<tt>HRG_ID of the HEARING_DATE is the primary key and always has a correct value.</tt><br>
<tt>HRG_ID of the MEETING is meant to store the same value as HRG_ID of the HEARING_DATE.</tt><br>
<br>
<tt>I have a screen that includes the following files. This is the original source for the screen. The "item HRG_ID of MEETING" line under the file MEETING statement is the only place that HRG_ID of MEETING is given a value. Prior to migrating to Itanium this
worked as expected.</tt><br>
<br>
<tt>file CASE_HEARING in LRBDB primary</tt><br>
<tt>access via CASE_ID using T_CASE_ID2</tt><br>
<tt>access via CASE_ID using CASE_ID request CASE_ID</tt><br>
<tt>access via CASE_ID, HRG_ID using T_CASE_ID, T_HRG_ID</tt><br>
<tt>item UPD_BY of CASE_HEARING final &</tt><br>
<tt> upshift(getsystemval("LRB_USER",logical,"LNM$JOB")) &</tt><br>
<tt> if alteredrecord of CASE_HEARING</tt><br>
<tt>item UPD_DTE of CASE_HEARING final sysdate if alteredrecord of CASE_HEARING</tt><br>
<br>
<br>
<tt>file HEARING_DATE in LRBDB detail occurs 9</tt><br>
<tt>access via HRG_ID using HRG_ID of CASE_HEARING &</tt><br>
<tt> orderby HRG_ACTUAL_DTE descending</tt><br>
<tt>select if &</tt><br>
<tt> (HRG_ACTUAL_DTE of HEARING_DATE >= CONSOLIDATION_DTE of CASE_HEARING &</tt><br>
<tt>and HRG_ACTUAL_DTE of HEARING_DATE <= WITHDRAWAL_DTE of CASE_HEARING) or &</tt><br>
<tt> (HRG_ACTUAL_DTE of HEARING_DATE >= CONSOLIDATION_DTE of CASE_HEARING &</tt><br>
<tt>and WITHDRAWAL_DTE of CASE_HEARING = 0) or &</tt><br>
<tt> CONSOLIDATION_DTE of CASE_HEARING = 0</tt><br>
<tt>item HRG_ID of HEARING_DATE final HRG_ID of CASE_HEARING</tt><br>
<tt>item UPD_BY of HEARING_DATE final &</tt><br>
<tt> upshift(getsystemval("LRB_USER",logical,"LNM$JOB")) &</tt><br>
<tt> if alteredrecord of HEARING_DATE</tt><br>
<tt>item UPD_DTE of HEARING_DATE final sysdate if alteredrecord of HEARING_DATE</tt><br>
<br>
<br>
<tt>file MEETING in LRBDB secondary occurs with HEARING_DATE</tt><br>
<tt>access via HRG_ID using HRG_ID of HEARING_DATE</tt><br>
<tt>item HRG_ID of MEETING final HRG_ID of HEARING_DATE <-------------- not working</tt><br>
<tt>item MTG_DTE of MEETING final HRG_ACTUAL_DTE of HEARING_DATE</tt><br>
<tt>item MTG_NAME of MEETING final HRG_NAME of HEARING</tt><br>
<tt>item MTG_START_TIME of MEETING final HRG_START_TIME of HEARING_DATE</tt><br>
<tt>item UPD_BY of MEETING final &</tt><br>
<tt> upshift(getsystemval("LRB_USER",logical,"LNM$JOB")) &</tt><br>
<tt> if alteredrecord of MEETING</tt><br>
<tt>item UPD_DTE of MEETING final sysdate if alteredrecord of MEETING</tt><br>
<tt>select if MTG_DTE of MEETING = HRG_ACTUAL_DTE of HEARING_DATE and &</tt><br>
<tt> MTG_START_TIME of MEETING = HRG_START_TIME of HEARING_DATE</tt><br>
<br>
<br>
<tt>After the move to Itanium this is no longer working consistently, sometimes does, more often does not, even with the same data entry sequence</tt><br>
<br>
<tt>I've tried a number of statements like "let HRG_ID of MEETING = HRG_ID of HEARING_DATE" at various points.</tt><br>
<tt>I went so far as to hard code the update procedure:</tt><br>
<br>
<tt>procedure update</tt><br>
<tt>begin</tt><br>
<tt> put HEARING</tt><br>
<tt> put CASE_HEARING</tt><br>
<tt> for HEARING_DATE</tt><br>
<tt> begin</tt><br>
<tt> let HRG_ID of MEETING = HRG_ID of HEARING</tt><br>
<tt> info = "Before PUT: HRG_ID of MEETING = " + ascii(HRG_ID of MEETING) now resp</tt><br>
<tt> put MEETING</tt><br>
<tt> put HEARING_DATE</tt><br>
<tt> info = "After PUT: HRG_ID of MEETING = " + ascii(HRG_ID of MEETING) now resp</tt><br>
<tt> end</tt><br>
<tt>end</tt><br>
<br>
<tt>The first info shows the expected correct HRG_ID. After the "put MEETING" the info statements shows a HRG_ID of 0 which is what gets stored in the database.</tt><br>
<tt>There are no database triggers than impact HRG_ID of MEETING</tt><br>
<br>
<tt>Any ideas as to how I could fix this?</tt><br>
<br>
<br>
<tt>Thanks!</tt><br>
<br>
<tt>Alan Thurston (Independent Contractor)</tt><br>
<tt>Working for the Ministry of Jobs, Tourism and Skills Training, and Responsible for Labour
</tt><br>
<tt>250-882-4623 (cell)</tt><br>
<br>
<tt>--</tt><br>
<tt>= = = = = = = = = = = = = = = = = = = = = = = = = = = =</tt><br>
<tt>Mailing list: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a></tt><br>
<tt>Subscribe: 'subscribe' in message body to <a href="mailto:powerh-l-request@lists.sowder.com">
powerh-l-request@lists.sowder.com</a></tt><br>
<tt>Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to <a href="mailto:powerh-l-request@lists.sowder.com">
powerh-l-request@lists.sowder.com</a></tt><br>
<tt><a href="http://lists.sowder.com/mailman/listinfo/powerh-l">http://lists.sowder.com/mailman/listinfo/powerh-l</a></tt><br>
<tt>This list is closed, thus to post to the list you must be a subscriber.</tt><br>
<tt>Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.</tt></span><o:p></o:p></p>
<p>This message and any attachments (the "message") is<br>
intended solely for the intended addressees and is confidential. <br>
If you receive this message in error,or are not the intended recipient(s), <br>
please delete it and any copies from your systems and immediately notify<br>
the sender. Any unauthorized view, use that does not comply with its purpose, <br>
dissemination or disclosure, either whole or partial, is prohibited. Since the internet
<br>
cannot guarantee the integrity of this message which may not be reliable, BNP PARIBAS
<br>
(and its subsidiaries) shall not be liable for the message if modified, changed or falsified.
<br>
Do not print this message unless it is necessary,consider the environment.<o:p></o:p></p>
<p>----------------------------------------------------------------------------------------------------------------------------------<o:p></o:p></p>
<p>Ce message et toutes les pieces jointes (ci-apres le "message") <br>
sont etablis a l'intention exclusive de ses destinataires et sont confidentiels.<br>
Si vous recevez ce message par erreur ou s'il ne vous est pas destine,<br>
merci de le detruire ainsi que toute copie de votre systeme et d'en avertir<br>
immediatement l'expediteur. Toute lecture non autorisee, toute utilisation de <br>
ce message qui n'est pas conforme a sa destination, toute diffusion ou toute <br>
publication, totale ou partielle, est interdite. L'Internet ne permettant pas d'assurer<br>
l'integrite de ce message electronique susceptible d'alteration, BNP Paribas <br>
(et ses filiales) decline(nt) toute responsabilite au titre de ce message dans l'hypothese<br>
ou il aurait ete modifie, deforme ou falsifie. <br>
N'imprimez ce message que si necessaire, pensez a l'environnement.<o:p></o:p></p>
</div>
</body>
</html>