DSXchange

Hi, StoredProcedure on SQL server with parameters need to be executed which creates a tabel with data. Hoping SP executes sucessfully, bring that data into Oracle database. I am thinking Stored Procedure Stage as source --->checkforSTPreturncode Another job,read data from the tabel, and load into Or...

I am getting .dsx files from ClearCase which need to be imported into project.
I am not sure how to concatnate them?Could you please elaborate on it?

I have multiple individual jobs(dsx files) that need to be imported into current porject.
It is taking time to import all jobs and for compiling them
What would be easy way to do this?

In DB2, the julian date is 94167 defined as Decimal. I need to convert this into 06/16/94.
Tried DateFromJulianDay function but getting ***

As chulett suggested, I added a script in Job2 to delay for a minute.
So far from last 13 hrs, it is running fine.

The jobs are running fine for 4 to 6 hours automatically through schduler. But after that time, job 2 is failing. Read Oracle tabel and write to DB2. At the same time update a field in Source(Oracle tabel) after succcesful write into DB2. So JOB1: Read Oracle tabel and write to DB2 and Dataset Job2:...

I have couple of jobs. Job 1: reads data from Oracle and writes to DB2 & Dataset Job2: read that dataset and update Oracle tabel These jobs runs one after another every hour. through scheduler Problem: After running for 4 hours, job2 is failing with error" /home/dsadm/Ascential/DataStage/Da...

Thank you for replying Ray. In this case, we are getting variable number of fields.

Would you please provide more information how can this can be accomplished with Pivot.

Data is coming in the following format: Column1 Column2 1 Bill,Brain,Greagory 2 Sam, Bopel 3 4 Toby As you see each row has different number of values. I need to preserve Column1 and associate values. Output should be as below: 1 Bill 1 Brain 1 Greagory 2 Sam 2 Bopel 3 4 Toby Please give me some inp...

It did the majic. Thank you craig. $dsjob -server ServerName:portnumber -user User.Name -password **** -run -mode NORMAL -wait -jobstatus -param FromDate=80909 -param ToDate=80910 ProjectName JobName returns Waiting for job... Finished waiting for job Job Status : (2) Status code = 2 Job has some wa...

I am getting, "Error running job

Status code = -99 DSJE_REPERROR"

I checked in Director. Job is in compiled state. I can run job from Director. But trying to run the same job from command line giving me error.

Thank you Craig. I as Developer can not dsjob from command line. Developer nned to have dsadm role. May be this is in v8.0.

Sorry. Still the same even without quotes.

Still the same error

Thank you. I tried
$ dsjob -run -mode NORMAL -wait -jobstatus -param 'FromDate=80909' -param 'ToDate=80910' ADW_SALES TestSalesDetailFixEE
but returns
Error running job

Status code = -99 DSJE_REPERROR