DSXchange

Given that the negation operator (!) cannot be user with a floating position specifier (* or #), how might one construct a pattern to identify "string that does not contain a colon character"?

We tried to use !*\: but that ran into the problem mentioned above.

Thank you for your time.

Yes, it seems that NotePad was the culprit. Using TextPad allowed accented characters to be included.

Unfortunately the QualityStage Test utility can't display them, but they standardise correctly.

Thank you very much for your time.

We are getting the following error message. Standardization process failed. Table contains an invalid entry. The above error occurred in the following line of file C:/IBM/InformationServer/Clients/Classic/TempRules/IDD7DIGIT.TBL \FORMAT\ SORT We have created the TBL file in the Quality directory as ...

Has anyone created a rule set for validating URLs, something along the lines of the supplied VEMAIL rule set, that they'd be prepared to share?

Looking at avoiding re-inventing the wheel here.

Thank you for your time.

That works and we will use it in our rule set.

Thank you again for your time.

Thank you for those answers.

In various name rule sets there is the pattern action as follows. ; Remove delimiters 0*Z RETYPE [1] 0 I understand that * is the floating position specifier and Z is the class for delimiters, but what does the 0 do in the pattern? I can't find any reference to a leading 0 in the Pattern Action refe...

We have data in which the title is duplicated, for example "MRS MRS JENNIFER TAYLOR" and want to use Pattern-Action Language to remove the duplicate. We tried: P | P [ {} = [1] ] | ** RETYPE [1] 0 but this generated an error in the Test utility. Can someone with PAL experience please sugge...

In the job that consumes surrogate key values we use a Transformer stage and the NextSurrogateKey() function.

The pathname of the state file is correctly recorded in the stage properties.

We have a job that deletes, creates and populates a Surrogate Key state file. The "select max key + 1" query returns a ten digit number. Running this job with a single node configuration file, the state file gets deleted and created, but the result of the query does not update it, and it g...

Is there any utility that allows one to interrogate the current values in a surrogate key state file (created by Surrogate Key Generator stage)?

If not, is the structure of the state file documented anywhere?

Thank you for your time.

Thank you both.

lstsaur, can you please advise what MOU is in this context?

As part of planning our next upgrade we are considering a grid implementation. Would those who have travelled this road please share any do's and don'ts, any traps and any best practices? One question in particular - how is scratchdisk (which ordinarily always be local) handled in a grid configurati...

I had a job that inserted 110 million rows into a Teradata table, which took two days to complete. It was suggested that Teradata FastLoad would be faster, so I changed the Teradata Connector access method from Immediate to Bulk, and the bulk method to Load. The Teradata Connectivity Guide suggests ...

Thank you for perfect solution!