DSXchange

Posted: **Sat Oct 08, 2011 4:26 pm**

Hi

I want to create new column with default value using column generator stage using schema file. i tried with below schema file, but it has not created with default value( i gave in the schema). It has incremented by 1 starts with 0.

Code: Select all

record
(
  Number:decimal[5,2] {default=000.00};
  )

Could someone face this issues, please help me.

Here we should not use Transfomer stage as i am using RCP.

Thanks

Posted: **Sat Oct 08, 2011 8:57 pm**

Try it with no space between the "]" and the "{".

Posted: **Sun Oct 09, 2011 2:18 am**

ray.wurlod wrote:Try it with no space between the "]" and the "{".

Thanks Ray,

But still i am getting the same warning message and same data incrementing with 1.

Code: Select all

Column_Generator_12: Field Number  of type decimal[5,2]:: unrecognized generator parameters ignored:

.

I thought of generating this field in Column Import stage while importing the single field to multiple fields but It doesn't support to create new field which doesn't exist in source.

Posted: **Sun Oct 09, 2011 4:33 am**

Build a table definition and view its parallel layout to get the correct syntax.

Posted: **Mon Oct 10, 2011 4:39 am**

Thanks Ray.
Correct One

record
(
Number:decimal[5,2] {cycle={init=000.00, incr=0}}
)

DSXchange

Default value in column

Default value in column