DSXchange

Hi, Just went through the postings in DSxchange with regard to Job logs. I am just a beginner. I was able to find the log details in table RT_LOGxxx xxx job number. Is all these logs info present in the universe DB? If so how do I retrieve them using a DS Job? I tried using a Universe stage. But the...

Hi, Is there any way to automatically reset and start the job on any abort or failure. That can reduce a bit of manual intevention into the system. will the batch job that sequence these can handle them without going on aborted state. Is there any way look the log details other then director. Is the...

Hi, We support lot of applications developed using DataStage. Generally all the applications runs for long hours Is there any way that all the projects from same system can be viewed in one pane? For example 2 big projects which constitutes many jobs are running parallel.General ways of monitoring i...

hi,

With the ODBC Stage there is an option for fatal errors and warnings in the error tab.

This option is enabled only when the create table option is checked.

What is the use of it.
In which it can be used extensively ?

hi i am just a beginner with Data stage. I have problem when i use stored procedure option in ODBC Stage. How to create a stored procedure in an ODBC Stage? I am able to execute the procedure through the ODBC Stage but job aborts. What does the column tab in the Stored Procedure meant for? How to po...

When i try to insert/update into RedBrick DB DataStage generates warnings as (for each row inserted/updated) DSD.BCIPut call to SQLExecute failed 0 Rows affected. but actually the rows are inserted into the table with proper datatype and time stamp. what could be the problem that generates this warn...