How to add parameter to CE10 Command Object 1

[cmmrfrds]

I have an SQL statement that is quering an Oracle database. I need to parameterize some parts of the SQL.

Example snippet of code.
from clarity.bsch_job, clarity.bsch_run
where clarity.bsch_run.run = clarity.bsch_job.run
and clarity.bsch_job.sf_date = to_date(to_char(sysdate-6, 'DD-MON-YY'))
group by clarity.bsch_job.run

In the above example sysdate-6 needs to be a date parameter. For example parm1.
to_date(to_char(?parm1, 'DD-MON-YY'))

How is this done?

 

[KingfisherINC]

Create your command exactly as you have it above, then create your parameter from the create parameter option in the Command dialog. Select the piece of SQL you want to replace (i.e. sysdate-6) and then double-click your parameter name on the parameter list.

Kingfisher [CECP]

 

[cmmrfrds]

Thank you KingfisherInc I will try that when I get to work tomorrow.

 

[cmmrfrds]

Thank you King Fisher, that worked perfectly. Pointing me in the direction of the create parameter option in the Command dialog did it for me. I had gotten confused by the Parameter in the field list interface.