Parameterize query SQL file

[SURA]

I am not sure, but try this 'eff_dt=#eff_dt#'.

DS User

[manoj_23sakthi]

Hi Vijay,

Please try this #Eff_date# ...
I hope it may work....
Please check the parameter data type for Eff_date if its "char " change as "date"

Manoj kumar,

[chulett]

You cannot include parameters in the SQL File, that's one major drawback to that approach. You will need to build the file with the actual parameter value included in it rather than referenced in it.

[vijaydasari]

Thank you Chulette.
You will need to build the file with the actual parameter value included in it .

can you please elaborate on this?

[Developer9]

Hi Vijay,

"build the file "Indicates that we have to "write a SQL query in a file format mostly (.sql format )>>Please double check here for Format

"actual parameter value "implies that for eff_dt include same value not as #eff_dt#.>>The reason behind Parameters usage is to supply values during run time but here we can supply any value to eff_dt .i.e.for SQL queries.

I think above explanation gives you some idea

Experts:Please correct me any modification for above explanation

Thank you