<div>Dear Joe,</div>
<div> </div>
<div>Your are correct.</div>
<div>Both the GET statement and the WHILE RETRIEVING statements seems to fetch data.</div>
<div>Butwhen I try to update, the Axiant is giving me the runtime error 'There is no data'.</div>
<div>Can you help me out of this issue?</div>
<div> </div>
<div>Regards,</div>
<div>SYED.<br><br> </div>
<div><span class="gmail_quote">On 12/1/05, <b class="gmail_sendername">Hasse, Christina</b> <<a href="mailto:Christina.Hasse@cognos.com">Christina.Hasse@cognos.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div dir="ltr" align="left"><font face="Arial" color="#0000ff" size="2"><span>Just a quick comment. The viaindex will not work with a relational database, because we cannot control the decision made by the database when retrieving the data. Hence, the need for the specific retrieval method of the orderby.
</span></font></div>
<div dir="ltr" align="left"><font face="Arial" color="#0000ff" size="2"><span><i><font face="Arial" size="2"></font></i></span></font> </div>
<div dir="ltr" align="left"><font face="Arial" color="#0000ff" size="2"><span><i><font face="Arial" size="2">Regards,</font></i> </span></font></div>
<div dir="ltr" align="left">
<div align="left">
<div align="left">
<p><i><font face="Arial" size="2">Christina Hasse</font></i> <br><i><font face="Arial" size="2">ADT N.A. Technical Manager</font></i> <br><i><font face="Arial" size="2">COGNOS CORPORATION</font></i> <br><i><font face="Arial" size="2">
20 North Martingale Road, Suite 150</font></i> <br><i><font face="Arial" size="2">Schaumburg, IL 60173</font></i> <br><i><font face="Arial" color="#0000ff" size="2"><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:christina.hasse@cognos.com" target="_blank">
christina.hasse@cognos.com</a></font></i> </p>
<p><i><font face="Arial" size="2">Office: 847 - 285 - 2905</font></i> <br><i><font face="Arial" size="2">Cell: 847 - 269 - 1909</font></i> <br><i><font face="Arial" size="2">Fax: 781 - 345 - 3544</font></i></p>
<p><i><font face="Arial" color="#0000ff" size="2"><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://powerhouse.cognos.com/" target="_blank">http://powerhouse.cognos.com</a></font></i> </p></div></div>
</div><br>
<div lang="en-us" dir="ltr" align="left">
<hr>
<font face="Tahoma" size="2"><b>From:</b> powerh-l-bounces+christina.hasse=<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:cognos.com@lists.sowder.com" target="_blank">cognos.com@lists.sowder.com</a>
[mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-bounces+christina.hasse=cognos.com@lists.sowder.com" target="_blank">powerh-l-bounces+christina.hasse=cognos.com@lists.sowder.com</a>
] <b>On Behalf Of </b>Joe Boyle<br><b>Sent:</b> Wednesday, November 30, 2005 10:58 AM<span class="q"><br><b>To:</b> Syed Shahul Hameed Mustaffa; Joe Boyle<br><b>Cc:</b> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l@lists.sowder.com" target="_blank">
powerh-l@lists.sowder.com</a><br></span>
<div><span class="e" id="q_107e2fdd8983d7c6_2"><b>Subject:</b> Re: GET VIAINDEX question<br></span></div></font><br> </div>
<div><span class="e" id="q_107e2fdd8983d7c6_4">
<div></div>
<div><font face="Arial" size="2">I was just about to apologise for my naive suggestion made earlier, and about to suggest you use a cursor with something like the code below,</font></div>
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2">1. change the file to a cursor</font></div>
<div><font face="Arial" size="2">2. add SQL clause like 'where ( via_item < : request_item )'</font></div>
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2">and then you tell me that the suggestion helped.</font></div>
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2">I am truly astonished :))</font></div>
<blockquote style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<div style="FONT: 10pt arial">----- Original Message ----- </div>
<div style="BACKGROUND: #e4e4e4; FONT: 10pt arial"><b>From:</b> <a title="sshahulgm@gmail.com" onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:sshahulgm@gmail.com" target="_blank">Syed Shahul Hameed Mustaffa
</a> </div>
<div style="FONT: 10pt arial"><b>To:</b> <a title="atla38@dsl.pipex.com" onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:atla38@dsl.pipex.com" target="_blank">Joe Boyle</a> </div>
<div style="FONT: 10pt arial"><b>Cc:</b> <a title="powerh-l@lists.sowder.com" onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a> </div>
<div style="FONT: 10pt arial"><b>Sent:</b> Wednesday, November 30, 2005 3:00 PM</div>
<div style="FONT: 10pt arial"><b>Subject:</b> Re: GET VIAINDEX question</div>
<div><br> </div>
<div>Dear Joe,</div>
<div> </div>
<div>I'm just now back from my vacation. </div>
<div> </div>
<div>Thank you so much for your help.</div>
<div>It resolved my issue.</div>
<div> </div>
<div>Best Regards,</div>
<div>SYED</div>
<div> </div>
<div><br><br> </div>
<div><span class="gmail_quote">On 11/30/05, <b class="gmail_sendername">Joe Boyle</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:atla38@dsl.pipex.com" target="_blank">atla38@dsl.pipex.com</a>
> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></span></font> </p>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">or if processing many rows,</span></font></p>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"></span></font> </p>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">While ret GET BREED_SUMM_D viaindex BSD_BK using TCOMPUTER orderby srt_item Descending</span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></span></font> </p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></span></font> </p>
<div>
<div style="TEXT-ALIGN: center" align="center"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">
<hr align="center" width="100%" size="3">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</span></font></b><font face="Tahoma" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> Joe Boyle [mailto:
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:atla38@dsl.pipex.com" target="_blank">atla38@dsl.pipex.com</a>] <br><b><span style="FONT-WEIGHT: bold">Sent:</span></b> 30 November 2005 12:59<br><b><span style="FONT-WEIGHT: bold">
To:</span></b> 'Syed Shahul Hameed Mustaffa'; '<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:'powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a>'<br><b><span style="FONT-WEIGHT: bold">
Subject:</span></b> RE: GET VIAINDEX question</span></font></p></div>
<div><span>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"></span></font> </p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">How about trying something like, </span></font></p>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></span></font> </p>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">GET BREED_SUMM_D viaindex BSD_BK using TCOMPUTER orderby srt_item Descending</span></font></p>
<div>
<p><font face="Arial" color="navy" size="2"><span style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Regards, Joe.</span></font><font color="navy"><span style="COLOR: navy"> </span></font></p></div>
<div>
<div style="TEXT-ALIGN: center" align="center"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">
<hr align="center" width="100%" size="3">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</span></font></b><font face="Tahoma" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> Syed Shahul Hameed Mustaffa [mailto:
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:sshahulgm@gmail.com" target="_blank">sshahulgm@gmail.com</a>] <br><b><span style="FONT-WEIGHT: bold">Sent:</span></b> 30 November 2005 12:41<br><b><span style="FONT-WEIGHT: bold">
To:</span></b> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a><br><b><span style="FONT-WEIGHT: bold">Subject:</span></b> GET VIAINDEX question
</span></font></p></div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"></span></font> </p>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Dear Gurus,</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"></span></font> </p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Quick Intro: I have migrated an PH/MPEIX application to AXIANT4GL/PH/WINDOWS (THINCLIENT).</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"></span></font> </p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">I have a problem with the following GET statement</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"></span></font> </p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">GET BREED_SUMM_D viaindex BSD_BK using TCOMPUTER</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">The GET command doesn't use the index.</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"></span></font> </p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">As the backwards command doesn't work with relational databases, I created an index call BSD_BK in the order i wanted.</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"></span></font> </p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">I'll appreciate any effort to resolve this problem.</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"></span></font> </p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Thank you somuch in advance.</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"></span></font> </p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Regards,</span></font></p></div>
<div>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">SYED.</span></font></p></div></span></div></div></blockquote></div><br>
<p>
<hr>
<p></p>-- <br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com
</a><br>Subscribe: "subscribe" in message body to <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com" target="_blank">powerh-l-request@lists.sowder.com</a><br>
Unsubscribe: "unsubscribe &lt;password&gt;" in message body to <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com" target="_blank">powerh-l-request@lists.sowder.com
</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>This list is closed, thus to post to the list you must be a subscriber.
<br>
<p></p></p></blockquote></span></div></div>
<div> </div>
<div> <font face="Arial" size="2">This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.
</font> </div>
<div>
<p><font face="Arial" size="2"> </font></p></div><br>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l@lists.sowder.com">
powerh-l@lists.sowder.com</a><br>Subscribe: "subscribe" in message body to <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com
</a><br>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com
</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>This list is closed, thus to post to the list you must be a subscriber.
<br><br>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>Subscribe: "subscribe" in message body to
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank">
http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>This list is closed, thus to post to the list you must be a subscriber.<br><br><br></blockquote></div><br>