DSXchange

Hi, Thanks for the quick reply. The link doesn't work but I assume it is this one http://www-01.ibm.com/support/knowledgecenter/SSZJPZ_8.7.0/com.ibm.swg.im.iis.ds.pxop.dev.doc/topics/odg_descriptions_of_messaging_macros.html All that says is: The final argument is logOrSourceModule : the object to w...

APT_MSG(MessageSeverity, englishString, args, logOrSourceModule) For "logOrSourceModule", what is the possible value ? Hi, I know this is an old thread, but I can't find any documentation on what "logOrSourceModule" should be. If I set it to APT_LogWarningId (generated by the bu...

Yah, I was trying to avoid having to to create an external object. It's one more thing to maintain and promote through the environments. Any other ideas?

Hi, does anyone have an easy way to throw a warning into the job log from a PX job? For server I used to have a routine that would do a "Call DSLogWarn(MessageString, RoutineName)". Basically, I just need to be able to pass a string inside a transformer or some other stage and have it show...

First, I am a bit confused. You say that "123 YOUNG DRIVE WEST NW" generates a ^+DDD. I would expect (depending on the rule set) that 'DRIVE' would be a T, so the pattern would be ^+TDD. . Yes, sorry that one is a typo. It does give me ^+TDD. As for the result I expect, I need to have a s...

Sorry, I meant to say "Problem with this is that ? handles only unclassified words. ".

So I need a class that can match multiple words, classified or not.

Hi, I'm trying to convert a string of multiple tokens to a new class. I have tried lookups and conversion but neither is really doing what I need. I'm looking for some suggestions on how to proceed. I can't create a rule for each case becasue there are thousands, and in some cases, thes rules would ...

\%\P doesn't get replaced by "Datastage" ... but it also doesn't work in a like statement. So like '\%\PERIODONTAL%' returns no rows.

Can you replace the "%" with "\%" to see if that makes a difference? ... Same problem. I get and upper(a.acct_name) not like '\DataStageERIODONTAL%' I also tried CHR(37)||'PERIODONTAL%' and that seems to work but it's a messed up way to write SQL if I have to change every where ...

Hi, I have this SQL with a parameter in the where clause. The result of the parameter works but the resulting SQL is messed up. For some reason every %P gets replaced by "Datastage" at run time. I tried adding APT_OSL_PARAM_ESC_SQUOTE but no change. Here is the original SQL: select A.kcm_A...