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