I am iterating over a table of guids and preforming some business logic on each. When that's complete, depending on what happened during the business logic, I may push the guid to a results table. It looks like my best, (only?), option is to create a hold using filedef and -WRITE the guid to that file.

A couple Q's:

1. I came across some code which suggests the way to approach this is something like:

FILEDEF RESULTS DISK ????/results.ftm-RUN

- begin my loop - do my work

- if I want to write the guid -WRITE RESULTS &GUID

- end of loop

Does that look right? Do I not need to define a mas file? If that is the right way to go about it I'm getting the following error so maybe I'm missing something?

2. I learnt a little while ago that if I want my holds to be removed at the end of the request I don't want "ON TABLE HOLD AS 'foccache/temp_hold" but rather "ON TABLE HOLD AS temp_hold" as foccache is session, the other route is for the duration of the request, (feel free to correct me if I'm wrong about that). So with that in mind, where would I want to create this hold if I want it to be deleted at the end of the request? So in the below code, what should "????" be?

FILEDEF RESULTS DISK ????/results.ftm-RUN

Thanks!

This message has been edited. Last edited by: FP Mod Chuck, January 30, 2019 12:53 PM