DSXchange

Thanks a lot...It worked for me 8) Issue is with the below code Code: if (strstr(&str , subStr) == &str ) { count++; i += oldlen - 1; if (count == beg) {break;} } I changed it to this: Code: if (strstr(&str , subStr) == &str ) { count++; if (count == beg) {break;} i += oldlen - 1; }

Thanks for the code. substring replace is working when the substring is present in middle of the string.but its not working when it is the starting word of the string. Example: Replace substring which is in middle of the string Source before replace: ETL is good tool Doing replace good to very good ...

I am aware that in datastage v9.1 we have a stage with will support Hadoop for big data...Just wondering do we have any such stage to support cassandra bigdata tool....If not any work around there?...

I think we can use java transformer/java client stage as cassandra support java.

Yes iam using DB2 Connector stage...I couldnt see in error that says acces or permission denied the error says broken pipeline....actually we do truncate and bulk loak so takes some 1 min to truncate after that within few seconds we are getting this error and not moving further but job is not aborti...

Hi Datastager, While iam trying to do bulk load in db2 which is installed on z/os. I have set Bulk load to db2 on z/os =yes Load method =mvs dataset While running the job iam getting the following error. Db_Grouping,0: Write failed with error 32: Broken pipe (CC_DB2Utils::writeToPipe, file CC_DB2Uti...

Thanks,

Can i please know what value you have given for the APT_EBCDIC_VERSION?

Hi, We are reading binary file with fixed width in Complex flat file stage. For a particular field which is defined as character datatype we will get values from input like below Russia! London! but when we view the data through CFF the values is showing like below Russia] London] Can you please let...

I use hash partition...so oly round robin will guarantee the equal distribution....

Hi All, I use the following formula to generate the row number in sequence by using transformer stage with 2 partition. (@INROWNUM - 1) * @NUMPARTITIONS + @PARTITIONNUM + 1 Say i have 100 record coming from input.up to 70 record the numer coming in sequence like below 1 2 3 4 . . . 70 but after 70 i...

Hi All,
Did you found the answer... even i have same question why we use for second value?

Thanks....Not sort is done before being input to the job...even in the same job the sort stage is inserted before transformer 2 it works but not when it removed from there and inserted in transformer1 with the same key sorted.

Hi Experts, My job design is as follow DS-->Transformer1-->Transformer2--->Sequential file. In transformer2 I am using SaveInputRecord;LastRowInGroup(input-column) functions. Now the problem is if i use sort stage before Tranformer2 for the inputkey column mentioned in LastRowInGroup function job wo...

Hi,

Did you got the solution for the issue?..I getting the same error..

Thanks...but dono whats is the use option in constraints for connection failure...I assumed its for MQ server connection failed..In that case it should work..

Thanks...But i want to know why reject link is not working even when reject condition set as below..Any other property setting am i missing here?
1)Connection failure
2)reject failure etc...