0
328

Written by

Yakov Berger
Follow
Question Yakov Berger · Mar 12, 2020

How to populate and then then query a staging table in a Business Service

#InterSystems IRIS for Health

Hi,

Newbie Question.

I have a Staging table i want to populate by running a Stored Procedure  and then query the same table with some sort of SQL inbound Adapter.

is this possible or do i need to create a separate service for this? 

Thanks

Discussion (1)2
Log in or sign up to continue

Comments

Jenna Makin · Apr 15, 2020

Hi Yakov

First, I wouldn't implement this kind of logic in a business service.  I would have a business service that immediately passes a message to a business operation and then perform these functions there (or possibly in business operations).   Services should not be long-running which building and querying a staging table seems like it might take some time.

0