Search found 16 matches

by dalecooper
Mon Mar 01, 2010 6:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Build Stage Job
Replies: 4
Views: 1961

ArndW what is not working? In the Build Stage it is possible to use the C function atoi to convert string to integer, but the opposite function itoa does not work. Are you assigning the string value as the return value? Syntax : char * itoa ( int value, char * str, int base ); Tried ReturnValue = it...
by dalecooper
Fri Feb 26, 2010 5:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Build Stage Job
Replies: 4
Views: 1961

Build Stage Job

Hi Does anybody know what the syntax is to convert an integer to a string in the "Build Stage". Function atoi(String to Integer) works but looks like function itoa(Integer to String) is not working. Example : IntRec = atoi(StringRec) works. I know it is possible to use other stages to do t...
by dalecooper
Tue Nov 17, 2009 10:57 am
Forum: IBM QualityStage
Topic: Matching MULT_UNCERT
Replies: 3
Views: 2476

Thank you for the feedback! I'm marking this as resolved.
by dalecooper
Wed Oct 21, 2009 1:15 pm
Forum: IBM QualityStage
Topic: Matching MULT_UNCERT
Replies: 3
Views: 2476

Matching MULT_UNCERT

Hi Unduplicate match used. I have the following blocking column: MatchPrimaryWord1NYSIIS : PALY And the follwing match command: MULT_UNCERT on field MatField1 0.9 0.1 900 It matches the following records in the MatField1: SUBRAYAN PILLAY SOOBRAMONEY PILLAY The output I need is for QS to only match r...
by dalecooper
Thu Jun 18, 2009 7:22 am
Forum: IBM QualityStage
Topic: Match-Specification Update Issue
Replies: 3
Views: 1597

Are you using DB2 as the repository? If so, add regular table spaces to your database, add buffer sizes 4,8,16 and 32. Cannot say this will be solve the problem but I had a similar issue a while back. No, I do not think you need to restart the server. Check if you have read/write access to where the...
by dalecooper
Thu Jun 18, 2009 7:16 am
Forum: IBM QualityStage
Topic: Blocking
Replies: 3
Views: 1938

Thanks again Julio!
by dalecooper
Thu Jun 18, 2009 2:06 am
Forum: IBM QualityStage
Topic: Match-Specification Update Issue
Replies: 3
Views: 1597

If I remember correctly there is a generate OSH setting on project level using the Admin Shortcut. Enable that.
Go back to where the error is and rerun. You should be able to see more detail on the error.
by dalecooper
Thu Jun 18, 2009 2:03 am
Forum: IBM QualityStage
Topic: Blocking
Replies: 3
Views: 1938

Blocking

Hi Another Matching question: Looks like it is not a good idea to block on null columns? Example: MatchColumn1 MatchColumn2 CompName B CompName CompName C The above result will be that no blocking is done. The only way to get it matched is using the following: Block on MatchColumn1 and do the matchi...
by dalecooper
Wed Jun 17, 2009 11:32 am
Forum: IBM QualityStage
Topic: Matching Question
Replies: 10
Views: 4949

Well, thanks for all the information.
I'm sure from here I will able to manage the changes on my side!

Your help Julio/Ray is much appreciated.
by dalecooper
Wed Jun 17, 2009 5:33 am
Forum: IBM QualityStage
Topic: Matching Question
Replies: 10
Views: 4949

Thanks Ray for the information. Where can I find what each of the following means and how to set it up? Replace/Add Radio buttons. Agreement Weight[AW] Disagreement Weight[DW] Data Source Missing Weight[AM] Reference Source Missing Weight[BM] Both Missing Weight[XM] Conditional Source Value[AV] Cond...
by dalecooper
Wed Jun 17, 2009 12:11 am
Forum: IBM QualityStage
Topic: Matching Question
Replies: 10
Views: 4949

Hi Julio Thank you again for the help! I have tried this and it works, however don't you think it will also be possible to modify the "Weight Overrides" and add a value to the "AddedColum" to ensure that if the data agrees/ do not agree then it should put it in different blocks? ...
by dalecooper
Sun Jun 14, 2009 11:00 pm
Forum: IBM QualityStage
Topic: Matching Question
Replies: 10
Views: 4949

Re: Matching Question

Hi Julio Thanks for the reply! Unfortunately it does not work on my side. The closest I get to the desired results is not to have AddedColumn in the blocking but to include it in the match specification, UNCERT 900, 0.9 and 0.1. Critical Missing OK For this example I have standardized the CompanyNam...
by dalecooper
Fri Jan 09, 2009 1:35 am
Forum: IBM QualityStage
Topic: QualityStage and DB2
Replies: 3
Views: 1966

Hi Ray

Thank you for the info.
Last question:
When you do a matching specification job you setup the testing environment, it is then possible to connect to the other database?

Thanks
Dale
by dalecooper
Fri Jan 09, 2009 1:00 am
Forum: IBM QualityStage
Topic: QualityStage and DB2
Replies: 3
Views: 1966

QualityStage and DB2

Hi All

Do you have to have DB2 installed to be able to use QualityStage 8.x ?
I assume DB2 is used for matching etc.

Thanks
Dale
by dalecooper
Mon Sep 15, 2008 5:52 am
Forum: IBM QualityStage
Topic: QS : Unable to delete the item(s) message
Replies: 0
Views: 1524

QS : Unable to delete the item(s) message

Hi All Has anyone seen this message before? How to fix? 1) Copied a rule set. 2) Renamed the rule set. 3) Tried to delete the copied rule set but get this message: Unable to delete the item(s) Could not load Ruleset ... .SET Could not load object .... .FPO [The field pattern override ... cannot be f...