DSXchange

I figured it out. I did a lot of changes, and I do not know what exactly makes the difference. I reformatted both file A and file B, adjusted the datafile definition in QS designer, and adjusted the UNIX folder's user access privilege. In my system, the QS server and my work folder are on different ...

if prm = prxmatch("/([^a-zA-Z \-0-9\']+)/", aRow);
no prm >0.

Please keep helping.

I still do not know if I need to put file ending or line ending char at related place.

Thanks so much.

In the userguid on my computer, I read this: In general, input files must be fixed-length files with an end-of-record terminating character, and they must contain alphanumeric data. 1) How to have a "end-of-record terminating character"? I put "\n", it gives and extra '\' at the ...

First I thank so much Ray and Julio for replying my previous question. I am doing the match to see what happen. I get an error related to one of the input file. Another file is not mentioned in error log. Experts please help again. 1) in sas program, I created the text file from a sas dataset as fol...

Hi Experts, I have a very large file A (>20 MG rows) match to another large file B (about 10 GB rows). I use QualityStage 7.0 designer. In one of the passes, I bad better to block on: last name, first name, and Birth Year. In file B, the block has good number of records (<20). But in file A, there a...

Thanks Ray.
Now I am comfortable with the u-prob and m-prob.

FileA and FileB have the first 4 lines the same values: name Address City State Zip ------------------------------------------------------------------------------ PAUL CHAPMAN 15 Filbert Street Oakland CA 94607 PAUL CHAPMAN 5555 Filbert Street Oakland CA 94607 PAUL ABCDEFG 155 Filbert Street Oakland...

Thanks stuartjvnorton & tcj for your replyings. I find the file sg247546.pdf "IBM WebSphere QualityStage Methodologies, Standardization, and Matching". It is a good book. Is it the book you both mentioned? From the UserQuide, I have learned the comcepts. I like to create a QS process. ...

I am reading the document "Designer User Guide" and "Getting Started" from IBM. I helps. I can go through the stages. But I do not satisfy the efficience. Could you please introduce your successful learning experience with better book/document/samples? I am going to collect data ...

I find the problem. My solution is to copy the gs000000 to the Data folder, and rename it to GS000000. It is case sensitive! The QS server writes the file to the folder specified in the profile. The read/write privilege is a big issue when run the process.

I am new on IBM QualityStage, v 7.0.1. build 11. My QualityStage server is on SUN. client on XP. the "Local Report Data Location" is a sub-folder in the "Master Project Directory" which is on UNIX, a mapped folder in my windows XP. in Advanced Project Setting, I use the default s...