Search found 592 matches

by JoshGeorge
Thu Mar 11, 2010 2:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel Routine to strip Non Ascii chars from a string.
Replies: 13
Views: 11253

string formnewString(string inStr, int len) { int i; for (i=0;i<len;i++) { if (!isascii(inStr[i])) { inStr[i]=' '; } } return inStr; } char* PRemoveNonAscii(char* varInStr) { int len; string t = string(varInStr); string getStr; len = t.length(); getStr=formnewString(t,len); char *OutStr =(char *) g...
by JoshGeorge
Wed Mar 10, 2010 7:35 pm
Forum: IBM QualityStage
Topic: how many tokens exist in the address field
Replies: 5
Views: 3169

Have a look at STRIPLIST and SEPLIST in the rule set you are going to use in word investigation. Any character that is in both lists separates tokens in a given string.
mallikharjuna wrote:Yes Ray you are correct. my question is "how many tokens exist in the address field"
by JoshGeorge
Sun Mar 07, 2010 5:00 am
Forum: IBM QualityStage
Topic: Best Way to Use Quality Stage
Replies: 1
Views: 1961

Re: Best Way to Use Quality Stage

Standardization is never a waist. xxPREP output : AddressDomain & AreaDomain is a fine input CASS can process. If you are not interested in doing much cleansing or standardizing, MNS is the easiest to use for pre-processing as well. I am new to Quality Stage so pardon me if I ask some dumb quest...
by JoshGeorge
Sun Mar 07, 2010 1:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel Routine to strip Non Ascii chars from a string.
Replies: 13
Views: 11253

Workaround for memory leak issue in parallel routine

Code I posted does not have any memory leak issues.
Instead of

Code: Select all

char *OutStr = &getStr[0]; 
Use

Code: Select all

char *OutStr =(char *) getStr.c_str();
which is a better / standard ways of getting a null terminated string from a string object.
by JoshGeorge
Sat Mar 06, 2010 12:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel Routine Object File
Replies: 8
Views: 8059

Need not be the same. I put the example in this blog: http://it.toolbox.com/blogs/dw-soa/datastage-parallel-routines-made-really-easy-20926 specifically to say that. Hi, The program name and the function name should match, in order to exectue that so... either rename your program name or function. e...
by JoshGeorge
Thu Mar 04, 2010 3:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel Routine to strip Non Ascii chars from a string.
Replies: 13
Views: 11253

Alternative way, read space as ascii. string formnewString(string inStr, int len) { int i; for (i=0;i<len;i++) { if (isspace(inStr[i])) { inStr[i]='+'; } } return inStr; } char* PRemoveNonAscii(char* varInStr) { int len; string t = string(varInStr); string getStr; len = t.length(); getStr=formnewStr...
by JoshGeorge
Wed Mar 03, 2010 4:53 am
Forum: IBM QualityStage
Topic: Spelling corrections in Address
Replies: 4
Views: 3012

Have you tried the MNS and then doing a refernce to the given tables? For spelling mistake correction a soundex matchig might be an easy way.
by JoshGeorge
Thu Feb 25, 2010 6:08 am
Forum: IBM QualityStage
Topic: Address Cleansing
Replies: 16
Views: 7356

Re: Address Cleansing

xxPREP will help you to separate your country addresses from others. Post this the rule sets (xxAREA & xxADDR) will help you to form the address as area domain & address domain according to the fields you have passed into the ZQ sections. Now to really check this address against your country...
by JoshGeorge
Thu Feb 04, 2010 5:03 am
Forum: IBM QualityStage
Topic: how can we standardize foreign address and names?
Replies: 5
Views: 2758

MNS - buy that accessory if you do not have.
by JoshGeorge
Thu Jan 21, 2010 8:27 pm
Forum: IBM QualityStage
Topic: QualityStage Rule Sets
Replies: 3
Views: 3131

Australian Phone Number.
http://it.toolbox.com/blogs/dw-soa/qual ... tion-37351
AU Concession Card number.
For all the checksum (ABN,ACN, QLD SC Concession Card, NMI, MIRN) validations I found parallel routines best.
by JoshGeorge
Sat Jan 09, 2010 12:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel Routine Object File
Replies: 8
Views: 8059

Put the object file in one of the 'library folders'; Provide that as lib path & recompile. That will give you an idea of what to do.
by JoshGeorge
Fri Dec 18, 2009 6:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: InstallUpdate console mode
Replies: 4
Views: 2563

Check if you have the latest 'update installer' to force re-install this latest patch.
by JoshGeorge
Fri Dec 18, 2009 2:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel routine using API
Replies: 3
Views: 2797

You missed to link the files required.
by JoshGeorge
Sun Dec 06, 2009 7:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dynamic output files
Replies: 5
Views: 3573

Datastage parallel (C++) routine to create files dynamically

Link to - Datastage parallel (C++) routine to create files dynamically for every record in single job.

http://it.toolbox.com/blogs/dw-soa/data ... ally-21095