Page 1 of 1

Server Routine Name Pattern

Posted: Wed Sep 24, 2014 12:38 am
by vishal_rastogi
Hi

I am using one audit routine in that i am passing my parameters as

Stagename|linkname|TgtStage name| tgt linkname

is there any way to use the pattern based parameters

like : *_SRC_STG|*_SRC_LNK|*_TGT_STG|*_TGT_LNK

Thanks

Posted: Wed Sep 24, 2014 5:13 am
by priyadarshikunal
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.

Posted: Wed Sep 24, 2014 4:06 pm
by ray.wurlod

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.

Posted: Wed Sep 24, 2014 4:37 pm
by chulett
Was wondering the same thing and waiting to see where the discussion went. Moved.

Posted: Thu Sep 25, 2014 2:40 am
by vishal_rastogi
Thanks Ray

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

Posted: Thu Sep 25, 2014 6:36 am
by qt_ky
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.

Posted: Thu Sep 25, 2014 4:00 pm
by ray.wurlod
What Eric said. The appearance of "1X0X" later in my post may have given you a clue.