I-SE and I-4GL RDS technical question
Posted in 1996
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Networking & sqlhosts Configuration
I have some important questions. The situation : An fglgo process runs a 4GL program that started a transaction and executed an UPDATE statement within it. The server process is sqlexec (I-SE). Both processes run on the same UNIX machine and communicate with each other via pipes. Questions : 1) Could the fglgo process catch the SIGTERM or SIGINT signal or I can only stop it with the SIGKILL ? 2) Can the sqlexec process observe in all possible situations that his parent fglgo process has been stopped prematurely and rollback the uncommitted transaction or could it be orphaned and the started transaction won't be rolled back ? What is the difference in this respect if the processes run on different UNIX machines communicating via TCP/IP ? 3) In which situations colud the sqlexec process be orphaned exactly if there are any ? Is there any way to stop an orphaned sqlexec process so that the started transaction be rolled back ? Thanks for advance ! Gabor (bloyd@informix.opensoft.kfki.hu)