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_c
onfig
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] 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] 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)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
