Search found 524 matches

by stuartjvnorton
Mon Apr 07, 2008 6:53 pm
Forum: IBM QualityStage
Topic: Invalid Lookup Table Names
Replies: 3
Views: 2665

Does this non-existent file show up in the repository tree? If so, you might have a few problems getting rid of it. You could try to provision the PAT file by itself, to see if that flushes the reference out, making it easier to provision the whole ruleset. Otherwise, you could export the entire rul...
by stuartjvnorton
Mon Apr 07, 2008 6:26 pm
Forum: IBM QualityStage
Topic: CONVERT Error
Replies: 4
Views: 2992

Re: CONVERT Error

mdemerick@dow.com wrote: Instead, I get an error:

"Standardization process failed.(Invalid entry in convert tbl
Error occured on line 50 of file ... SIZE.PAT
Offending convert tbl line: AMP
Do you have AMP listed twice in the lookup table?
by stuartjvnorton
Mon Apr 07, 2008 6:17 pm
Forum: IBM QualityStage
Topic: Increasing the number of tokens
Replies: 2
Views: 2578

Re: Increasing the number of tokens

This should be an easy one for most of you. Unfortunately, it's not mentioned in the documentation. I have a pattern with one recognized token. It is a mix of numbers followed by letters. I know I can separate them using (n) and (-c), but I need to get them into their own tokens for further process...
by stuartjvnorton
Mon Apr 07, 2008 5:32 pm
Forum: IBM QualityStage
Topic: Debugging QualityStage
Replies: 2
Views: 2786

Re: Debugging QualityStage

Is there any way to really debug QuailtyStage? Specifically for the rule sets. You can't step through a ruleset (Wouldn't that be nice! Anyone from IBM listening?), but you can write your own trace code into the ruleset itself. Not hard to do, but pretty time-consuming depending on what you want. M...
by stuartjvnorton
Fri Dec 28, 2007 12:24 am
Forum: General
Topic: Oracle Connection Sharing Issue?
Replies: 1
Views: 1753

Oracle Connection Sharing Issue?

Hi all, Is there there an issue with DS Designer holding some sort of exclusive lock on a database connection object? This might be a hard one to explain, but here goes... Take 2 users (A and B). - A user (A or B: doesn't matter who creates it) creates a database connection (Oracle data access [PxOr...
by stuartjvnorton
Wed Dec 19, 2007 5:04 pm
Forum: Data Quality Best Practices
Topic: Quality Stage v8 versus v7.5
Replies: 5
Views: 20547

If you have done much work with DS 7.5, then you could probably get by without the QS V8 course as far as everyday usage goes. V8 is now more like DS but with a few new kinds of operation that let you do the stan, match, parse, etc. That's of course if you know QS 7.5 and want to move to 8. If you k...
by stuartjvnorton
Mon Nov 19, 2007 5:19 pm
Forum: IBM QualityStage
Topic: Dynamically setting investigation ruleset?
Replies: 1
Views: 1664

Dynamically setting investigation ruleset?

Hi all, Is there any way at run-time to tell an investigate stage which ruleset it should use? I am trying to put together a process for some data-driven some word investigation: get a list of columns to be investigated from a table and loop through them, setting the ruleset for each one. Can this b...
by stuartjvnorton
Tue Nov 13, 2007 12:14 am
Forum: IBM QualityStage
Topic: QS v8 ruleset issue
Replies: 3
Views: 2625

A quick note to those new to version 8 (myself included): if you make changes to a ruleset and they don't seem to get picked up after you save and close the ruleset dialog, select the ruleset objects in the repository explorer window, right-click and Provision All... Worked like a charm where nothin...
by stuartjvnorton
Fri Nov 09, 2007 12:46 am
Forum: IBM QualityStage
Topic: QS v8 ruleset issue
Replies: 3
Views: 2625

QS v8 ruleset issue

Hi all, I've copied an existing ruleset and made some mods, including changing some of the fields in the DCT & PAT files. Now I get this when I try to use it in a standardize stage: STAN_Email__URL: When checking operator: The modify operator keeps field "EmailAddress_VEMAIL2" which is...
by stuartjvnorton
Fri Sep 14, 2007 12:16 am
Forum: IBM QualityStage
Topic: Trying to add an override
Replies: 5
Views: 3540

^|-|^|^|/|^|||||+|T|$

Sure you're not missing a few tokens here (between all of the consecutive pipes I bolded)?
Maybe a "vacuous operand" means it reckons you forgot some tokens in your pattern.
by stuartjvnorton
Wed Aug 22, 2007 10:31 pm
Forum: IBM QualityStage
Topic: PAT file FAQ?
Replies: 4
Views: 2916

Sorry Ray, can't read most of that reply.
I guess what I'm specifically talking about is things like engine bugs.

I've hit one where the value in a destination field becomes prefixed to [2] of the following pattern. Problematic, to say the least.
by stuartjvnorton
Wed Aug 22, 2007 1:19 am
Forum: IBM QualityStage
Topic: PAT file FAQ?
Replies: 4
Views: 2916

PAT file FAQ?

Hi all,

Does anyone know of an FAQ or reference guide for PAT files other than the PDF that comes with the client install?
The lack of support documentation is really starting to annoy me...
by stuartjvnorton
Sun Jul 29, 2007 8:39 pm
Forum: IBM QualityStage
Topic: Address parsing questions
Replies: 5
Views: 3364

ray.wurlod wrote:Is it really Avenue, or is it Apt (Apartment)? That it is followed by a 1 (which you're putting in UV1) suggests the latter. Perhaps this particular A (in this particular pattern) needs to go into U ...
abc123, my stuff will do what you ask, but Ray's got a darn good point here...
by stuartjvnorton
Thu Jul 26, 2007 11:56 pm
Forum: IBM QualityStage
Topic: Address parsing questions
Replies: 5
Views: 3364

But how would you tell QS this: "Interpret A as Ave in this situation"? Putting something like this in the PAT file would do specifically what you asked: ^ | + | I="A" | ^ | $ copy [1] {HN1} copy [2] {SN1} copy "AVE" {ST1} copy [4] {UV1} retype [1] 0 retype [2] 0 retyp...