we are working on a solution that creates reminder files out of a ERP System via Planet Press to PDF-Archive.
The source Data can be recieved out of a IBM DB2 DataBase Business Routine that COBOL Creates and that is extracted and pre-organized for Planet Press by a C# Routine that connects to de IBM/DB2.
Planet Press catches the defined Data via a single SQL Request on a defined View on the IBM/DB2.
1st Priority ist that it has to have a over the top performance.
The Data Construction out of the DB2 allows us only one SQL Request per Reminder Series created by the ERP System.
So we need a Return Parameter for each finished SQL-Request, means when the dedicated ResultSet is correctly recieved that Planet Press must have to send an information of the state (success/fail) of this Request at runtime to the C# Routine, so this function can pre-organize the data for the next Reminder Series out of the system.
How can we (Planet Press Developer/C# Developer) realize this issue. Im more on the code devolping side of this project, but my solution was to work with sockets? Cause theyre fast and lightweight.
Answers recommended, please.