Search found 15 matches
- Thu Jul 25, 2013 12:28 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage internal/implicit conversion of string to number
- Replies: 7
- Views: 12623
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...
- Wed Jul 24, 2013 1:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage internal/implicit conversion of string to number
- Replies: 7
- Views: 12623
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...
- Wed Jul 24, 2013 9:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage internal/implicit conversion of string to number
- Replies: 7
- Views: 12623
DataStage internal/implicit conversion of string to number
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...
- Sun Feb 19, 2012 9:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: KBA Job Control and code=-14
- Replies: 4
- Views: 3287
- Fri Feb 17, 2012 1:46 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: KBA Job Control and code=-14
- Replies: 4
- Views: 3287
KBA Job Control and code=-14
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 ...
- Fri May 28, 2010 8:24 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Deleting trace files
- Replies: 5
- Views: 3064
- Fri May 28, 2010 2:19 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Deleting trace files
- Replies: 5
- Views: 3064
Deleting trace files
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...
- Mon Oct 19, 2009 6:47 am
- Forum: IBM QualityStage
- Topic: Exit 17 when trying to start qsrtmngr
- Replies: 2
- Views: 2290
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...
- Fri Oct 16, 2009 5:34 pm
- Forum: IBM QualityStage
- Topic: Exit 17 when trying to start qsrtmngr
- Replies: 2
- Views: 2290
Exit 17 when trying to start qsrtmngr
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...
- Mon Sep 15, 2008 9:53 pm
- Forum: IBM QualityStage
- Topic: Disagreement weights not "working"
- Replies: 1
- Views: 1579
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 ...
- Mon Sep 15, 2008 10:08 am
- Forum: IBM QualityStage
- Topic: Disagreement weights not "working"
- Replies: 1
- Views: 1579
Disagreement weights not "working"
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...
- Fri Sep 02, 2005 11:20 am
- Forum: IBM QualityStage
- Topic: USPREP rule question
- Replies: 0
- Views: 1943
USPREP rule question
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...
- Fri Aug 19, 2005 8:26 am
- Forum: IBM QualityStage
- Topic: USADDR standardizing CR as COUNT (not CIRCLE, not COUNTY RD)
- Replies: 2
- Views: 3048
- Thu Aug 18, 2005 12:48 pm
- Forum: IBM QualityStage
- Topic: USADDR standardizing CR as COUNT (not CIRCLE, not COUNTY RD)
- Replies: 2
- Views: 3048
USADDR standardizing CR as COUNT (not CIRCLE, not COUNTY RD)
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...
- Thu Aug 11, 2005 10:11 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to run a job in multiple instances
- Replies: 17
- Views: 9244