Done, link updated in the first post of the main thread. Dropbox changed the way public shared files worked, it's now on Google Drive. If anyone has a better place to host it, please feel free to "mirror" it and I will include a link in my post.rohitash_saini wrote:Can you please share this spreadsheet ?
Search found 1028 matches
- Thu May 09, 2019 5:36 pm
- Forum: Enhancement Wish List
- Topic: Automated Code review/check
- Replies: 11
- Views: 69836
Re: DataStage Analysis spreadsheet
- Tue Feb 24, 2015 9:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel Routine
- Replies: 9
- Views: 10575
The code in the OP contains a memory leak. It is allocating memory with the new operator, and that memory never gets freed. How to fix this? Sorry, not possible. At present it is impossible to write string functions that do not have memory leaks or thread safety issues. IBM should implement a parall...
- Tue Nov 19, 2013 7:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need Help To implement pxEreplace()
- Replies: 9
- Views: 7679
pxEreplace is a bad idea. It is impossible to implement a string replacement function in DataStage without introducing either contention or a memory leak*. Sorry. What IBM desperately need to do is to allow std::string parameters (and return type) for parallel routines. That is, after all, precisely...
- Thu Nov 15, 2012 8:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential file "delimiter not seen" error
- Replies: 15
- Views: 26091
- Mon Nov 12, 2012 4:56 am
- Forum: Site/Forum
- Topic: 40k+ users
- Replies: 18
- Views: 28124
- Wed Nov 07, 2012 7:40 am
- Forum: General
- Topic: Copyright Violation
- Replies: 10
- Views: 5699
According to whois, their web host is IXWEBHOSTING.COM so maybe you should contact them. Their IP address is owned by United States Columbus Ecommerce Corporation (ecommerce.com) so maybe abuse@ecommerce.com is an option.
- Wed Nov 07, 2012 7:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replacing a string with another string
- Replies: 13
- Views: 18700
Re: Replacing a string with another string
That will convert the third parameter replacing 'K' -> 'C', 'o's -> 'a', 'k' -> 'c', 'a' -> 'u', etc., and removing all 'M', 'u', 'm' and 'i' characters. Not exactly what the OP wanted.saidvs wrote:try this
Convert('KolkataMumai','Calcutta','Kolkata') it works in parallel transformer too..
- Tue Nov 06, 2012 3:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel routine appears to have a memory leak
- Replies: 18
- Views: 14856
The problem is, you can't pass in a char*. DataStage can pass in a char* but I, as a DataStage user, can only pass in a Stage Variable or a string literal. DataStage will somehow construct a char array and pass a pointer to that, but as far as I know it is unsafe for the function to write to that ar...
- Mon Nov 05, 2012 10:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel routine appears to have a memory leak
- Replies: 18
- Views: 14856
- Mon Nov 05, 2012 8:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel routine appears to have a memory leak
- Replies: 18
- Views: 14856
IBM have finally given a sensible response. Good Morning, I did some further research and found some more information: It would seem that there is no way to free the memory that is allocated in a C transform routine. You should not use malloc in a transform routine. We suggest that if you have a com...
- Mon Nov 05, 2012 7:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replacing a string with another string
- Replies: 13
- Views: 18700
Sadly I must advise that you DO NOT use the pxEreplace function. This is from IBM support: Good Morning, I did some further research and found some more information: It would seem that there is no way to free the memory that is allocated in a C transform routine. You should not use malloc in a trans...
- Thu Oct 25, 2012 2:09 am
- Forum: General
- Topic: Test Routine, infinite loop
- Replies: 6
- Views: 5615
- Mon Oct 08, 2012 10:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: left outer join and where caluse
- Replies: 6
- Views: 4534
Re: left outer join and where caluse
Target result should be col1 col2 col3 105 500 506 105 101 201 Why should this be the output? What's the rule that rejects the second row? At a guess, I'd be tempted to say "where col2<>b_col2 or (col2=b_col2 and col3=b_col3)", is that it? In english, "if Col2 matches then Col3 has t...
- Mon Oct 08, 2012 9:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Vertical Pivot without any grouping column
- Replies: 3
- Views: 3695
- Fri Oct 05, 2012 5:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: instr in datastage
- Replies: 5
- Views: 6214