Search found 198 matches

by janhess
Thu Sep 27, 2007 9:32 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: blank space within quotation
Replies: 7
Views: 5185

try this if your field has other spaces in it

="<ANYQUOTE>" + trimright(substitute("""United State's of America ""","<QUOTE>","")) + "<ANYQUOTE>"

In your case replace the text with your field.
by janhess
Thu Sep 27, 2007 8:03 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: blank space within quotation
Replies: 7
Views: 5185

in map rule.
=substitute(Country_Name Field:In1," ","")
by janhess
Thu Sep 27, 2007 2:24 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: blank space within quotation
Replies: 7
Views: 5185

use SUBSTITUTE(fieldname," ","")
by janhess
Tue Sep 25, 2007 2:41 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Comma as a data in a input file
Replies: 3
Views: 3587

Q2 - Should only do the conversion if it is XML. Check the restrictions rules on the type tree.
by janhess
Fri Sep 21, 2007 3:32 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Mapping invalid fields?
Replies: 7
Views: 6987

But who is Jim? Did he hand it out on a street corner? Is he the Guru? Can I meet him?
by janhess
Thu Sep 20, 2007 2:04 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Mapping invalid fields?
Replies: 7
Views: 6987

Rep said
I used the setting from the map in Jim's hand out, which is "Always".
Is that how you got yours?
by janhess
Wed Sep 19, 2007 9:27 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Mapping invalid fields?
Replies: 7
Views: 6987

Who's Jim and how do I get his handout?
by janhess
Wed Sep 19, 2007 9:15 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Help to become good?
Replies: 11
Views: 7855

Probably best to say nothing then.
by janhess
Wed Sep 19, 2007 7:55 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Help to become good?
Replies: 11
Views: 7855

I think, in English, Rep is suggesting using a lookup table and using the LOOKUP function.
by janhess
Mon Sep 17, 2007 8:27 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Problems with importing from XML Schema(xsd)
Replies: 21
Views: 15583

8.0 (124) is just an update to release 8. 8.1.0.2 is the second service pack for release 8.1 so you will need to request the release upgrade. If you have a service contract you should get it automatically.
by janhess
Mon Sep 17, 2007 7:22 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Problems with importing from XML Schema(xsd)
Replies: 21
Views: 15583

8.1.0.2 is just WTX as far as I know and it is pronounced like Xerces.
by janhess
Sat Sep 15, 2007 6:45 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: special character handling
Replies: 4
Views: 5997

If you import the XSD, the type tree should handle it depending on which version you have. There have been bugs in this area with some releases but generally all special characters are automatically converted. So & becomes & in the output. If this is not happening then it is a bug with the x...
by janhess
Tue Sep 11, 2007 7:50 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Resource Registry Use or MisUse Question......
Replies: 10
Views: 9639

Well I supose if you are a consultant you would think that way as it provides you with work every time something changes. We prefer to have everything soft coded so that we don't have to wory about changing code, only resource registry or properties files. In our development environment things are c...
by janhess
Tue Sep 11, 2007 2:05 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Resource Registry Use or MisUse Question......
Replies: 10
Views: 9639

So what would you do if your ftp destinations were changed for different environments. You would have to change the maps or msl. By using resource registry you can be confident that the mep you tested can be copied to the live environment with no changes. Only change may be resource registry. If you...
by janhess
Mon Sep 10, 2007 8:33 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: Problems with importing from XML Schema(xsd)
Replies: 21
Views: 15583

You have to get patches from support as they may be specific to your site.
Latest version of WTX available is 8.1.0.2 build 38. This may solcve many of your problems.