Search found 42 matches
- Wed Oct 08, 2014 5:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: PxEreplace routine issue when calling through datastage
- Replies: 11
- Views: 13259
- Wed Oct 08, 2014 1:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: PxEreplace routine issue when calling through datastage
- Replies: 11
- Views: 13259
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 ...
- Wed Jul 23, 2014 5:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Bigdata stage
- Replies: 0
- Views: 1739
Bigdata stage
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.
I think we can use java transformer/java client stage as cassandra support java.
- Mon May 12, 2014 12:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Bulk load in db2
- Replies: 6
- Views: 5939
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...
- Sat May 10, 2014 4:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Bulk load in db2
- Replies: 6
- Views: 5939
Bulk load in db2
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...
- Mon Feb 17, 2014 4:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CFF stage not reading the special character correctly
- Replies: 3
- Views: 3691
Re: CFF Stage
Thanks,
Can i please know what value you have given for the APT_EBCDIC_VERSION?
Can i please know what value you have given for the APT_EBCDIC_VERSION?
- Fri Feb 14, 2014 9:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: CFF stage not reading the special character correctly
- Replies: 3
- Views: 3691
CFF stage not reading the special character correctly
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...
- Thu Dec 26, 2013 1:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generate Row Number Field with multiple partition not workin
- Replies: 2
- Views: 4719
- Wed Dec 25, 2013 9:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generate Row Number Field with multiple partition not workin
- Replies: 2
- Views: 4719
Generate Row Number Field with multiple partition not workin
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...
- Tue Dec 24, 2013 3:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Grid compute node
- Replies: 7
- Views: 6919
Re: Grid compute node
Hi All,
Did you found the answer... even i have same question why we use for second value?
Did you found the answer... even i have same question why we use for second value?
- Wed Nov 27, 2013 6:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer: No input sort key information found
- Replies: 2
- Views: 3412
- Wed Nov 27, 2013 2:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformer: No input sort key information found
- Replies: 2
- Views: 3412
Transformer: No input sort key information found
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...
- Tue Oct 15, 2013 9:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error message about field not found
- Replies: 7
- Views: 5921
- Wed Oct 09, 2013 6:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQ stage Reject Link
- Replies: 6
- Views: 3033
- Wed Oct 09, 2013 2:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQ stage Reject Link
- Replies: 6
- Views: 3033