| Page Properties | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
...
- Open iShare Studio
- Expand the Workflow node in the Explorer tree
- Expand the Jobs node and find the NHS Choices Job.
- Right click on the NHS Choices Job entry and select New Task.
- Select Stored Procedure Task
- Give the Task a Name, select the DataShare database and the at_wkf_executecmd function (from v6.0.0 this is called wkf_executecmd under the -Workflow- Function filter).
- In the Edit parameter box enter the following SQL.
| Paste code macro |
|---|
UPDATE nhschoices_all SET link = replace(link, 'http:', 'https:') where lower(link) not like 'https%' and lower(link) like 'http% |
...