Working with external SQL table in cache
Hi, I would like to read a row out of an external SQL table and reference the returned results directly from my cache class. I've set up a link table and a SQL gateway connection. but I'm not real sure how to use them in COS. Anyone have examples out there, or some assistance? Thank you.
Comments
The fact that the table is external is just a concern of storage strategy in the generated Caché Class
To your COS code it's just another class projected as table.
Use it by your preferred ResultSet Class
It might be a good idea to check access first from Mgmt Portal to verify access rights.
for the example:
http://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?…
Glad I could help 
Do not forget to mark the answer as accepted, if you this so.
Thanks, the piece I was missing was creating the link table to the external table. I set that up and now I can access my external database as if it were local.