Making a counter process that periodically dumps amount of messages into a

Question

Niko Wahlroos · Sep 26, 2021

Hi!

We're doing a small data integration project at our university and I've run into a problem.

I'm trying to make a counter that records the amount of messages (a simple .txt file transfer) that pass through a process and dumps that amount into a text file (preferably with a timestamp) every 10 minutes or so.

What I've gathered it's possible to do it via SQL query but linking that query into a process is something I haven't found any info on.

Are there any semi-beginner friendly ways to do this?

Thanks in advance!

Product version: IRIS 2021.1

$ZV: IRIS for Windows (x86-64) 2021.1 (Build 215U) [Health:3.3.0]

Discussion (1)1

Vic Sun · Sep 27, 2021

Hi Niko,

I'm not sure I understand what you mean by "linking that query into a process", but you can run SQL from Object Script code using either dynamic or embedded SQL:

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL

I hope that helps. If you are looking for other general guidance for this, feel free to reply.

0 0

Making a counter process that periodically dumps amount of messages into a text file