Executes an SQL "select" statement from the CLI. Read-only operations are permitted. Insert, Update, Delete and any DML statements are disallowed. This command allows queries to be run against the Unified CCX databases (data stores) and sysmaster database for the Unified CCX Informix instance (IDS engine).
run uccx sql database_name sql_query [options]
database_name—mandatory; database on which the SQL statement will be run
sql_query—mandatory; the sql statement to run
page—displays the output one page at a time
file—stores the output to a file instead of showing it on the console. The name of the file will be displayed after the completion of the command.
Command privilege level—0
Allowed during upgrade—No
admin:run uccx sql db_cra select resourceid,resourcename from resourceRESOURCEID RESOURCENAME
9 ankit agent2
10 ankit rtlite1
24 Ankit RT Pro