DSXchange

The value I try to store is a string

Hi all ! I have a job JC1 (job control) which runs a job J2. J2 calls an after job subroutine in which ends by a command DSSetUserStatus. From JC1, I am trying to retrieve this value from the user status area. I tried to find it by using the command : Result = DSGetJobInfo (h$4, DSJ.USERSTATUS) wher...

Hi !
Your problem should be solve by creating a link.
see ln command in Unix (by doing: man ln)

I'll study all this possibilities (including the solution in a GUI job, which I didn't expect to be abble to run another job) and I'll see what changes I'll make in my job(s). FYI (but I don't remember who asked) : this job is going to run other jobs but without waiting for the end of this jobs. Tha...

I sent my previous email before reading Ray. Ray suggested to do this in a job (with design) too. Does it mean that it is not possible to do this in a JOB CONTROL CODE ? I was looking in this direction because it seems simpler. I thought datastage could allow to change your data source (file or data...

I still don't understand how I could do a DSRunJob for each row in a job which has a design ... I have a strong feeling that I need to write a JOB CONTROL CODE to do all what I need to do (retreive job name and parameters values from Oracle tables and then execute a DSRunJob for each row) No suggest...

ManjulaMadhu, what you suggest is exactly what I want to do.
but to do this ("get the required rows from the table in the second job itslef and then do the process") I need to define a cursor on the rows returned by the SQL query, don't I ?

No, I mean that for each row of my table, I launch a job to run. This table is a "scheduling table" , it contains the jobs that have to be run (for each row of the table, I do a DSRunJob).

Thanks for your suggestions. One important precision : I wanted to do this cursor in a job control code or in a routine code. For the moment, I have 3 jobs : one sequencer which sequences the 2 followings : - 1st job (job server with design flow) : select the rows from the table and write them to a ...

I have a parameter for email address in my job sequencer.
I want to use this parameter in a NotificationActivity (email).
What special caracter do I have to enclose my parameter with in the senders and recipient email address fields ?
Probably easy, but I didn't find it in the doc/help.
Thanks.

Hi ! I've been searching through the DS documentation to find how to define and use a SQL cursor in a job control or a routine. The only cursor I found was for "screen and cursor control ..." stuff. Does this mean that with Datastage you cannot define a SQL cursor ? What I want to do in a ...

Hi Ray ! that's the way we are doing this right now. We want to change this in order to have set of jobs reusable anywhere, without having dependencies with their top job sequencer. this would be usefull for exemple to avoid having to change all the hierarchy of job sequencer when you add one parame...

Hi ! A few days ago, I asked a way to find a value stored in a Database (date) and pass it to a job as value for a parameter in a Job sequencer. This works fine using a routine in the job sequencer. Now, I have changes to my requirements as I'll have to find values for many parameters (20 or even mo...

Hi !
Do some of you have use Parameter Manager ?
Can you explain in which way it was useful to your project ?
Thanks.

This job doesn't process a huge amount of records (50000). Not the best job to do this performance scenario.
But in the near future, we are going to optimize our jobs and we'll do this kind of performance tests for the jobs processing a lot of data. I'll let you know the results then.