DSXchange

When I run the job, I specify..

pEmpId='1A','23','4ED'

I am passing values to the job during run-time through the director. Is there a specific format I need to pass the values into?

Hello,

How can I pass a set of string values into a where clause in a SQL query through a parameter?

For Ex: Select * from employee
where id in ('pEmpId')

I want to pass pEmpId='1A','23','4ED'...etc

I am able to pass a single value, but am unable to pass mutiple values.

Please advise.

Hi, I have an after-job routine that captures the row count stats in a job based on the link names (SRC, TGT & REJ). The routine works for most cases, but for some types of jobs (Jobs that have a seq file as a target) the row counts are doubled. I tried my best not to calculate row counts for li...

Hello, I have a set of audit jobs that are executed from a routine using DSRunJob. The routine called be called at the same time by mutiple jobs. So the audit jobs that are kicked of by the routine need to capable of running parallely using invocation. How can I use job invocation along with dsrunjo...

Wat I mean by "it doesnt work?" is the job "Test" does not get executed, when this routine is called. I have this as a before-job routine in another job(Test2). So when I run Test2, I want job "Test" to be executed first before "Test2" starts. Evrytime I run T...

Hi, I have a before-job routine that has to execute another DataStage parallel job. If I define the routine as a transform function and test it works, but if I change it back to type before/after then it doesn't work. Can anyone please let me know what I am missing here.. $INCLUDE DSINCLUDE JOBCONTR...

That was my proposal too, but the client would like to explore the possibility of logging the audit to the table as each job completes. So, I would like to know if there is a way I can write to a table after each job run from an after job routine, rather than run a separate audit job after each job ...

Hello, I am writing a routine which will run before/after each job to capture audit logs for that job. The before routine will have to access a staging audit table retrieve latest info from it and the after routine will insert/update the audit logs to the table after each job run. Any suggestions wo...

Hello, When I try to run some of my DS jobs it just hangs and does nothing. eventually I had to kill them from the server. This happens to all jobs that tries to access one particular database. Every other job runs fine. I am able to access that database through TOAD. I am also able to view data thr...

Yes. It still happens. Could there be an issue with permissions or space?

1)The error happens right away. It does not process any rows. 2) I am doing a left join on two oracle tables using the join stage and outputing to a copy stage. I changed the join stage to a lookup stage and it works. 3) I am able to view data in both the oracle tables. 4) Other PX jobs that connect...

Hi, I am geting this error in PX. The job has two oracle stages, 1 Join stage and a copy stage. If I replace it with a lookup stage then it works. /bin/echo: write error: Broken pipe cs}}},1: Operator terminated abnormally: received signal SIGBUS There are no warnings or errors other than these two....

Thanks everyone.

Hi,

I am trying to install the datastage client in my personal computer but not able to. I am getting the following error.

This product must be installed on windows nt 4.0, windows 2000 or windows 2003.

I have a windows xp 2002 home edition. Can't datastage client be installed on this??

Thanks.