DSXchange

Hi, I am curious to know whether anyone installed IIS 8.0.1 software on Linux 64 bit operating system sucessfully ? IBM supports only in 32 bit mode. But I was told that we can install in 64 bit OS by pointing to the 32 bit libraries the only hitch is IBM will not support in case of any issues. I wo...

I had the same problem in one of my jobs. I resolved it initially in a roundabout way by calculating the length by using Index function on first space to get the length of the string and then moving (1, length) to the output field. Later I found that if you define your field as VarChar in all the st...

Hi Pranav,

Did you resolved this issue ? I have same problem in my project and would like to know how you resolved this. Did you acquired ODBC driver for Excel ? Could you please let me know ?

Thanks,

Aruna.

Hi, I too received this SIGSEV error message. So for I found it in two different scenario. 1. One is due to file system error. Either segmentation error or may not able to handle large volume size. Some time this will occur in the lookupstages.. Sol: Change the jobs to use Join Stage or Merge Stage...

Trim your input and check for NULL before concatenating. See if it helps Hi Narasimha, I tried with Trim too. It didn't worked. Is there any specific trim function I should be using ? I tried 'Trim' and 'TrimLeadingTrailing' and both didn't work. Try using ltrim and rtrim for eg. ltrim(rtrim(stgFNa...

Just noticed this in the original post. Which suggests to me that the other job was a server job. Hi, The job which worked is a parallel job. But the Input Sequential file is coming from a server job. Does that make any difference ? Hi, I don't think so, any problem with sequentail file. Debug your...

This kind of concatenation worked with numeric fields in another job. :? Just noticed this in the original post. Which suggests to me that the other job was a server job. Hi, The job which worked is a parallel job. But the Input Sequential file is coming from a server job. Does that make any differ...

How are you asking for the length to be reported? Create more output columns - define their derivations to use the Len() function. Is the output file fixed-width format? If so, the fields will always be padded to length. Yes. The output file is fixed width format. That explains why I am getting the...

Nothing should be in quotes. Create another output link from the Transformer stage containing the values from the stage variables and the value from the derivation. Run this into, say, a Peek stage; inspect the results and diagnose. You may discover (for example) that LastName is truly empty in som...

[quote="narasimha"]Lets get some more details here. What is your source? (File, DB,...) Also can you post the exact derivation you have used for your Stage Variables. My source is output from FTP_Plugin from a Windows Server ( Excel Spread sheet). How do I attach the screen shot here ? Or ...

[quote="narasimha"]Trim your input and check for NULL before concatenating. See if it helps

Hi Narasimha, I tried with Trim too. It didn't worked. Is there any specific trim function I should be using ? I tried 'Trim' and 'TrimLeadingTrailing' and both didn't work.

narasimha wrote:How are you concatenating the fields?
Try Firstname:Lastname

That is what I am trying. I am deriving the fullname by 'Svfirstname : Svlastname' and still getting only first name in the fullname field. All the stage variables are defined as varchar.

I am trying to take firstname and lastname fields and concatenate into a fullname in a transform stage and getting only firstname in fullname field. What am I missing here. I defined these are stage variables and deriving fullname stage variable. This kind of concatenation worked with numeric fields...

Brad, any tip on how I can "move" this to the Parallel forum? Thanks! What criteria would cause a record to be rejected? As for duplicates, you should be able to identify those before loading to your target table. If the duplicate exists in the input data, then dedup the input stream using...

Yes, we have the Enterprise Stage on our palette. However, we cannot access our DB2 database using it (we have been able to successfully access our DB2 database using the DB2 API stage). We've been told the reason we can't use the DB2 Enterprise stage is because we have different OS versions between...