Server Routine Name Pattern

vishal_rastogi · Post by **vishal_rastogi** » Wed Sep 24, 2014 12:38 am

priyadarshikunal · Post by **priyadarshikunal** » Wed Sep 24, 2014 5:13 am

It all depends on the way routine is written. If it is written to look for a pattern then don't even have to pass that *. Hence I don't think if I can answer this without looking at the routine itself.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 24, 2014 4:06 pm

Code: Select all

Arg1 Matches "0X'_SRC_STG|'0X'_SRC_LNK|'0X'_TGT_STG|'0X'_TGT_LNK'"

The pattern element 0X matches any number of characters. If you require there to be more than zero characters, change each "0X" to "1X0X".

You can use "..." in place of "0X".

This post probably doesn't belong in the Metadata and Metadata Workbench forum.

chulett · Post by **chulett** » Wed Sep 24, 2014 4:37 pm

Was wondering the same thing and waiting to see where the discussion went. Moved.

vishal_rastogi · Post by **vishal_rastogi** » Thu Sep 25, 2014 2:40 am

Thanks Ray

Just wanted to know 0X is hexadecimal value or it is something else

qt_ky · Post by **qt_ky** » Thu Sep 25, 2014 6:36 am

The preceding integer is the repeating factor.

X stands for any characters.
A stands for any alphabetic characters.
N stands for any numeric characters.

You can read a lot more about the pattern matching operator, MATCH and MATCHES, in the IBM InfoSphere DataStage BASIC Reference Guide.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 25, 2014 4:00 pm

What Eric said. The appearance of "1X0X" later in my post may have given you a clue.