Extract data from dbf parallel using odbc visual FoxPro

dinakaran_s · Post by **dinakaran_s** » Sun Nov 30, 2008 7:29 am

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.

ArndW · Post by **ArndW** » Sun Nov 30, 2008 8:45 am

An urgent question on a Sunday should be addressed to your 24x7 support provider.

chulett · Post by **chulett** » Sun Nov 30, 2008 9:48 am

It won't be DataStage that's "not allowing".

dinakaran_s · Post by **dinakaran_s** » Mon Dec 01, 2008 6:07 am

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.

chulett · Post by **chulett** » Mon Dec 01, 2008 8:07 am

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.