DSXchange

First Routine: If FolderID Matches 0:Char(253):"10N'C'":Char(253):"'UAFA'9N":Char(253):"'UAFA'8N'C'" Then Ans = 0 Else Ans = 1 Results in 0 for matches, 1 for non Second Routine with 2 args If FolderID Matches Masks Then Ans = 0 Else Ans = 1 Result is 1 for all. Mask va...

Using a copy of the testing Routine I cut 0:Char(253):"10N'C'":Char(253):"'UAFA'9N":Char(253):"'UAFA'8N'C'" and replaced it with Arg2. Compiled and tested, pasting 0:Char(253):"10N'C'":Char(253):"'UAFA'9N":Char(253):"'UAFA'8N'C'" as Arg2. I...

A job using pattern matching now fails to match patterns. There are 2 stage variable: svMaskPattern jprFormatMasks svNoMatchFound inLink.FieldName Matches svMaskPattern value of jprFormatMasks is 0:Char(253):"10N'C'":Char(253):"'UAFA'9N":Char(253):"'UAFA'8N'C'" input ha...

Notes on resolution: Used a LOOP...UNTIL to process the Business Mask 1 byte at a time. Using Upcase I was able to keep strings together, ABC- for example, and store in "working storage". At the same time I set an indicator telling me what pattern matching token it was. When the pattern wa...

Thanks for the reply. I'm not sure a routine will work because the string can fit one (or more) of many masks. Input is a couple of million rows and there are 200 potential masks to check. Perhaps a routine is what I need to build the Pattern? Read the business masks and separate the bytes into work...

Here are all the 'mask' characters:
n - numeric
o - optional numeric
l - alpha
m - optional alpha
a - alphanumeric
b - optional alphanumeric

Always lower case. Upper case strings are just that. Optional means spaces are allowed.

Thanks.
Dick

There are others, always lower case, including b,c,l, and a. I don't have the doc handy right now but can post them all first thing tomorrow.
Thanks

I have a requirement to validate input based on "masks" the business has set up for the field. Business Masks look like: ACEnnnnnnAP BGFnnn-nnnXGF There are a couple of hundred masks defined. My plan was to dynamically build a parameter to use with a pattern matching operator like FieldNam...

Job inserting/updating data in a Datacom table on the mainframe is converting all decimal places to .00. Source = 40321.21 Output to database is getting 40321.00 ODBC1(Prod) --> Transformer --> ODBC2(Test) In DataStage both the Source and Target are defined as Decimal with Length 15 Scale 2. Both ar...

Stumbled on this post when searching the forum for a similar problem. Mine was resolved by sticking a passive stage between the transformer and link partitioner.

Perhaps this will assist someone down the road.

Parameters are used for jobs and sequences. Command Stages have the server name hardcoded. I don't think the command line can use the parameter. :?: I'm not sure why they didn't simply rename the servers. Then again, I don't think it's an issue for anything other than DataStage which they didn't rea...

One of the LAN servers accessed in various DS projects is getting replaced and a new name. My task is to change all instances of the server name within my projects from 'serverABC' to 'serverXYZ'. To accomplish this I exported one of the projects in Manager, created a job to read the .hml file and E...

Is there a way to restart a aborted/restartable sequence at the next step?

Sequence executes 6 jobs and is in a locked project. Job 2 aborted and status of sequence is aborted/restartable. Can Job 3 be started without Job 2 completing?

Perfect. Thanks Craig.

Removed the individual date components from the SELECT
Created a new field with the expression
Referenced the expression in the WHERE clause

Yes. STP_DT_YY * 10000 + STP_DT_MM * 100 + STP_DT_DD creates a new field (STP_DT) but the query doesn't recognize the new field in the WHERE clause. SYSUSR.CF_CC_REL.ROLE_STP_DT_YY * 10000 + SYSUSR.CF_CC_REL.ROLE_STP_DT_MM * 100 + SYSUSR.CF_CC_REL.ROLE_STP_DT_DD FROM SYSUSR.CF_CC_REL WHERE (SYSUSR.C...