DSXchange

have you tried TAB delimiter?

My xmeta reposity password was expired. I change the password now and able to login to xmeta using xmeta user and new password . Still am not able to restart WAS.Below is the log in systemout . Could anyone help me? Did you make sure that the new password of xmeta is same password you used when you...

Hi Kalpana,
No. you can only use trimleadingtrailing for varchar if I am not mistaken.. since your target DB2 column is integer as you mentioned earlier and your source is varchar.. try converting the varchar to Int and try loading again.

Easy Solution using 2 jobs: Job 1: Read the input file, process you data and write the Header Row in File1. Job 2: Read the input file and use Aggregator stage using count rows for key column. This will give you total number of rows for every group (in your case emp_id). Now write this into File1 cr...

Hi Kalpana, The data is loading properly in DataSet but not in DB2 table. It will work in Dataset when you copy the input link into dataset output link in which case both will have the same datatype as bigint. Maybe you are trying to push the BigInt datatype into Int column in DB2. Check it and let ...

Use the following:
TrimF(Convert(",", "", InputLink.Column))

Very easy solution: Step1: Use SORT stage to sort data on key column and make sure to use Create Key Change Column = True. Step2: Use a Transformer and in first output link Constraint say InputColumn.keyChange=1 and in second output link Constraint say InputColumn.keyChange=0. Now you will have Two ...

Hi Swapnil
You have to have the site number or valid partner world id to download.

Wow.. finally.. I am going to download it and try installing it on suSE 10

my bad Chulett.. You are correct. It will be mv instead of rm. So the new value will be like mv /tmp/SeqFile01 /tmp/SeqFile01_`date +%F`

By the way the macro formatting is universal as yyyy-mm-dd

This error usually happens when your dsenv file values are wrong. Please check your 7.5.2 dsenv and make sure it is pointing to the correct and valid oracle_home and you are exporting the correct TNS_ADMIN value.

I guess you can use After-job subroutine and use ExecSH and rename the seq file using rm and adding the current date value like "rm /tmp/SeqFile01_`date +%F` or you can directly use the DSMacro (without using job parameter) DSJobStartDate in the file name field as #DSJobStartDate#. So you will ...

Hi, I would use a combination of Stage Variable and Constraint to handle this issue. First define a Stage Variable as follows: AlNumCheck=Left(AlNum(InputColumn), 1). This is going to return a True/False (1 for true and 0 for false) indicator if the first value is AlphaNumeric or not. Second use the...