If you have Cache 5.2 you have the InterSystems mapper routine, %fm2cache, already installed.
I will send you the documentation directly, Steve. I have an email into Mike Clayton requesting clarification on distributing the VA's mapper. Regards, Renee PS - You did not miss anything, I didn't mention the routine name. And, when I said "namespace" I was referring to what the VA calls a VistA namespace (not to be confused with a Cache namespace). -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, April 07, 2006 10:33 AM To: hardhats-members@lists.sourceforge.net Subject: [Hardhats-members] Re: Getting SQL access to Fileman files on Cache Tks Renee! So, if I'm running Cache 5.2 or greater I already have the routine...sorry must have missed the routine name / namespace, what is it? Renee Cannon writes: > I am glad you asked that question. The short answer is "No." > > The VA is developing its own set of routines. Mike Clayton is at the helm > and says it will be rolled out as soon as QA is finished and the necessary > permissions are granted (he did get an official routine prefix/namespace > name). Some VA sites are running it as beta and are very pleased with the > results. > > My understanding is that the mapper developed by the VA would be available > under FOIA... can anyone confirm that? Are all VistA patches available > under FOIA? > > InterSystems has several non-VA customers who run VistA so a utility was > created to support any Cache-FileMan shop that wants SQL and objects for > FileMan files. There is no additional cost for the utility. > > The VA and InterSystems FileMan SQL utilities are similar but they handle > certain phenomena differently. In general, users who want readonly access > could use either tool and get everything they need. And, it's standard, > ANSI SQL so all the SQL commands you know for running queries, creating > users and granting access work as you would expect. > > One vendor optimization I would like to point out (at the risk of straying > out-of-bounds) to save effort when writing queries is "implicit join" > syntax: Caché SQL supports an Implicit Join syntax, represented by the > > operator, which simplifies the SQL for certain types of joins. You can use > the > operator whenever a table has a reference column, that is, a column > containing the ID values of another table the referenced table. The > > operator can be used to refer to properties within the referenced table. > You can read more about this and see an example at the following link: > > http://platinum.intersystems.com/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_sp > ecialfeatures > > Thank you very much, > Renee Cannon > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Friday, April 07, 2006 9:04 AM > To: hardhats-members@lists.sourceforge.net > Subject: [Hardhats-members] Re: Getting SQL access to Fileman files on Cache > > Renee, > > Are these the same set of routines developed my Mike Clayton? > > > Renee Cannon writes: > >> Hello >> >> >> >> If you are running Caché 5.2 the routine is already there. Otherwise, > just >> email a request for the FileMan SQL utility to [EMAIL PROTECTED] > and >> you will get a response message containing a small attachment (extension >> will be kit to get around email blockers) that has everything you need > to >> create SQL and object access to FileMan files. >> >> >> >> Ashfaq, you need not send a request, I will send you the tool and >> documentation today. >> >> >> >> Thanks for your inquiry! >> >> Renee Cannon >> >> InterSystems Corp. >> >> >> >> _____ >> >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] On Behalf Of ashfaq >> Sent: Friday, April 07, 2006 7:13 AM >> To: hardhats-members@lists.sourceforge.net >> Subject: Re: [Hardhats-members] Getting SQL access to Fileman files on > Cache >> >> >> >> What is this free tool and how can i access it >> >> >> >> >> >> Ashfaq >> > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting language > that extends applications into web and mobile media. Attend the live webcast > and join the prime developer group breaking into this new coding territory! > http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642 > _______________________________________________ > Hardhats-members mailing list > Hardhats-members@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/hardhats-members > > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting language > that extends applications into web and mobile media. Attend the live webcast > and join the prime developer group breaking into this new coding territory! > http://sel.as-us.falkag.net/sel?cmdlnk&kid0944&bid$1720&dat1642 > _______________________________________________ > Hardhats-members mailing list > Hardhats-members@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/hardhats-members ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=k&kid0944&bid$1720&dat1642 _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642 _______________________________________________ Hardhats-members mailing list Hardhats-members@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hardhats-members