New post
Question
· Jul 25, 2017

Working with external SQL table in cache

#JDBC #Object Data Model #ODBC #Caché

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.

Discussion (4)0
Log in or sign up to continue
Robert Cemper · Jul 25, 2017

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?P...

4 0