Hi all, I wanted to know if anyone is currently using the C$REDIRECT function in a Pre mode on file I/O and if you have had success with this in a production environment. Also are there any tips, performance issues etc in using this. I am not replacing the standard I/O routines with this, I am using it as a trigger when certain I/O takes places.
I use C$REDIRECT in pre-mode to update a SQL database with tables that match the Vision files in our application. The COBOL callback program launched by file I-O action calls a DLL and sends the Vision record in the handler-record-area to it. The DLL writes that record to the appropriate table in handler-file-name. The DLL is multi-threaded so there are negligible performance issue. The only performance issues occur with large batch processing and even they are negligible.
I created a Data Dictionary that matches fields in the Vision files with the related columns in the SQL tables.
I also use it in the Replace-mode to work with SQL tables with no physical Vision file.
Hope this helps,