Common Content for Data Engineering
- Common Content for Data Engineering 10.2.1
- All Products
Since the parameter $date_parm is a string, add single quotes to the parameter in the query. The following expression shows the query where single quotes are added to the parameter:select * from <table_name> where <date_port> > $date_parm
select * from <table_name> where <date_port> > '$date_parm'
select * from <table_name> where <date_port> > '01/31/2000 00:00:00'
You add single quotes to the default valueselect * from <table_name> where <date_port> > $date_parm
Since single quotes are part of the default value, the Data Integration Service escapes the data with additional single quotes. Because the string parameter contains double quotes in the expanded query, the query might fail or produce no result.select * from <table_name> where <date_port> > ''01/31/2000 00:00:00''