DSXchange

[URGENT HELP] Hi All, The issue is that our client wants to install AntiVirus on all the datastage servers, but the Anti Virus is scanning all the process that are invoked by datastage. Since AntiVirus scans all the process, it affects the performance of the datastage jobs. So our client is trying ...

There is a possibility, server crash while the job still is running. If this happens then, job will be shown running in the director.

Please try to compile the jobs otherwise restart the DataStage service and try compile the job.

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.

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 Da...

Ok , I got a feed back frm the guys who manage these tables and the only difference in the table which is not getting detected is "Variable Length Fields". What I mean to say is the table has few columns which are of variable length where as in other three tables the columns are of fixed ...

For this problem, Please split the data base on period or based on key value and try to extract from the database. When you try to fetch bulk of data with minimum condition from oracle. The display of the initial rows will be very quick, but to start extract it will take very long time. This is beca...

Please find the below sample routine where you can excute the sql statment from command line prompt using the routine, *********************************************************************************** * rExecOra( pShellType, pOraDsn, pOraUser, pOraPass, pExecSql ) * Prepare command line vCommand =...