Originally posted by: repanzer1

Can anyone point me to where "ANY" is described in the documentation? I checked Functions and Expressions, then Map Designer guide, but couldn't find it in either. I can't even remember where I heard of it before, but I thought it may help with what I'm trying to do, because "IN" isn't working, but I'm not sure how to use it. Any info would be appreciated.

---

There are 10 types of people in this world. Those who understand binary and those who don't.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

As far as I remember, there was an "ANY" type that was supposed to be introduced in version 6.x of MErcator (not in 6.0, but it was mentioned when the 6.0 was released)

Could this be a remnant from this time ?
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: lanapoli

It is documented in Type Designer:

http://pic.dhe.ibm.com/infocenter/wtxdoc/v8r4m0/topic/com.ibm.websphere.dtx.td.doc/concepts/c_type_design_Variable_Component_Names.htm
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Thanks, Lori, I learned something today !
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: repanzer1

Yes, thank you also.

I read through the document and like always when trying to learn something new in WTX, I built a simple type tree and map and attempted to use ANY. The type tree is a file, with a Purchase_Order group (s), with one partitioned group (s), and two possible records are in the partitioned group, record A or record B, where the first field (also the first character) is either an "A" or a "B", followed by a blob, CR/LF terminator.

After trying a bunch of stuff, I wasn't even get ANY in a component rule or map rule and click enter without it bringing up an error. I thought it may be like "IN", where you replace the ":" in between the object names, but I get "Rule is invalid" when I try that in a map.

Any (haha!) ideas on how it is used? The doc really doesn't specify, though they rarely do.

---

There are 10 types of people in this world. Those who understand binary and those who don't.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: lanapoli

I have used it successfully in Data Audit settings to control auditing all fields within a group vs having to add them individually. There is a comment in the Design Studio Intro that ANY cannot be used on map rules or component rules (http://pic.dhe.ibm.com/infocenter/wtxdoc/v8r4m0/topic/com.ibm.websphere.dtx.dsgnstud.doc/references/r_design_studio_intro_Reserved_Words_and_Symbols.htm). What functionality are you attempting to use ANY for on a map rule?
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: repanzer1

So the info in regards to ANY is Type Designer, even though you can't use it in a component rule, or it's in Design Studio intro, as if it's something people should be aware of when first starting out with WTX. Weird.

But anyway, I am only trying to understand what ANY does, because there have been functions and short cuts in the past that I was unaware of, that when I found out about them, realized they could have made my life easier at some point, but I have no specific requirement that I need to use ANY for. It's just for my personal understanding.

I'm going to mess around with the audit logs settings with ANY.

Thank you!!

---

There are 10 types of people in this world. Those who understand binary and those who don't.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender