Within PARFOR LOOP, database operations like exec and fetch are not possible even if database connection object is supplied to these workers.
The main reason is because, MATLABPOOL OPEN , opens new processes (not new functions). The client process (PCT) which holds the database connection object cannot share or send the object to other processes. This is analogous to file handles. In regular programming language like C++, two different C++ applications or processes (not functions) cannot share file handles as they are separate processes or applications in memory. Similarly database connection object which is created in one process (PCT Client process) cannot be shared with worker processes. Workers in PCT are not functions but are separate processes in the operating system.
The ultimate main reason for this is that database connection objects are TCP/IP ports and multiple processes cannot access the same port. That is why database connection object are not serialized. Ports cannot be serialized.
The workaround for this is to establish the database connection within the PARFOR LOOP. This means that each worker will open a new port to the database and communicate to the database through its individual port. But this also means the database will have to bear the overhead of maintaining multiple connections with different processes. This might be a performance issue based on the application.
