AIX

Hi, my name is German.
Im working with an aix over one year and i have developed a PRO*C multithread process that reads commands from a table and execute it in parallel (one command by thread) with a system function call, so depending the process exit code (system return value) , I put a mark (OK or ERROR) in that table.
My problem: there is ONE process that terminate ok and the system function returns an exit code different from 0 and consequently I put a mark erroneous.

Then I thought , system function is not threadsafe (problem with signals) and im not got a consistent return value ? OR, I saw that this process is a ksh script and not have the "exit 0" sentence if everything go fine, so maybe ksh (or sh -c) not return a default zero value when the script finishes its execution at the end of the file

Sorry my english, I really hope you can help me.
Thanks a lot in advanced.
German.

A ksh script without an exit 0 will return the result code from the last command executed in the script. If the return code of the final command is non-zero the exit code from the script will also be non-zero.

My last command is sqlplus. It execute a pl-sql script and doesnt have any return value forced. The log file shows that it finished ok.
So, my question will be the same again, sqlplus running a plsql script will return always a zero value if it finishes its execution at end of script?
I think that I must look for the answer in the correct forum/topic.

Thanks a lot reborg!