Hi all.

I have been searching high and low for hours, but I am not able to anything on my question.

I am looking for any system variables I can call after having performed a modify operation, so that I can do some automated control if the modify was succesfull or not. Like the "&LINES" you can check after a PRINT/SUM operation to se how many lines you got out of that operation.

I would like to be able to check how many lines were:

* Updated
* Inserted
* Rejected

Does anyone know these variable names, or if they even exist?

Thx for your help, and merry x-mas.

Brgds
Jørgen Enger Fjellin

This message has been edited. Last edited by: <Emily McAllister>,

Hello Jorgen,

From the MODIFY manual:
Dialogue Manager Statistical Variables
After you execute a FOCUS request, FOCUS automatically records statistics about the execution in
specially designated Dialogue Manager variables. Since these variables do not receive values until after
execution is completed, they are not useful in the requests themselves. However, you may use them in
FOCEXECs after execution (that is, after the Dialogue Manager -RUN control statement).
The variables that pertain to MODIFY requests are described in the following table:
Variable Description
&TRANS Number of transactions processed.
&ACCEPTS Number of transactions accepted into the database.
&INPUT Number of segment instances added to the database.
&CHNGD Number of segment instances updated.
&DELTD Number of segment instances deleted.
&DUPLS Number of transactions rejected because of an ON MATCH REJECT condition.
&NOMATCH Number of transactions rejected because of an ON NOMATCH REJECT condition.
&INVALID Number of transactions rejected because transaction values failed validation tests.
&FORMAT Number of transactions rejected because of format errors.
&REJECT Number of transactions rejected for other reasons.

Danny.

Thank you so much. You just made my day! Exactly what I was looking for.

Have a merry christmas, and a happy new year when time comes!

Jorgen,
You are welcome!
Do you have the MODIFY manual?
If not, I suggest you download it or I can send it to you.
Best wishes,

Hi Danny,

Can you pls send me MODIFY manual?
My ID ==> maran@tigmatech.com

Thnaks.

Hi Maran,
Sent!

Got it!!!
Thanks Danny!

Just in case ......

Modifying Data Sources With MODIFY