DSXchange

Thanks gentlemen, for your responses. ray, by "duff" data you mean some bad data, right?

I have a job sequence and I am trying to reproduce an error to check my restartability logic. I have a loop at the beginning within which a job is called. There is another loop later in the job sequence where there is another job. I tried stopping the job and restarting but Datastage asks me to rese...

Ok. So here is the interesting part. My server job has: Oracle stage----> Transformer ----> SeqFile However, the SeqFile stage is completely unnecessary but I am forced to use it as I don't have the output side without it. In the derivation of the output column, I execute the routine which sets the ...

This is the routine:

FUNCTION UpdateUserStatus(intRowCnt)
Call DSSetUserStatus(intRowCnt)
Ans = intRowCnt
RETURN(Ans)

I can create a server job if needed as I am just doing a SELECT COUNT. However, I don't understand where in the job I need to call it. I guess I need a tranformer.

I wrote a small routine called GetRowCount. How do I get the output of JobActivity1 so that I can set the UserStatus for this job activity? I would assume that there would some posts similar to this.

I have a job in a sequencer where I need to read the number of rows in a table and based on that populate an user activity variable in the sequencer. I am using the job to read the number of rows and put it in a sequential file. I am then using an Execute Command stage to read the value from the seq...

How does restartability happen within the StartLoop and Endloop stages of a a sequencer? Let's say we have 5 stages within the StartLoop and EndLoop stages. If the job fails on the second stage, would during restart,
the loop counter be preserve? Has anybody done something like this?

Well. After the modify stage, I have a sequential file stage. The input of this stage has no columns because the output of the modify stage has no columns. The job will not compile. I had to do this manually. Took a lot of time.

No, it doesn't work. I enabled RCP across the project, job and stage. I still see the Output tab as empty. There is no way to drag the columns from the input tab to the output tab.

Actually, I wanted the columns from input tab moved to the output tab at design time. It doesn't happen. How do I get the columns moved at design time without manually typing them?

ray, thank you for your response. I know about the KEEP specification. That requires that I specify every column that I need to keep. I have over 100 columns. I was wondering if there was another way or some other technique to get around it and apprently there isn't.

Thanks.

I have a modify stage in my job. All input column are populated. However, the output columns are empty. I want to move all input columns automatically to output columns without having to import it from somewhere. How do I do it?

Thanks ray. Can you tell me where I can read up more about @FM? I looked in to PX Jobs Developers Guide and Advanced Guide but couldn't find any details.

craig that did it. ExecCommand.$CommandOutput<1> + 1 worked. I am using version 7.5.1A. Can anyone explain why it worked? What does the <> work? It seems like an array element.

Thanks.

I tried ExecutCommand.$CommandOutput without the addition. This completely errors the job out.