PH 7.10G on VMS 7.1.2 and Oracle

[Rob Kool]

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_000_01C1099B.7BC9810E
Content-Type: text/plain;
	charset="iso-8859-1"

Hi Mike,

I am currently involved in porting a number of PowerHouse applications from
Interbase 3.3 to Oracle 8i and there are some issues that I have
encountered. I guess that you will have to deal with similar issues when
porting from Oracle/RDB

For starters, you certainly have to change the dictionary. You have to
specify a different database type. Also the connection string for Oracle
will probably differ from the one for RDB (I am not a 100% sure on the
connection string, it's been a while when I last had to deal with RDB).

You will have to recompile all programs as there are no doubts differences
in the data types between RDB and Oracle. Even if the types are similar, the
way they are stored or handled may differ.

Then there is the issue of converting data types. One of the things I did,
was to convert a number of larger character fields to Oracles Varchar2. This
caused some problems when I tried to link to these fields using normal CHAR
temporary items. But that was easy to fix. Change the Temporary to Varchar
as well or truncate the item before linking.

A more annoying problem is the fact that Oracle treats an empty string "" as
NULL and as such it loses all string properties. If you for instance use it
in a function, the result will be NULL no matter what. Any linkage that uses
such a field will fail as well because NULL=NULL is FALSE!

Another problem I found was were a date field was not declared as an element
in the dictionary. When the screen was compiled, the field on the screen was
using the standard Oracle format for dates (including time). This messed up
some screen layouts. But that was fixed by putting the element in the
dictionary.

If you have any other applications using the same database, be aware that
PowerHouse stores blank dates as a 0 in Oracle. Oracle normally does not
allow this. I have seen an ODBC driver that crashed when it encountered such
a date. The Oracle client software handles this problem better.

I found a few other issues but most of them were reasonably easy to fix.

But you have to test you whole system!

Hope this helps a bit.

Rob Kool
Consultant
CDP Ltd.

-----Original Message-----
From: Lamers Mike [mailto:Mike.Lamers@phs.com]
Sent: Wednesday, 11 July 2001 06:37
To: 'Powerhouse List'
Subject: PH 7.10G on VMS 7.1.2 and Oracle


Hello ...
We currently run PH 7.10G on VMS 7.1.2 with an Oracle/RDB database
(V7.0-16).
We are considering converting the database from Oracle/RDB to "true" Oracle
7.3.3.6 (or higher).

Does anyone know if we would have to do anything special with any of our
Powerhouse code?  Would the dictionary be affected?  Would we need to
recompile all Quick screens?  Any other issues to consider?

Thanks

Mike Lamers
PacifiCare of Colorado 
Health Care Economics (CO82-214)
(719) 522 - 6758
mike.lamers@phs.com




This electronic message transmission, including any attachments, contains
information from PacifiCare Health Systems Inc. which may be confidential or
privileged. The information is intended to be for the use of the individual
or entity named above. If you are not the intended recipient, be aware that
any disclosure, copying, distribution or use of the contents of this
information is prohibited.  

If you have received this electronic transmission in error, please notify
the sender immediately by a "reply to sender only" message and destroy all
electronic and hard copies of the communication, including attachments.



= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.

------_=_NextPart_000_01C1099B.7BC9810E
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+Ig8XAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAA0QcHAAsACwA1AAkAAwA2AQEggAMADgAAANEHBwAL
AAsANQAOAAMAOwEBCYABACEAAABFOTc4RDM2OUUwNzNENTExQjEyMDAwMTA1QTZGQUU1NwAHBwEE
gAEAJQAAAFJFOiBQSCA3LjEwRyBvbiBWTVMgNy4xLjIgYW5kIE9yYWNsZQCoCQENgAQAAgAAAAIA
AgABA5AGADwQAAA0AAAAAwAJWQEAAAACATEAAQAAAB8BAABQQ0RGRUIwOQABAAIAaQAAAAAAAAA4
obsQBeUQGqG7CAArKlbCAABFTVNNREIuRExMAAAAAAAAAAAbVfogqmYRzZvIAKoAL8RaDAAAAEFO
SU1VTAAvbz1DRFAvb3U9V2d0bi9jbj1SZWNpcGllbnRzL2NuPUtvb2xSAC4AAAAAAAAAokB7zMND
0xGwwwAQWm+uVwEAJRdmhsAB0xGwowAQWm+uVwAAAARXlAAAAAAAAC4AAAAAAAAAokB7zMND0xGw
wwAQWm+uVwEAJRdmhsAB0xGwowAQWm+uVwAAAARXlQAAEAAAAOl402ngc9URsSAAEFpvrlclAAAA
UkU6IFBIIDcuMTBHIG9uIFZNUyA3LjEuMiBhbmQgT3JhY2xlAAADAN4/5AQAAAMANgAAAAAAAwAF
gAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAACdqAQAeACWACCAGAAAAAADAAAAAAAAARgAAAABUhQAA
AQAAAAQAAAA5LjAACwDwgAggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAAADACaACCAGAAAAAADA
AAAAAAAARgAAAAABhQAAAAAAAAsAAIAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAACwAvgAgg
BgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADAAKACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAA
AAMAMIAIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAAAAAAAwAygAggBgAAAAAAwAAAAAAAAEYAAAAA
GIUAAAAAAAAeAEGACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAAAAEAAAAAAAAAHgBCgAggBgAA
AAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4AQ4AIIAYAAAAAAMAAAAAAAABGAAAAADiF
AAABAAAAAQAAAAAAAAACAQkQAQAAAIoJAACGCQAANREAAExaRnUoWbwkAwAKAHJjcGcxMjXiMgND
dGV4BUEBAwH3/wqAAqQD5AcTAoAP8wBQBFY/CFUHshElDlEDAQIAY2jhCsBzZXQyBgAGwxEl9jME
RhO3MBIsETMI7wn3tjsYHw4wNREiDGBjAFAzCwkBZDM2FlALpiBIwmkF0GlrZSwKogqEgQqASSBh
bSBjCHCjGCACMGx5IAuAdgbwZnYJgB8RIHAXwQuAZzEeQCBudQbQEoFvZtAgUG93BJBICGAUEO0e
QHALUA3gYSAQAiAEIJkDUiBJAjAEkGJhIaEAMy4zIHRvIE/qcgDQbCGwOB0AAHAfkNx0aASQIbEl
EXMDcCGwvwQBClAEICTgIjAi4CAT4G0fcCAJ8AWgdSMCCYAurSaBZyYBJiV5CGAgA/D+bAMgJrMj
0QEAB0Ao0STg3yVwB3ADEArBJdV3JPAfyEMioyQEL1JEQh16Rp0FsXMBkAAgBJBzLCiT/mMEkAGQ
C4Ae8Sk2E9EgML8pYSTwKaAN4CJCCsB5J7DmWSixKTZzcAWQBpAfAP8gYDCwASAlAQIwKaAiMAGg
mSNSdHkyQCewQWwlgPMwYwWgbm4FkCJCLfEFEO8r4gWxJAUo43ADYCNAAmD/HwAy1CKUMHICICGw
NhIs0WQgKB4zbm8FQCBgMfgwMCUlcAhwOII0rzWz+y6AKhAnBCAgsCthIGArQP8DEDahK1IeMAtg
LgAmoSTB8ymaLNEpLh16MXIo6xgg+QWgbXA9QgdANvMJwB5QPwQgI1Ak2TnAKaAIYGJ0/wQgMtYu
4AQgH7EwczOBM/P9PJJ0IUArYTkiJKIkBCew/kUfcAOgBpAwY0XUJUMqZPMugDByd2EfACThMpEl
Ut8j0BghIOAFwDARZCRAH5D3AMA3hj+bVCtSJOQEADBjfyXTIOI7MR9wIARFiCewT/84sSDxSDM9
MCAwBCAeMDCw/mQugEngJiEv4U8EIFsqkX8wQAXAE9IA0CMRIpAIkGxuZFITJAQEIFYKwBPSMv8n
sE1ATfEiICGRH5AlgzcSfyRAQrE9hTWxH4Ej0SIAbv5rI8Ik4SGhVLUhkCAiOcCGcgDAAyBDSEFS
I8A/V9Af4TEhPFFX0SewQnXvBUAmQ1HyKcBzSgEj4FSw6ngnsEMwGFRblyPRVdX/QtIhQCkBBbE1
sCdAIiEwVH9cIjyhNhEhsFkSICE/m0HvS8BiMgBwOcB5ICJXhU3m/mZUUSY0JAU1sCnARCEDkSdb
kTQANZYiIkLSTlX8TEwkk0LhJfAT0DxRPeD+bxQQQsEpATWlNxEyQCAB/VAiSSEAKKI2EguALgFE
we9aUWGSH6IgYGZhASJCSYT7GCAl8GxdASjyILBodEOxvwDAAkASgStAIjA0QW4fAP1ZEmEwQyZh
IZFpJW1xVMJ/KNRloAMRYDYgsFbDaHM9A2iDTfFGQUxTRSH/Yvs5wSTxZKceMAIQJ0Bywf9gMyUS
M2JZ1VHjOcIFgSqRfx+BQuFnIlfBMzJFFjDJV/9NVSVwBQA8wlHyQZVRwWVj/3KTOsV9CVpkfMNs
cTNwCyC/I/Y2EW/hNgN4ogQgKAuA/SQwdTCwgEIHcT+AVmQHgflW8nVwJXR9BQtgKKFEINdcfV3h
H4FiHwBwXKAgE/8wcnrPMNcde2ukJrMAcB8A/3aUIduAGR5QRWQjQi6AbzH+YUngJREmQyEpSrM8
kQtg91kxgmR6YiAWUB+xRzYkBftaxDdybweROcMpACEwUQK/a2ImpBQQPNKRoSzgQymg/wUQTyEm
NAUAI1Ak8HLBK1L/aZEnCXIGeKJWUiGwJAUkMP8IkDNBJYABgI6jS1QmIk3x/2S2RjEjEYncd4Vt
cQfRdpT9JdViXKEEYD4RUKQeYHgz/2bBJYAxEDdiXWodelySite3WWIHkCiFaAbwJWF5LgA/V9B1
qyFwMkCbRCTwbHAdkTJiKhA/mwgAYiBLfm8G8B10CFAAgG6hAHB0wahVRFAgTHQnoB16Zi2q8iQA
aWcLgCnRTd8oEXExqvMtZQNhOqngjYFzFAAdEyBbAMADECPQOsUdIi6tVEBwaFAwQZHeXR10BmAC
MK0wVwmANSAKczNweS6AMTEgShduoB8AAdAwsVAwNjrMMzdM5a5wICchI6QwvSGSTAQAPHCv1UQA
ajUxQa0wUEggNy46IEftOrJWBeG1MS4UQEb4HXr3pVVgcSPgLriAHXSwkB55/2DxtP+2BCoDlVIs
dzNnHXSEKFa6UDAtMTY/hv+5ESVCOzEAkASBICJO+UVG1yNDLB0jwiJg4WVoMLaq87pQI5EuNjlQ
SyKrYCTx3T+MRJNSi2E4oms5wAfg/0gBIUAo0AhgcrEpNyPgi2H/URMyJCnWi2MhAAhhHXSzGfMF
oAEAPyB8YMcjMHyOU/sy8VRhZMt3xuE1IFizHXS5QXxRdQ3gWUB9BHPLcW9wsp47UjS/Mz9MjJCB
cz8deq3DrVTKJQDQBpBpQ/8lQiDxCFAXsT5QI+C3xgdAeyoh1jNFOzEDcA3ggqFDAE84Mi0yMTQp
wb01NzE5KSAOQBRAwC0gNjc1OB10KnD/rrELYK8Ktw+3W1ZziEEw0PsDYAMAY4QjcTMkEACAKnC/
BBBt44LYi2Jv8QDQaIhy/y5xOzEvEkTygbQ1YiKj1dn/16UGsKSiUWEnECewPSFpYf9L0m8xOzFU
sAEAAjDI8gWx/zcQlfA9QTBAJ6GZIuMaTfH/C4AOsCSwWLRvMTYSMHIhks9QpQuAMLDoEGR154Tn
Qv9ngTEQB4Bo8QbgH3Brd0N0/1yy6MLp9UFxBSCZ8o5Oi2LfMLAE8GnBOoHiYnBkYi6A//GhNbGf
ATViBbHrSeKC4iL/UJTpo+kLNxE9MKbRJ5LXNfuKT0FiZZXxJMLenN/6H6L/BJADYElxC1BdYe6j
MnJ8w/vqAiqxbe1hBzAOsB7xh1H9IGAiGCALUF2T/RUCIB7w/2gw33Ykog8QNaFkUEID3sn/JKIT
4R+Q8mFrQfQo/ZAnQJ8iFeC74cg/mx16PSAHf/8IjwmfCcDUZXNBICIiAC4Ax60wH+CzMi1sQAvC
UDDrEHBW0C4YMHW0F30B80D6Za0wIiXwDhVoMB+xAAat7bBkXZMMJi0YIHEmAfZ0DK8dklWo0Q4Y
J0AOvxcPzxDfDP5ocABwOi/aLxbcL64iriBuGHPjEv4vDCbeGQvCTeLx0n4UIZD/FYQ+EVlkG6Qo
ogPQPhGOYhc6YQ4VTGZ9IEAAAB4AcAABAAAAIQAAAFBIIDcuMTBHIG9uIFZNUyA3LjEuMiBhbmQg
T3JhY2xlAAAAAAIBcQABAAAAGwAAAAHBCXApy2nTdSZz4BHVsSAAEFpvrlcACObLkAADACYAAAAA
AAMALgAAAAAACwACAAEAAAAeAEIQAQAAADAAAAA8MjUxNzY2ODZDMDAxRDMxMUIwQTMwMDEwNUE2
RkFFNTczRTcxRDFAQU5JTVVMPgADAP0/5AQAAEAAOQAwgeF4mwnBAQMA8T8JBAAAHgAxQAEAAAAG
AAAAS09PTFIAAAADABpAAAAAAB4AMEABAAAABgAAAEtPT0xSAAAAAwAZQAAAAAALAPIQAQAAAAIB
RwABAAAAKgAAAGM9Tlo7YT0gO3A9Q0RQO2w9QU5JTVVMLTAxMDcxMDIzNTMwOVotOTQxAAAAQABI
AIDViMSaCcEBAgH5PwEAAABCAAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAAAAAAAC9PPUNEUC9P
VT1XR1ROL0NOPVJFQ0lQSUVOVFMvQ049S09PTFIAAAAeAPg/AQAAAAkAAABSb2IgS29vbAAAAAAe
ADhAAQAAAAYAAABLT09MUgAAAAIB+z8BAAAAQgAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAAA
AAAvTz1DRFAvT1U9V0dUTi9DTj1SRUNJUElFTlRTL0NOPUtPT0xSAAAAHgD6PwEAAAAJAAAAUm9i
IEtvb2wAAAAAHgA5QAEAAAAGAAAAS09PTFIAAABAAAcw/urNXpsJwQFAAAgwDoHJe5sJwQEeAD0A
AQAAAAUAAABSRTogAAAAAB4AHQ4BAAAAIQAAAFBIIDcuMTBHIG9uIFZNUyA3LjEuMiBhbmQgT3Jh
Y2xlAAAAAB4ANRABAAAAMAAAADwyNTE3NjY4NkMwMDFEMzExQjBBMzAwMTA1QTZGQUU1NzQwNTM0
REBBTklNVUw+AAsAKQABAAAACwAjAAAAAAADAAYQtN+v7AMABxAFDAAAAwAQEAAAAAADABEQAQAA
AB4ACBABAAAAZQAAAEhJTUlLRSxJQU1DVVJSRU5UTFlJTlZPTFZFRElOUE9SVElOR0FOVU1CRVJP
RlBPV0VSSE9VU0VBUFBMSUNBVElPTlNGUk9NSU5URVJCQVNFMzNUT09SQUNMRThJQU5EVEhFUkUA
AAAAAgF/AAEAAAAwAAAAPDI1MTc2Njg2QzAwMUQzMTFCMEEzMDAxMDVBNkZBRTU3NDA1MzREQEFO
SU1VTD4AY6s=

------_=_NextPart_000_01C1099B.7BC9810E--