WRITESEQ not working for multi-thread routine

Dear All,

I wrote a multi-thread routine to extract data from T24 table and writing to a folder using WRITESEQ. When using multiple agents, all the records are not writing to the file. Whereas with a single agent, it is able to write all records. I can see WRITESEQ is failing to write some records as the message from 'ELSE' part is displayed and some are totally ignored. Appreciate if you could through some light on this issue.

Thanks

Hi
I afraid WRITESEQ is not very secure way to be used while concurrently writing to a text file. Instead you can create several files (one per agent) and then concatenate them. The other solution would be to write to a hashed jBASE file concurrently by different agents (be sure that ID of this file contains unique agent identifier - like TNO). Then you can convert this hashed file to a text one (and this could be even faster than the first approach).

Thanks VK, appreciate it.