DSXchange

Hi Kool,

Also double check whether it is present under either Favorites or Processing groups in the pallette. It can be in either group depending upon your preferences.

Thanks,
Naveen

Sorry Guys, its my mistake. I was trying to attach the complete job logs of the individual jobs in my email as attachments. I just now realized that JobStatus parameter returns the return code and not the job log. If I want to include the job logs of the individual jobs as attachments instead of inl...

Hi Guys, I have a simple sequencer job that runs two jobs one after another and then sends an email after completion of the jobs. I tried to attach the job status of the two jobs in the email. When I get the email, I am getting an warning as shown below in the email. I selected the job status parame...

Hi Naveen,

You can use the remote copy UNIX command (rcp) in a shell script and use the "ExecSH" as a before job subroutine.

Thanks,
Naveen

Hi Deepak, Does any one knows if i can run the job from a particular row so that i can see if it is data problem or not? You can put a transformer stage before writing to hash file and in the transformer have a constraint like @INROWNUM >= 3100000, so that it will not write the first 3100000 values ...

2.i need to compare fields in a sequential stage and fields in a hash file stage Hi Anu, To compare fields in a sequential stage and a hash file stage, Wouldnt it be easy to use the hash file as the lookup and the records from your input sequential file as the stream input. In fact the primary use ...

Hi Titto, Try using the below conversion Susbstrings((TrimB(String),1,28)) The problem with what you are doing is that you are first extracting the subtstring and then trimming the space. Whereas to get a match, you need to first trim the spaces and then extract your substring. Hope this solves your...

Hi,

Try declaring D=valA\valB\valC instead of D=$A\$B\$C in your Datastage Administrator.

Thats should take care of your problem.

Thanks,
Naveen

Hi Vinay,

I just tried the Exchange in a sample server job and it worked fine for me. Its very strange that it is not working for you.

Thanks,
Naveen

Hi, Have you included the Environment Variables that you want to use in the job, in the parameters tab of the Job Properties? If not, you can insert the Environment Variables that you defined using adminstrator, by clicking on Add Environment Variable button on the bottom right and picking the varia...

Hi amsh,

Its true that it will be hard to debug and maintain. But that's the price to improve your performance. So, you need to decide the design of your job, based on which factors are more important to you.


Thanks,
Naveen

Hi Vinay,

I think you should have no problem using ' character in the format tab, when you write to the flat file.

Thanks,
Naveen

Hi Vinay, Hey , I am also using quote ' instead of " for the both the flat files , will it be a problem . Your question is ambiguous. 1) If your question meant "Will it work if I want to replace ' quote with space?" - No it will not work as the hex code for ' is different from " ...

Hi Vinay,

Yes, It should replace all the occurences.

Thanks,
Naveen

Hi Vinay, You can use the Exchange function that accepts hex characters as the string to replace, string to be replaced Exchange(INPUTLINK.COLA,"22","20") where 22 is the Hex equivalent of " and 20 is the Hex equivalent of space Make sure you replace INPUTLINK.COLA with the ...