DSXchange

Direct all failures to the UtilityWarningToLog routine as well as any other processing. This will propagate warnings "up the chain of control". Your top-level controller can then detect that a warning has occurred. Ideally create your jobs so that no other warnings occur. I will research ...

All good suggestions. We had not used any jobs with Checkpointing, as most of the jobs originally were written for version 6 with job controls. I was able to get the major failures to generate warnings in the inner sequencers so that I can identify any jobs with status other than 1 (OK). Then I can ...

chulett wrote:What exact version of DataStage?

DataStage Server version 7.5.1.A on AIX 5L.

We have a sequencer job that calls seven sequencer jobs (1 each for 7 different tables, each including extract, transform, load stages and some routine calls). Each of the seven sequencer jobs has notification set up for failures of any stage, and this works well. We want to send out notification fr...

I was able to write a routine to do what we wanted, using examples from other posts. I know that you can get job names and status directly within the sequencer, but couldn't come up with another way to do this without a routine. Included code below. Thanks all. #INCLUDE DSINCLUDE JOBCONTROL.H JobHan...

Hi I am working with the Oracle Enterprise stage and would like to truncate a table and then insert records into it. I tried the load option in the stage but it gives an error. I would like to do this by including custom code in the oracle stage, first truncate then insert records.How do I do this?...

hi we want to upgrade datastage to latest version 7.5.1.A.I just want to know is there any bugs in latest version.we want datatstage version which is compatable to oracle 10g. pl share your veiws. THKS We completed the same transition on AIX last year. The GUI dev tools have a few bugs, but nothing...

We have DataStage jobs which run after the ETL stages in a sequence that compare counts on the source and target. These require re-connecting to the source and target via ODBC/OCI to query the info. Is there a command to capture the counts from the Extract and Load stages (one is ODBC, the other OCI...

Hi all, how to call build in procedure from oracle oci stage , i want to run following pl/sql code from oci stage begin DBMS_MVIEW.REFRESH('Test_VW'); end; Thanks rv I am not sure if you wish to do this as a before or after proc. Assuming you wish to refresh your view after you insert data into a t...