4 Replies Latest reply on Oct 16, 2018 5:53 AM by Angelo Pisaturo

    Execute PGSQL query on UNIX CTM server

      Share This:



      How can I execute a PGSQL query on a UNIX Control-M server? When I run a command job as sql<"/export/home/vadaadm/HELD_jobs_sql.sql", it fails with /home/ctmsrv/ctm_agent/ctm/runtime/CMD.000026ds_001: line 2: sql: command not found.


      But, the same command executes fine when I manually run it in the terminal. Am I doing something wrong here or is it genuinely a problem? Can anyone help me with a solution, please?