Passing variable in SQL Query

[Manohar1 (Adicherla Manohar)]

Hi Team

Getting the following error by executing the following query
variable pp=“1234”
Query:“select PLAN_ID from SCH.PPOL where pol_id=”& pp &“”

Error:
An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
System.Data.Odbc.OdbcException: ERROR [22018] [IBM][CLI Driver][DB2/AIX64] SQL0420N Invalid character found in a character string argument of the function “DECFLOAT”. SQLSTATE=22018

Regards,
A Manohar

[amarasto (Aman Rastogi)]

Hey @Manohar1,

Please use the query below:

Query:Select PLAN_ID from SCH.PPOL where pol_id=‘“+pp.tostring+”’

[AshwinS2 (Ashwin S)]

Use + instead of &

Use it like+ pp.ToString+"

Thanks
Ashwin.S

[Manohar1 (Adicherla Manohar)]

Tq @amarasto & @AshwinS2

Regards,
A Manohar