Guidelines for SQL statements within actions
- All SQL commands are run as the BMC Remedy database user (default ARAdmin)
- No semicolon is required at the end of the SQL statement. The command can include any Process Designer or BMC Remedy server fields.
- To update the current task, use the reserved word p_task_id to identify the record; for example:
UPDATE abyd_task set action_taken = 'Job Done' where task_id = p_task_id
- To update the current request, use the reserved word p_request_id to identify the record; for example:
UPDATE ABYD_Sample_Form set short_description = 'Software Problem' where request_id = p_request_id
- Because the SQL statement is run from within a BMC Remedy filter, any errors resulting from the SQL statement will be visible from the BMC Remedy filter and the SQL log files.
Was this page helpful? Yes No Submitting... Thank you