DSXchange

Ensure that your job generates no warnings at all... we have thousands running every day with not a single peep from them. Only delete when you know there is something to delete. Only update when you know there is something to update. I have modified the user-defined query to include as below: if (...

We had requested the Production Support team, to confirm with the support provider whether WIndows 2003 supoort DataStage 5.1? However, in case DataStage 5.1 is supported on Windows 2003, what all need to be taken care of. I am assigned the task of preparing the document for migration strategy. This...

Can you provide me the URL, which can give me this information?

Hi, Presently, we are working on DataStage 5.1 installed on Windows 2000. And planning to migrate the O/S from Windows 2000 to Windows 2003. Please let me know what all needs to be taken care of related to DataStage. Also, that within the DataStage jobs, through routines, we are calling VB methods. ...

If I consider the execution of queries in the Query Analyzer;
when I use the name value from .csv file, query is not returning any rows. But when I reenter the same name in query analyzer and execute it, its returning row.
Why is that?

Hi, In the current project, we have a job processing the .csv files (source is the .csv file) and finally loads the data into SQL database. Within the .csv file, have the data of varchar data type, mostly names fields. After fetching the data from this file, these names fields data will be looked up...

Hi, In the current project, we have a job processing the .csv files (source is the .csv file) and finally loads the data into SQL database. Within the .csv file, have the data of varchar data type, mostly names fields. After fetching the data from this file, these names fields data will be looked up...

Hi, I am getting the following error for a scheduled job. Jobname..TransformerStageName.LinkConnectingTransformer&ODBC stage: DSD.BCIPut call to SQLExecute failed. SQL statement:DELETE FROM sysdp.dbo.SpData WHERE (batch_id = ?); This SQL statement is entered in the ODBC stage under Update Action...

Hi,

Cleint is planning to upgrade the O/S from Windows 2000 to Windows 2003. At present we are working on DataStage 5.1. What all need to be taken into a/c for upgradation(before/after) of O/S and how efficient testing can be done after the upgrade?

Please advise me.

Thanks,

In the last three months, we faced issues of jobs behaving abruptly, thrice. And I always posted these issues in Forum. In each of the post, I mentioned different types of issues (as in this post) since different kinds of messages used to be logged during different run times, but didnt get the solut...

Hi all,

Thanks a lot for all your valuable suggestions. Atlast all the issues realted to the job aborting, are fixed when the server is rebooted.

Could anyone tell me the root cause from this fix.

Appreciate your help.

Thanks,

When the job aborted, I can see the error message: "Abnormal termination of stage InputPUSHJob..SepVersionField detected" Message posted previously, was logged when I had reset the job "We have refreshed the job in this environment with that of Dev. Now i am having different error mes...

We have refreshed the job in this environment with that of Dev. Now i am having different error message as below:

InputPUSHJob..PUSHInput.FromPUSHInput: Run stopped after -2 rows.

Any idea of why this is occuring?

Ray, I have gone through many posts for the issue of Abnormal Termination of Stage in the Forum. After resetting the job, need to look for the "For previous Run" message in the Job log. When I had reset the job, I am not getting this message logged. However, now the job is aborting with Ab...

Ray,

I could see only
"Latha1919 wrote: I came to know from the support team that dsoper has full control over the infiles folder. Any ideas? Don't believe anything you're told. Demand proof (for example a"
part of your message.

Please Advise,