DSXchange

Yay, thanks to Dennis I now have my account reactivated so I can finally read all of the content posted in your replies. Unfortunately it does appear that we'll have to touch every job where we do a comparison between varchar fields. I agree, the compare is much better self-documenting. The append o...

Thanks to both of you for your input. I have proved out that DS is definitely doing an implicit conversion of the varchar fields when it is comparing two values that only contain numbers (because it is saying zipcode 01234 = 1234, which would be true if these were 2 number fields, but NOT for varcha...

DataStage will perform an implicit conversion from a string to a number and vice-versa. We have database fields that are defined as varchar and may contain only numbers (for example, a US zip code). In these cases, it's important that the data be treated as varchar and not as numbers when doing fiel...

Hi Craig:

Nothing has changed in the code base.

I'd definitely prefer to have the behavior you've seen then what we saw!

Thanks,
Pam

Hi everyone: We encountered the following problem with DataStage and particularly with KBA Job Control and we are trying to determine root cause so that we can prevent this from happening again. KBA Job Control batches saw jobs as completed normal when DataStage hadn't even run the job. Thus we had ...

Thanks, that was exactly what I was looking for! (and such a quick response).

Cheerio!
Pam

Hi all: We have some .trace files sitting around (some for over 2 years) in our projects directory (in &PH&). I'm wondering if I can delete these once we're done with them, and if so, what is the best way? Do they need to be deleted through DataStage administrator (if so, how)? Or can they j...

After approx 5 hours, I was successfully able to restart the qsrtmngr without issue. I had done nothing in between. Perhaps there was some non-obvious process running that died on it's own in between, similar to what happened as documented in this post: http://www.dsxchange.com/viewtopic.php?t=98208...

When starting QualityStage we normally run the following 2 commands (from the QS bin directory): nohup ./qsserv & nohup ./qsrtmngr & Unfortunately, this time, qsserv is starting fine, but we're getting the following for qsrtmngr: [1]+ Exit 17 nohup ./qsrtmngr Has anyone else ever encountered...

Additional information: This is only when using both agreement and disagreement weights, and applies to any multiple override weights. It appears that the first override weight is the only one applied. This is contradictory to the manual which seems to indicate that you can apply more than one type ...

I cannot seem to make disagreement weights work. Is anyone else having this trouble? Here's the situation: I'm using a specific data set with some fields that agree and others that disagree. If I change the agreement weight, AW (add or replace), then I can see the aggregate weight for the row change...

I have a single address field that contains name (both people and institution) and address information. For instance "JERRIA SMITH 123 MAIN" and "JILLIES STATE CARE CENTER P O BOX 123". I would like to pre-process this field (using USPREP?), but the delimiters aren't working very...

Thanks for the input. I think I'm going to have to do something like this, hopefully not too much more complex.

Hi: I've got addresses such as 1525 CR 10 and 1525 KELTY CR. Any suggestion how to make QualityStage see the first as 1525 COUNTY ROAD 10 and the second as 1525 KELTY CIR? Out of the box functionality does the first correctly, but causes the second to become 1525 KELTY COUNT (COUNTY ROAD is truncate...

I tried checking "Allow multiple instances" in the job that is called by other jobs. However, when two jobs call my shared job, one will fail while the other is accessing the shared job. The shared job is fully parameterized so that no source files, hash files or target files are overwritt...