DSXchange

I found in the DS Manager documentation the way to do it (same way that Wolfgang suggested). The problem I was facing is mostly due to a really not "intuitive" Reporting Assistant . I would have thought that the view or print would simply print what you can see at the screen, but in fact, ...

I forgot to precise that in this job, 90% of the records will have to be updated and 10% only inserted. In that case, using a hash file is probably less efficient than simply doing a "Update existing rows or insert new rows" in a OCI stage.
What do you think ?
Thanks

Hi Ray ! Yes I know that what you suggest is the most performing solution. But in this job, we are not loading a lot of records that's why we thought of simply using this update action (Update existing rows or insert new rows). My question was : is it possible to sequence the execution of this 2 lin...

Hi ! I have one job with an ORAOCI8 stage with 2 input links, updating the same table (Update action : Update existing rows or insert new rows). I thought it could be fine to control the execution for this update action in order to sequence this 2 update actions (one after the other would provide be...

Hi !
You can do it like this :
3 job sequencers.
- one main job sequencer with 2 job activities.
first job activity for your first job sequencer,
second job activity for your second job sequencer.

Thanks for your answer.
I managed to export my metadata for my project to the access DB. But then, when I ran the Reporting Tool, it was as if no standard reports were predefined.
Do you think something is missing from the DataStage installation ?

Hi !
I'm looking for a way to generate documentation for my DataStage project.
I saw that we have a Reporting Assistant which we tried to use but unsuccessfully yet.
Can someone explain me what this Reporting Assistant can do and how it works, how to use it.
Thank you.

Thanks for your reply, Ray. The point is I was doing this in a Job Sequencer, as you suggested but as I found it a little long to add a new notification activity after each Job activity, I had the idea of using an afterjob subroutine for doing this, but I was suspicious about the job being really fi...

Hi ! I would like all my jobs to send an email if the execution doesn't finish fine. I was thinking of doing it by creating a new after job subroutine, in which I would test the status of the job and then send an email if the status isn't "finished OK". Can you confirm me that when executi...

Hi ! When a job writes record in a Hash File Stage. What appends when a record has the same key than a record already stored in the hash file : - is the old record replaced by the new one ? - or is the first record which was already in the hash fiel kept and the new one ignored ? Thanks for your rep...

Thanks for your suggestions. Before I get your answers, I found a way to do this with a sequential file (as Vincent suggested), after what I read this date from a Job Control (not from a routine) and then from the job control, I ran the Job sequencer with the date as param. I'll make changes to try ...

Hard-coding the stage name and link name works (I got my number of rows doing it). Hard-coding only the link name and using DSJ.ME for the stage name doesn't work. So I tried passing both the stage name and the link name separated by a comma and I retrieve this 2 args in my subroutine using the Fiel...

Yes, I checked everything (espacially before/after subroutine, which I use in the transform stage I want the number of rows in input). As you suggested, I tried hard-coding job name, stage name and link name, but this is worst as this leads to a -1 error (Invalid JobHandle). The job handle was OK us...

Thanks again.
Yes, I can see the number of rows in the director log.
I checked I used the good link name (I copied my link name and paste it in the Input Value field, but still get the same link name error).
Idea for what else to do ?

An other question dealing with Email Notification Activity : I have added a new parameter to my Job Sequencer for recipient email address. When filling in the email Notification Activity, how can I use this parameter ? How can I specifie that the recipient email address field contains my parameterna...