datadeploy , iwodcmd passing comma separated string

Placid_entropy

hello  friends, 

 

I am passing a sql query to datadeploy configuration file using the commandline  iwodcmd .

 

commandline:-

 

iwodcmd start dddeploymentconfigurationfile -k iwdd=db-to-xml database=somedb -k sqlquery="select a.col01,a.col02,a.col03 from table a"

 

datadaployconfiguration extract:-

 

<db-producer-query>
<![CDATA

$sqlquery

 ]]>
</db-producer-query>
</database>

 

The comma is not gettign recognized , they are turned into nothing , i.e null  and the query fails.

 

Have someone faced such issues for comma not getting recognized when we pass it to iwodcmd ?

 

is there any workaround or alternative to this ?

 

Thanks and Regards,

Mahtab Md.

 

Placid_entropy

Found on od7.2 release notes . It is a bug-

 

Use of Commas in Parameter Substitution Values for DataDeploy Not
Supported (62077)
The use of commas in parameter substitution values for DataDeploy deployments is not
supported. The commas are replaced by spaces when the parameter substitution value is
integrated into the deployment.