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_confi g 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)
