DSXchange

Thank you all for your valuable inputs..!!!

I am sorry I have not been able to respond quickly enough... but Many many thanks for your expert advice Ray and Kryt0n !!! I don't know what I would do without your help! :) Yes. I was missing the functionality of stage variables which do not reset as it loops through the rows. And doing what Ray s...

Hello Datastage experts, My post is in continuation to this thread: http://www.dsxchange.com/viewtopic.php?t=89090 I think the earlier post was very old and I did not get any response from anyone so I have posted a new topic. I am trying to calculate median using the stage variables described by VMc...

Hello Experts, I realize this is a very old thread, but I will be really grateful if anyone can help me in some doubts I have. So far, for Even number of rows, I have the 2 rows which will give me median. But I am not able to use the above stage variables to calculate median because when IsEvenMedia...

That was EXACTLY the problem!! When I did "Edit Row" for Column 4 and Column 5, the field width was set to 160. And so was for the last column! I changed it to the required length i.e. Char(1) and Char(7) respectively and I got the required output!! Hands down genius !!!!!! :D I am wonderi...

sorry about that!!
I have edited my post now.
Thanks,
Hiral

in the above job design, SQL Server table is being looked up from the look up stage.. I think it got messed up in the diagram while posting..

Hi Mike, I am sorry about that, I just did not want to bombard everything which may not be relevant. Below is all the information of the job: SQL Server Table || || Sequential File ==> Transformer ==> Join ==> Lookup ==> Transformer ==> Sequential File My source is a multi header/detail sequential f...

Hi Ray,

No I have not defined " " as the field delimiter on the Format properties.

Should I?

Thanks,
Hiral

Hi Ray, I implemented Convert(" ", "", NullToEmpty(MyFieldName)) after making APT_STRING_PADCHAR = 0x20 but I still see spaces padded in the file. :( Am I doing something wrong.. I also tried - Convert(Char(32), "", MyFieldName) but still no luck... Hi Mike, I used VarC...

Hello Everyone, I implemented your advice of replacing the pipe character with "&&" and it is working like a charm. But my problem is that the business wants me to handle [NUL] or 0x000 without using the unix command. Datastage by default pads 0x0 when a sequential file is generate...

Thanks Craig. let me implement this and check.

Actually I have trouble re-creating the scenario.. it almost always creates the file in Development/QA environment. (Wonder why things behave funny in Production )

Hello everyone, I tried searching for a post/topic in this forum similar to the problem I have but did not have a lot of luck. Please forgive me if I have missed anything :) Ok so, I have a job that reads data from a sequential file. It then does some lookups and transformations and then writes to a...

Thats right! Just checked it, you do not need to include "Server" in the notification Activity stage.

So I guess yes, just add your smtp server name in your relayhost parameter and update your myhostname if it is not already.

We've been having the same problem and for a long time we could not find out what the problem was. We finally got this figured out a week ago. Two things you need to do: 1) Make your dssendmail.txt look like: #! /bin/sh /usr/sbin/sendmail -t<<//// From: %from% To: %to% Subject: %subject% Server : %s...