DSXchange

I don't think that you can delete a Parameter in Sequence, which you are going to use in one of the jobs. But, lets say that you have defaulted the value of a Parameter(Param1) in Job1 to "A", then you can default the Parameter(Param1) to "A" at Sequence level. Hence, you don't h...

Craig,

It is working now. It was a silly mistake.
The problem was that svJOBNAME stage Variable was not creating correct Job Name.
Thanks for the help.

Hurray!!!!

Craig,

My requirement is to get all the information about a Job.
For example, Job Name, Row Count, Start Time, End Time, Status, etc.

It is basically an Audit Process which will get information about all the Jobs.

I wrote a Server Routine.
Below is the code.
And then I am trying to call this Routine inside a transformer using the Code below:

Hi,

I have built a user defined Server Routine.
I compiled and tested the Server Routine, it works fine.

When I called this Server Routine in another Server Job, it is returning me -1 value.

Any help will be appreciated.....

I think Vertical Pivot should help.

Let's say that you have 6 rows with data and then it will be repeating.
So, you need to concate first 6 rows in 1st record and then next 6 rows in 2nd record and so on.

Afterwards you can parse them out and put it in different columns.

Pavan,

To me it seems that Remove Duplicate should help.

But, I have a question. What would be the output for the below scenario:

77604
60120
77624
77604
77604

In order to check the value between 2 consecutive records, use Sort Stage. In Sort Stage there is an option of "Create Key Change Column", set it true. So, it will change to '1' whenever you have change in the Key field. Key Field KeyChange 1 1 1 0 1 0 1 0 2 1 2 0 3 1 4 1

Hi,

Issue: Missing Vertical Pivot

Description: When I use Pivot Enterprise Stage in DataStage. I am not able to see Vertical Option in Pivot Type(Stage---> Properties ---> Pivot Action ---> Pivot Type). But, I can see that option in the other projects.

Sometimes, the problem is easy but we think too hard and make it complex....
:D

Try to get the string after @ in a Stage Variable and then try to find period. For example, SV1 ---> @name.co.uk SV2 ---> Try to find period in SV1 using Index using Index(SV1,'.',1) If SV2 has any value other than 0, it means that it has period in it. And if SV2 has value 0, it means that there is ...

Let's say your number is 174.12 and you are trying to divide by 5.2.

What would you round this to.
1) 170
2) 171.6
3) 176.8
4) Any other number.

Did you try my approach?

Hi,

You can create a stage variable sv1 of type decimal(15,0).

SV1 ---> Value(2742.334566)/Integer(5)
Destination Column ---> SV1*Integer(5)

I am not sure if this will help. But, according to me it should work.

SV1 ---> 548
Destination Column ---> 2740

And also try to see the file in Notepad++ or textpad. I think there must be some weird character which you might not be able to see in unix or Notepad.

Can you show the Test Data and Test LKP.