I am still working on a generic task where I need to apply journal file records to another database. Initially I didn't want to use Journal.Restore class methods as I need to perform some data transformation, and it seemed that the clearest way to achieve it was to read journal file record by record using %SYS.Journal.Record API.
This approach worked (with some help from @Dmitry Maslennikov and @Eduard Lebedyuk), while it turned that the processing speed of %SYS.Journal.Record:List query was very slow, about 1MB of journal data per second on a mid-range server.
Therefore my second try was to adapt Journal.Restore class to my needs. As you surely know, this class has got Filter property that allows setting up ZJRNFILT routine for granular processing of selected records. OK, it works, and seems to be several times quicker than %SYS.Journal.Record:List, but the new problem I faced is that it turns on interactive mode of journal restore, asking my if I want to rename the routine, etc - just as when this facility is used with interactive ^JRNRESTO utility. Running my code with JOB command didn't help.
These nasty questions can ruin the idea as I need completely non-interactive solution to run it with JOB command, e.g., using Task Manager.
Any help would be greatly appreciated.