P/H on Unix

Tue, 4 Feb 2003 07:03:14 -0500

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C2CC45.651AA550
Content-Type: text/plain;
	charset="iso-8859-1"

Since you are doing a database conversion anyway, your IMAGE files, records,
and items will not be used. The elements will provide the logical view
(labels, edits, etc.). I recommend that you convert to a numeric type that
is supported. Presumably, you're writing out your IMAGE data as portable
subfiles and using QTP to load the new Sybase database. Unless you force a
character conversion, PowerHouse will quite happily move numeric to numeric
even though the storage type is different.

Unless you're doing a lot of substructuring or manipulation based on the
fact that the items are zoned, you should not have major code changes in
your PowerHouse code. You may not even need to change the dictionary from
the original.

You may have some work up front, but you'll save a lot of grief later.
Bob Deskin              
PowerHouse Web Product Manager, Application Development Tools 
Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA 
bob.deskin@cognos.com (613) 738-1338 ext 7268 

-----Original Message-----
From: Patrick Wright [mailto:pwright@mhg.co.za]
Sent: February 4, 2003 2:07 AM
To: 'powerh-l@lists.swau.edu'
Cc: Derick Snyders; Mark Toms
Subject: P/H on Unix

<http://196.22.0.16/RocketSeed/mail/433a313a31303438393a39313a2d323a30>
Metropolitan Health Group - always innovating.
... for more info visit our website: http://www.mhg.co.za

I am in the process of converting an HP3000 P/H, Turboimage system to HP-UX
with Sybase.

One of the main migration issues is that many elements and items in the
HP3000 dict are defined as Zoned. No such data type exists on Sybase.
Consequently the Sybase PDL defines the old Zoned fields as character. 
As the Sybase dictionary is used to as a subdict to P/H, P/H now sees these
fields as character and numerous code changes need to be made in order to
cater for these now c\character fields.

The questions is: is it possible in any way to use the P/H dictionary to
overwrite the SQL (Sybase) element definitions ?

Regards

Patrick Wright

Head: Newmed Systems
Metropolitan Health Group
Tel: (021) 480 478 6
Fax: (021) 480 4932
Mobil: 082 652 7474
eMail: pwright@mhg.co.za
www.mhg.co.za

**********************************************************************
------
NOTICE
------
This message contains privileged and confidential information intended 
only for the person or entity to which it is addressed. 

Any review, retransmission, dissemination, copy or other use of, or 
taking of any action in reliance upon this information by persons or 
entities other than the intended recipient, is prohibited.

If you received this message in error, please notify the sender
immediately by e-mail, facsimile or telephone and thereafter delete the
material from any computer.

Metropolitan Health Group, its subsidiaries or associates 
do not accept liability for any personal views expressed in 
this message.

**********************************************************************

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.

------_=_NextPart_001_01C2CC45.651AA550
Content-Type: text/html;
	charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.50.4807.2300" name=GENERATOR></HEAD>
<BODY>
<DIV>Since 
you are doing a database conversion anyway, your IMAGE files, records, and items 
will not be used. The elements will provide the logical view (labels, edits, 
etc.). I recommend that you convert to a numeric type that is supported. 
Presumably, you're writing out your IMAGE data as portable subfiles and using 
QTP to load the new Sybase database. Unless you force a character conversion, 
PowerHouse will quite happily move numeric to numeric even though the storage 
type is different.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Unless 
you're doing a lot of substructuring or manipulation based on the fact that the 
items are zoned, you should not have major code changes in your PowerHouse code. 
You may not even need to change the dictionary from the 
original.</DIV>
<DIV>&nbsp;</DIV>
<DIV>You 
may have some work up front, but you'll save a lot of grief 
later.</DIV>
<DIV>
Bob 
Deskin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 PowerHouse Web Product Manager, Application Development 
Tools Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 
CANADA bob.deskin@cognos.com (613) 738-1338 ext 
7268 </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
 <DIV class=OutlookMessageHeader dir=ltr align=left>-----Original Message----- From: Patrick Wright 
 [mailto:pwright@mhg.co.za] Sent: February 4, 2003 2:07 
 AM To: 'powerh-l@lists.swau.edu' Cc: Derick Snyders; Mark 
 Toms Subject: P/H on Unix </DIV><A 
 href="http://196.22.0.16/RocketSeed/mail/433a313a31303438393a39313a2d323a30"><IMG 
 alt="Metropolitan Health Group - always innovating.&#13;&#10;... for more info visit our website: http://www.mhg.co.za" 
 src="http://196.22.0.16/RocketSeed/mail/563a313a31303438393a39313a2d323a30.gif" 
 border=0 NOSEND="1"> </A>
 I am in the process of converting an HP3000 P/H, Turboimage system to 
 HP-UX with Sybase. One of the main migration issues is that many 
 elements and items in the HP3000 dict are defined as Zoned. No such data 
 type exists on Sybase. Consequently the Sybase PDL defines the old Zoned 
 fields as character. As the Sybase dictionary is used to as a subdict to 
 P/H, P/H now sees these fields as character and numerous code changes need 
 to be made in order to cater for these now c\character fields. The 
 questions is: is it possible in any way to use the P/H dictionary 
 to overwrite the SQL (Sybase) element definitions 
 ? Regards Patrick Wright Head: Newmed 
 Systems Metropolitan Health Group Tel: (021) 480 478 6 Fax: (021) 480 
 4932 Mobil: 082 652 7474 eMail: 
 pwright@mhg.co.za www.mhg.co.za ********************************************************************** ------ NOTICE ------ This 
 message contains privileged and confidential information intended only for 
 the person or entity to which it is addressed. Any review, 
 retransmission, dissemination, copy or other use of, or taking of any 
 action in reliance upon this information by persons or entities other than 
 the intended recipient, is prohibited. If you received this message in 
 error, please notify the sender immediately by e-mail, facsimile or 
 telephone and thereafter delete the material from any 
 computer. Metropolitan Health Group, its subsidiaries or associates 
 do not accept liability for any personal views expressed in this 
 message. ********************************************************************** 
 
 </BLOCKQUOTE></BODY></HTML>

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.

------_=_NextPart_001_01C2CC45.651AA550--