DSXchange

Anbu, The Execute command those not return any error. The Sequencer fails later because the awk result is not the one expected. Mi intention is to comment a Configuration file with general information of the content, fields, etc. But comments should not be considered when processing. For example: #-...

Hello! I have found out that my company has a global agreement with IBM, and it seems to be that it includes "unlimited" licenses for every IBM product that we can get our hand on. We are already using DataStage (7.5.1) but i have heard about QualityStage, ProfileStage, etc... What IBM pro...

Hello!

Pretty much everything i need is that, what is the sintaxis? its not in the documentation and i dont know where to look for that.

Generating a DataSet and then using DataSet manager to see the schema for it shows no help.

Thanks!

Hey ray, thanks for showing i have at least someone reading this :) for point 1. In the "how to become a Modify zen master" blog it says you can have a null modify parameter... at least in my version, 7.5.2 that is not working... maybe i was wondering someone who got around to this, like s...

Anyone?

Hello! I have developed a set of jobs that use Modify stage using a parameter to load the Specification. After reading about it online, in the manual and also the blog post about "How to become a Modify Stage Zen Master" i still have two doubts. 1- What if i dont need to use the modify sta...

Thanks!

Solved it.

Hmmm... nobody should HAVE to use only a Modify stage, as Ray would say - Resist Stupid Requirements! And I think Div() is only valid in a Transformer. If your only recourse is to divide the number by 100 because a lack of delimiters then I believe your new limitation will be that you'll HAVE to do...

I don't believe you can manipulate data in the Modify stage, only drop/keep columns and convert data types. You'd need a Transformer to do the division, as far as I know, your syntax would be fine there. Or you can try the Div() function. My limitation is that i HAVE to use only modify stage, ill t...

chulett wrote:Couldn't you just divide it by 100? ...

That is a great idea that i tried to implement in the modify stage but it seems not doable.

"<field> / 100" throws a syntax error... do you know the correct syntax?

If you're trying to convert a varchar to decimal in Modify stage you need to use the following function: decimal_from_string decimal_col:decimal = decimal_from_string [ceil] (source_col) For more information on this function you can refer Parallel job developer guide. Hope that Helps. -Hiral I am t...

Hello!

Is there a way to convert, using modify stage, a string field with the following data:

12034

to decimal 5,2? that is, to 120,34

the key here is using only modify stage because i need to pass the conversion using parameter (i am using one job for several files)

Thanks!

Sainath.Srinivasan wrote:Insert one extra dummy column in the column generator stage and drop it in the modify.

But i wont be able to fill that column with the current date, am i right?

Hello! I have the following example from a fixed width file i need to read. I would very much like to do it using schema files, since i want to have only ONE job to process multiple files that are similar but have different metadata. Les suppose i have the following data i want to import: JUANCHO120...

I think the only solution is to process the file as a whole huge record and then add another column (having the current date) at the transformer level, this should be done in a first job, the second job should use RCP and i will already have [date]<separator>[original data], hence i will be able to ...