DSXchange

I have a custom operator where I read in certain field(s) and perform certain operations on said field. I keep getting the below warning message and am not sure what exactly it means. Does it have to do with the input column having the same name as the output column? Is there a work around? CstOplss...

Ok I have a simple parallel job that consist of a row generator (two columns A and B, char length=1) that feeds into a shared container and then to a peek stage. In the shared container, I have an input, lookup stage, and an output where I try to match on a key (single char) to get back a value. Are...

You are saying that Runtime Column Propagation will allow you to pass through all columns where the input and output schema isn't known even if the job is only working on a select number of columns? Does the columns have to be the same though out the entire job to use RCP? Does the entire job have t...

We have a situation where we want to use a database lookup table as a reference in a Datastage job. We want to create a module where the input and output schema will be undefined, with exception to the input field(s) used in the lookup and the resulting output(s) fields. We have attempted to do this...

Thanks for your continued feedback. Yes, I'm trying to replace a portion of the string. Basically I'm attempting to remove the space from the string ('Mc Daniel' -> 'McDaniel'). I start by coping the APT_String into a C-style buffer. Once this is done I shift the data over removing the space. Lastly...

No, I simply have an APT_STRING object that is a certain length and when I attempt to make it shorter it complains with this error. I noticed that if I make the string longer it's find but if you ever attempt to make it smaller it complains. I use the assignment operator '=' which is overrode. Are y...

All, I have a generic question about using the APT_STRING class as part of creating a custom operator. I have an instance in my source where I have created an APT_STRING object and populated it with a string. If I attempt to make the string smaller I always receive a compiler error complaining about...

Instead of using the standard lookup files that reside on disk, Is there a way from within a ruleset to read from a database table?

All I'm looking at building a Custom Operator where one of the links coming into the Custom Operator is a DB connection. I would like to set the incoming DB connection as a reference link so it's used only once. Does anyone know if there's an easy way to do this from within the custom Operator the D...

anbu wrote:Oops!! I didnt notice that requirement is for Quality Stage.

Above syntax is for transformer.

Is there a certain syntax that can be used in the pattern file to do this?

JRodriguez wrote:select the proper default standardization output format in the main page of the standardize stage. It should works. Options are:

- preserve case
- all capitals
- capitalized every word
- all lower case

Is that what you want?

Yes Thanks

All, I've seen post in the forum regarding the standardize stage, combined with the mixed-case CLS entry. Does anyone know and how it's used? Where can it be found?

anbu wrote:

Code: Select all

str="mcdonald"
tgtStr=UpCase(str[1,1]) : str[2,1] : UpCase(str[3,1]) : str[4]

So you are saying this syntax can be used in the "Patterns file" of QualityStage?

Is there a way to change the case of a particular character in a string. For Example if I have 'mcdonald' as the string and I want to change it to 'McDonald'.

I'm trying to use QualityStage to read in multiple name columns and mix case strings. I have two input columns 'fname' and 'lname' read into a Standardize stage and after running through the QualityStage ruleset I have now three columns 'fname', 'lname', 'MIXCASE_STRING_mixcase_field'. I set the 'N...