<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div>I would suggest that they get the migration done using RDB/VMS and look at switching later. It’s usually easier to do one migration or change at a time.</div><div><br></div><div>As I recall, the big concern with switching was performance. Both types of access make the database do much of the work. The RDB/VMS option uses the native RDB API whereas the RDB option goes through the middle API layer and then to the SQL interface.</div><div><br></div>As for dates, just off the top of my head because I have no way to test, are they using DEFAULT DATE IS NULL? That will tell PowerHouse to store 0 dates as NULL and convert from NULL to 0 when the record is read. I can’t remember whether that will allow CHOOSE to be used as <div><br></div><div>CHOOSE date_item 0<br><div><br></div><div>Alternatively, have they tried putting the NULL in an expression in the CHOOSE as in<div><br></div><div>CHOOSE date_item (NULL)</div><div><br></div><div>If they switch to RDB, they can make use of SQL directly in the DECLARE CURSOR statement and specify </div><div><br></div><div>WHERE date_item IS NULL</div><div><br></div><div>or whatever the equivalent SQL syntax is. Of course that may mean more changes than they want to go through.</div><div><br></div><div>Bob </div><div><br></div><div><div><div>On Mar 21, 2014, at 6:18 PM, Christina Hasse <<a href="mailto:christina.hasse@us.ibm.com">christina.hasse@us.ibm.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><font size="2" face="sans-serif">Hi,</font>
<br>
<br><font size="2" face="sans-serif">I have a customer who is migrating from
PH 7 to 8.40 on OpenVMS. They are looking to change the TYPE from
RDB/VMS to RDB to take advantage of moving the work to the database. I
am looking for lessons learned and the approach taken with dates. They
currently use date = 0 for CHOOSE statements and a CHOOSE statement will
not allow date is null or = null. They are trying to minimize the
work involved at the PH level.</font>
<br>
<br><font size="2" face="sans-serif">Any advise would be greatly appreciated!</font>
<br>
<br><font size="2" face="sans-serif">Thanks!,</font>
<br>
<table width="591" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="587" bgcolor="white" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;"><font size="1"><br>
</font>
<table width="585" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="581" colspan="8" bgcolor="white" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;">
<hr>
</td></tr><tr valign="top" height="8">
<td width="93" rowspan="2" bgcolor="white" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;"><span><Mail Attachment.gif></span>
</td><td width="275" colspan="4" rowspan="2" bgcolor="white" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;"><font size="1" face="Arial"><b>Christina
Hasse</b><br>
Channel Technical Sales Specialist <br>
Business Analytics <br>
<br>
Tel: 847-269-1909<br>
E-mail: <a href="mailto:christina.hasse@us.ibm.com">christina.hasse@us.ibm.com</a> </font>
</td><td width="10" bgcolor="white" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;"><font size="1" face="Arial"> </font>
</td><td width="180" bgcolor="white" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;"><span><Mail Attachment.gif></span>
</td><td width="7" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;">
</td></tr><tr valign="top" height="8">
<td width="194" colspan="2" bgcolor="white" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;"><span><Mail Attachment.gif></span>
</td><td width="7" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;">
</td></tr><tr valign="top" height="8">
<td width="93" bgcolor="white" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;">
</td><td width="25" bgcolor="white" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;"><a href="http://www.linkedin.com/groups/IBM-Information-On-Demand-4407347?gid=4407347&mostPopular=&trk=tyah" target="_blank"><span><Mail Attachment.gif></span></a>
</td><td width="25" bgcolor="white" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;"><a href="http://www.facebook.com/InformationOnDemand" target="_blank"><span><Mail Attachment.gif></span></a>
</td><td width="25" bgcolor="white" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;"><a href="https://twitter.com/#!/ibm_iod" target="_blank"><span><Mail Attachment.gif></span></a>
</td><td width="187" bgcolor="white" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;">
</td><td width="10" bgcolor="white" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;">
</td><td width="180" bgcolor="white" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;">
</td><td width="7" bgcolor="white" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;">
</td></tr><tr valign="top" height="8">
<td width="581" colspan="8" bgcolor="white" style="border-style:solid;border-color:#000000;border-width:0px 0px 0px 0px;padding:2px 2px;">
<hr></td></tr></tbody></table>
<br></td></tr></tbody></table>
<br>--<br>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>Mailing list: <a href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</a><br>Subscribe: 'subscribe' in message body to <a 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 href="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</a><br><a href="http://lists.sowder.com/mailman/listinfo/powerh-l">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>Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.</blockquote></div><br></div></div></div></body></html>