Page 1 of 1

Extract data from dbf parallel using odbc visual FoxPro

Posted: Sun Nov 30, 2008 7:29 am
by dinakaran_s
Hi,

I have two server jobs, which ectracts data from two different .dbf using ODBC stage. Both jobs are running parallel, but currenly only one job is able to extract data from DBF while the other jobs is waiting for the first to complete. It seems that ODBC dosen't support parallel processing or DataStage is not allowing?.

Both are two differtent jobs and they are using different ODBC connection, but both jobs are running in the same server.

Can anybody help me? It is urgent.

Posted: Sun Nov 30, 2008 8:45 am
by ArndW
An urgent question on a Sunday should be addressed to your 24x7 support provider.

Posted: Sun Nov 30, 2008 9:48 am
by chulett
It won't be DataStage that's "not allowing".

Posted: Mon Dec 01, 2008 6:07 am
by dinakaran_s
chulett wrote:It won't be DataStage that's "not allowing".

Hi chulett,

This is happening while trying access the DBF through ODBC satge in Datastage. Can you please help me. Let me know if you more details.

Posted: Mon Dec 01, 2008 8:07 am
by chulett
One "waiting" for the other would imply there is a locking issue and that you'll need to run the jobs in a serial fashion.