Progress Adding Files to directory?

[LostAngel]

Hello, we use a manufacturing program called TMM that uses a Progress backend. Recently, we noticed that pretty large files are being created in a directory in TMM. When I open these, it seems to be data from places in the progress database. Any time a query is ran (though VB or WinSQL), it seems a file is created...I am only running SELECT statements, no insert/updates. With WinSQL, there is an option to "Auto Commit Transactions". When this is checked, the file is deleted after the data is stored. Does anyone know how to do this in VB? I have tried cnTMM.CommitTrans, but it doesn't work (I guess it only works when you are inserting data).

 

[mpowell_esq]

This is standard behaviour. It is how Progress OpenEdge (and most of the IT world) handles data, by using buffer files.
There is likely to be a flag somewhere that will automatically delete the temp files after use. Without seeing UR system and settings I can not guide you where to uncheck, remove the flag. I can appreciate that you may rather not hold this data, for storage / disk space reasons. However if you are not needing to be economical with disk space, why bother removing the flag. It is good procedure for the future to have these for disaster recovery reasons. If it is not broken - dont repair it!! If it is currently not a problem - why mess. UR question has been answered - What is it?