DSXchange

Hi Ray, When you refer "table called JCL_TEMPLATES in the Repository", what repository is this? Access (.mdb) that suports QS? The QS 7.0 doesn't have a Manager client. It only has a Designer on the client side, nothing else!!! In the server manual, it says that the JCL is generated in the...

If we look to the .pat wich is use to correct an address we will find a long list of patterns to correct every known case. And when it's not quite right, because there is another character missplaced, the only way to correct it is join another pat rule. Until exhaustion!!! If the Data Quality tool g...

Hi, Every tools have limitations. The most important, in my opinion, is that they don't learn with the mistakes they correct. And we need to be on top of the problem to resolve new issues. A data quality tool should learn with the input data to solve the problem by her self. How? The input should be...

Hi, When I look to that error messages, it look like your are running a STAN operation? Correct? Try to deploy only, and look to the files wich have the definition of the operation you are running, and see if is something missing. It seems the file with the operation definition sent to the remote ma...

Your output file is adding a position for each line? like this:
aaaa
bbb
b cc
cc dd

You are having a problem with carriage return and line feed at the end of wich line. It's common when you pass files from Windows to UNIX. Check your ftp option when passing files between these environments.

I don't understand what's you are trying to solve. In QS, the blocking fields are fixed, they don't change dinamic. What you define in the developer, is what you get in the execution. The only way is to create a Match stage with n steps and n Blocking fields, that will be fill in DS using different ...

In my opinion, the weights based on the frequency distribuitions should only be used on fields with well known values, not over fields wich accept free text, because the frequency tables will not cover all the range, and the result can fall into extreme situations. If you assign weight to every fiel...

You can use a DCT field to store a value which time a pattern is used.

But to achive this you will need to change your pattern file.

At the end, the DCT field will have a value match to the pattern that treat which record. If its empty, no pattern had match.

The final weight when QS compares two records is the sum of every weight given in matching phase for every field. Usually, I define the output weight field with 7 positions. So it can suport eg: from "-999.99" to "+999.99". To simulate a % comparision, you can use override weight...

Hi, You should check your file again, here is a bunch of questions a make when that happens in my jobs. - Have you check every line len in your input file? - Is the same len in QS file definition? - In Windows every line have a carriage return at end. So you must have an empty line at the bottom of ...

Hi.

I don't have acess to QS.

But, if it's not working. You can try another aproach.

Copy the dictionary field content to a variable and test it instead.

I think this will return you the result you want.

You can't call a Unix routine from pattern action language in QS.

But it's possible to run a unix script from QS using the Program Stage,
which has a command line parameter. This comand line will be execute in the UNIX environment.

My first impression tells me that's around the blocking keys you have defined. It look's like you have chosen a blocking key that will contains an enormous amount of records in one pass. So, during execution QS will be using thousands of records in the match phase. I'm not sure if this will solve th...

Hi, I recgonize that function, it's to validate a checkdigit of somekind. In QS there isn't any easy way to do it, you could use a Ruleset but will give you a lot of headache, using 2 TBL files with two arithmetic + and *. I advise you to implement it in another language wich you could invoke from P...

Hi,

I don't use arithmetic expression in a ruleset along time ago.

Last time I do it, i used a TBL file with the arithmethic table:
1x1 1
...
4x5 20
...
9x9 81

then put var1xvar2 in one variable and convert it using TBL file.