Paasing constant value to Numeric datatype.

[Former Member]

Hi All,

I am trying to pass constant value to Field which is Numeric(2,0) in order to limit number of records in where condition

I did

And Fieldname = 40  (here fieldname is Numeric(2.0)  )

it gives me error

and if I remove this condition it works perfectly.

can some one tell me how to pass value

[Former Member · Accepted solution]

Hi Ayush,

After reading your query, I could understand two scenarios :

1. If you are just trying to pass a static value in numeric column then try to give it in single quotes like Field_name='40'

2. If you want to restrict number of records to be populated in target then you have to first add a sequence  number to your data and then restrict that sequence column with condition SEQ_COL <=40

I hope it gives you solution.

Regards,

Tanvi

[Former Member · Accepted solution]

Hi Tanvi,

Your 1 solution relates to me.
but it is not working I already tried this.

[Former Member · Accepted solution]

Hi Ayush,

Can you please share dataflow generated optimized SQL.

Regards,

Tanvi

[former_member187605]

You'd get better help if you can give us a bit more info.

Are you're using an ABAP or a normal dataflow? Are you selecting from one table only?

Can you post the ABAP or SQL code generated? In both cases, with and without the where-clause.

[Former Member]

can you please explain in details.

You are trying to restrict records or you want to have constant value for some column.

[Former Member]

trying to restrict records.
as it has millions of record.