<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="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 11 (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:"Lucida Console";
panose-1:2 11 6 9 4 5 4 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";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
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><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>We are running a little script to delete some records
in an Oracle table “REC” as follows:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'>Q T P
(PowerHouse 8.43.D1)</span></font><span lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'>Copyright 2005 COGNOS
INCORPORATED</span></font><span lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'>Licensed PH8-UNIX-RUNTIME
for customer</span></font><span lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'> </span></font><span
lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'>> access REC</span></font><span
lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'>> select if REC_CREATE_DATE
<= 20080715</span></font><span lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'>> subfile SAVE_REC
keep include REC</span></font><span lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'>> output REC delete</span></font><span
lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'>> go</span></font><span
lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'> </span></font><span
lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'>Executing request 1 ...</span></font><span
lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'> </span></font><span
lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'>Records read:</span></font><span
lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'> REC
3,473</span></font><span lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'> </span></font><span
lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'>Transactions
processed:
340</span></font><span lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'> </span></font><span
lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'>Records
processed:
Added Updated Unchanged Deleted</span></font><span
lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'> REC
0
0
0 61</span></font><span
lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'> SAVE_REC
340
0
0 0</span></font><span
lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'> </span></font><span
lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'>Finished.</span></font><span
lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face="Lucida Console"><span lang=EN-CA
style='font-size:10.0pt;font-family:"Lucida Console"'>> </span></font><span
lang=EN-CA><o:p></o:p></span></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>This is version 8.43.D1 running on HP-UX using an
Oracle 10.2 database. REC_CREATE_DATE is a date (with century included) field. There
is a delete trigger on REC but it is only used to generate some data in another
Oracle table. When we tried to delete just the remaining 279 records using the
same code, it still would not delete the records, yet it selected them for the subfile.
Has anyone seen this sort of thing happen before or have any thoughts as to why
it cannot delete some of the records (without reporting an error)?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="100%"
style='width:100.0%'>
<tr>
<td style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-CA style='font-size:
10.0pt;font-family:Arial'>Dirk Rohde<br>
VantagePoint Systems, Inc.<br>
T: 604-685-4209 x 239 <br>
F: 604-685-4186<br>
</span></font><span lang=EN-CA> <o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-CA
style='font-size:12.0pt'><a href="http://www.vpgroup.com" target="_blank"><span
style='text-decoration:none'><img border=0 width=672 height=105
id="_x0000_i1025" src="cid:image001.gif@01C8FDFC.73F23C20"></span></a><o:p></o:p></span></font></p>
</td>
</tr>
</table>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-CA
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
</div>
<br>This email may contain information that is privileged, confidential, or otherwise exempt from disclosure under applicable laws. Unauthorized use, reproduction or dissemination of this email is strictly prohibited. If you have received this e-mail in error please inform the sender and delete it from your mailbox or any other storage mechanism. VantagePoint Systems, Inc. cannot accept liability for any statements made which are clearly the sender's own and not expressly made on behalf of VantagePoint Systems, Inc. or one of its agents.</body>
</html>