TRUE TRUE - The data I will be storing is for reporting purposes - The
data will not be placed or accessible from any GE screens. I am hoping
to do this so that I can omit the time of having to build the screens
and so the I am not under the constraint of the screen refresh rate.
Brian Stevenson - Systems Administrator
University Health System - Business Information Systems
Office: (210) 358 - 9282
Pager: (210) 756 - 0582
Fax: (210) 358 - 9287
_____
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Peter Charbonnier
Sent: Monday, July 09, 2007 10:03 AM
To: [email protected]
Subject: Re: [Talk] BWS 9.0 & Cache Database
If you're going to build your own storage from scratch, then it
should be pretty straight-forward. The wizards in Cache will use the
List Build property in creating the global, which will automatically map
it to an ODBC accessible class method. The hard part (and the
contractually "iffy" part) comes when you try and map out the old legacy
globals to an ODBC. Sounds like instead of going directly, your moving
data into a home-grown global, in which case you can use the stream
method to just read out of the legacy global into your own and do all
your set and kills there.
Please let me know how this turns out for you, as I am always
getting questions about this. Since it's a lot of work, my stock answer
is "No...not possible. Use DBMS/Chronicles and get out of my cube".
Because you know, once you map out REG info, they're just going to want
Sched and BAR and MCA and anything else they can think of...
Good luck,
Peter
On 7/9/07, Brian Stevenson <[EMAIL PROTECTED]> wrote:
Thom,
They would heavily frown upon setting values in their
globals - contractually - however they give us an option of creating a
custom global in a custom UCI that we can access at our own risk so for
what I am trying to accomplish I would design and create the layout of
this custom global in this public UCI so that I can access or set at my
own risk. Thanks for the link - I will definitely be looking at this
since this would be A LOT faster than the alternative.
Brian Stevenson - Systems Administrator
University Health System - Business Information Systems
Office: (210) 358 - 9282
Pager: (210) 756 - 0582
Fax: (210) 358 - 9287
_____
From: [EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED] On Behalf Of Thom C. Blackwell
Sent: Monday, July 09, 2007 8:36 AM
To: [email protected]
Subject: RE: [Talk] BWS 9.0 & Cache Database
Greetings,
I do not profess to have any special knowledge
here J
According to Intersystems (maker of Cache) - SQL
is "built in"? and the below seemed to provide good info on same.
http://vista.intersystems.com/csp/docbook/DocBook..UI.Page.cls?KEY=GSQL_
config
So presumably, this <could be> used as a way of
getting data out - I do not know whether or not GE would frown
significantly (i.e contractually) upon actually using this approach -
or how difficult this would be to actually get usable information - I'm
guessing their data structures would be quite complex and figuring out
the correct SQL may not be for the faint of heart.
I'm pretty sure they'd frown significantly on
using this approach to get data into their system - most vendors I've
been involved with don't take to kindly to folks putting stuff directly
into their tables.
Regards,
Thom
Thom C. Blackwell
Product Manager
Boston Software Systems
(866) 653-5105 ex 807
www.bossoft.com
LEGAL NOTICE Unless expressly stated otherwise,
this message is confidential and may be privileged. It is intended for
the addressee(s) only. Access to this E-mail by anyone else is
unauthorized. If you are not an addressee, any disclosure or copying of
the contents of this E-mail or any action taken (or not taken) in
reliance on it is unauthorized and may be unlawful. If you are not an
addressee, please inform the sender immediately, then delete this
message and empty from your trash.
From: [EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ] On Behalf Of Brian Stevenson
Sent: Monday, July 09, 2007 9:20 AM
To: [email protected]
Subject: RE: [Talk] BWS 9.0 & Cache Database
Peter,
We do use GE Flowcast 3 (going to 4 soon) but I
was wondering if there was a way to access Cache without the screens -
They can be so slow... I was thinking of the ODBC connection but am
unaware of how this works or if possible.
Brian Stevenson - Systems Administrator
University Health System - Business Information
Systems
Office: (210) 358 - 9282
Pager: (210) 756 - 0582
Fax: (210) 358 - 9287
_____
From: [EMAIL PROTECTED]
[mailto: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ] On Behalf Of Peter
Charbonnier
Sent: Thursday, July 05, 2007 3:23 PM
To: [email protected]
Subject: Re: [Talk] BWS 9.0 & Cache
Database
Brian,
The short answer is "yes". Cache
programmer mode/terminal text sessions can be emulated with WRQ
Reflection, which BWS 9.0 has a connection for. You might be able to
use the terminal client included with Cache, but this would be trickier.
The long answer involves how you
actually intend to read/write to the DB. Cache is a DB and a scripting
language and for the most part people store and retrieve data via some
3rd party application (like Epic or GE Flowcast). You can do this
because the GUI is already written, and you can just set up a script to
send keys based on prompt like with any other app. If you have an
"empty" Cache install and want to use BWS to write data into home-made
globals...there are better ways to get data into Cache (like with ODBC).
~Peter
On 7/5/07, Brian Stevenson <
[EMAIL PROTECTED]> wrote:
Can BWS access a Cache Databases?
Brian Stevenson - Systems Administrator
University Health System - Business
Information Systems
Office: (210) 358 - 9282
Pager: (210) 756 - 0582
Fax: (210) 358 - 9287
_____
CONFIDENTIALITY NOTICE: This
communication is intended only for the use of the individual or entity
to which it is addressed and may contain information that is privileged,
confidential, and exempt from disclosure under applicable law. If you
are not the intended recipient, you are notified that any use,
dissemination, forwarding, distribution, or copying of the communication
is strictly prohibited. Please notify the sender immediately by e-mail
if you have received this by mistake and delete this e-mail from your
system. (University Health System)
_____
CONFIDENTIALITY NOTICE: This communication is
intended only for the use of the individual or entity to which it is
addressed and may contain information that is privileged, confidential,
and exempt from disclosure under applicable law. If you are not the
intended recipient, you are notified that any use, dissemination,
forwarding, distribution, or copying of the communication is strictly
prohibited. Please notify the sender immediately by e-mail if you have
received this by mistake and delete this e-mail from your system.
(University Health System)
_____
CONFIDENTIALITY NOTICE: This communication is intended
only for the use of the individual or entity to which it is addressed
and may contain information that is privileged, confidential, and exempt
from disclosure under applicable law. If you are not the intended
recipient, you are notified that any use, dissemination, forwarding,
distribution, or copying of the communication is strictly prohibited.
Please notify the sender immediately by e-mail if you have received this
by mistake and delete this e-mail from your system. (University Health
System)
-----------------------------------------
CONFIDENTIALITY NOTICE: This communication is intended only for the
use of the individual or entity to which it is addressed and may
contain information that is privileged, confidential, and exempt
from disclosure under applicable law. If you are not the intended
recipient, you are notified that any use, dissemination,
forwarding, distribution, or copying of the communication is
strictly prohibited. Please notify the sender immediately by
e-mail if you have received this by mistake and delete this e-mail
from your system. (University Health System)BEGIN:VCARD
VERSION:2.1
N:Stevenson;Brian
FN:Brian Stevenson
ORG:University Health System;Business Information Systems
TITLE:Systems Administrator
TEL;WORK;VOICE:(210) 358-9282
TEL;CELL;VOICE:(210) 410-0526
TEL;PAGER;VOICE:(210) 756-0582
TEL;WORK;FAX:(210) 358-9287
ADR;WORK:;Business Center;355-2 Spencer Lane;San Antonio;Texas;78201;United States of America
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Business Center=0D=0A355-2 Spencer Lane=0D=0ASan Antonio, Texas 78201=0D=0AU=
nited States of America
ADR;HOME:;;;;;;United States of America
LABEL;HOME:United States of America
ADR;POSTAL:;;;;;;United States of America
LABEL;POSTAL:United States of America
URL;WORK:http://www.universityhealthsystem.com
EMAIL;PREF;EX:/o=UHS/ou=First Administrative Group/cn=Recipients/cn=BLS90720
REV:20070328T174621Z
END:VCARD
