PowerHouse 7.10 to 8.40 Migration

[Robert Deskin]

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.

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.

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 

CHOOSE date_item 0

Alternatively, have they tried putting the NULL in an expression in the CHOOSE as in

CHOOSE date_item (NULL)

If they switch to RDB, they can make use of SQL directly in the DECLARE CURSOR statement and specify 

WHERE date_item IS NULL

or whatever the equivalent SQL syntax is. Of course that may mean more changes than they want to go through.

Bob 

On Mar 21, 2014, at 6:18 PM, Christina Hasse <christina.hasse at us.ibm.com> wrote:

> Hi, 
> 
> 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. 
> 
> Any advise would be greatly appreciated! 
> 
> Thanks!, 
> 
> <Mail Attachment.gif> 	Christina Hasse
> Channel Technical Sales Specialist 
> Business Analytics 
> 
> Tel: 847-269-1909
> E-mail: christina.hasse at us.ibm.com	 	<Mail Attachment.gif> 	
> <Mail Attachment.gif> 	
> <Mail Attachment.gif> 	<Mail Attachment.gif> 	<Mail Attachment.gif> 				
> 
> 
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com
> Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com
> Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to powerh-l-request at lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20140321/a96d1705/attachment-0001.htm>