Internal-SQL-Service

Intersystems service that can be used to query an internal SQL table to send a snapshot downstream

Settings

Dialect - As per Internal SQL
SelectMode- As per Internal SQL view
Parameters- NOT YET IMPLEMENTED
ForwardComponentName- item to run the snapshot sent

Implementation

Add class to your your environemnt

Set up system default setting

Set forward component name

Working with the result set

See code example InternalSQLSampleOperation.cls in example class for help in using - formats result set in HTML table