Command to Display Curernt SQL for a Job

[JohnO]

Hi All,

In Ops Nav, it's possible to display the current SQL being executed by
a job. However it's rather slow to find the job as it has to populate a
large list of jobs then sort them. I suspect there is a CL command that
takes a job number parameter that would be much faster.

Is there such a command or is Ops Nav somehow using an API that is not
available as a CL command?

Thanks
JohnO

[4.spam]

Hello.

C API name is QUSRJOBI. Header file name is qusrjobi.h.
If someone wants soruce C code for UDF like this:
**************
--- Returns a LAST EXECUTED sql command for specified job
CREATE FUNCTION DWHTEST.QRY_SQL
(
JOBNAME VARCHAR(10) ,
USERNAME VARCHAR(10) ,
JOBNUMBER VARCHAR(6)
)
RETURNS VARCHAR(32700)
LANGUAGE C
NOT DETERMINISTIC
NO SQL
CALLED ON NULL INPUT
EXTERNAL NAME 'DWHTEST/QRY_SQL(QRY_SQL)'
PARAMETER STYLE SQL ;
*****************
write at mark(dot)b(at)mail(dot)ru

Sincerely,
Mark B.

Hi All,

In Ops Nav, it's possible to display the current SQL being executed by
a job. However it's rather slow to find the job as it has to populate a
large list of jobs then sort them. I suspect there is a CL command that
takes a job number parameter that would be much faster.

Is there such a command or is Ops Nav somehow using an API that is not
available as a CL command?

Thanks
JohnO

[JohnO]

4.****@mail.ru wrote:

Hello.

C API name is QUSRJOBI. Header file name is qusrjobi.h.
If someone wants soruce C code for UDF like this:
**************
--- Returns a LAST EXECUTED sql command for specified job
CREATE FUNCTION DWHTEST.QRY_SQL
(
JOBNAME VARCHAR(10) ,
USERNAME VARCHAR(10) ,
JOBNUMBER VARCHAR(6)
)
RETURNS VARCHAR(32700)
LANGUAGE C
NOT DETERMINISTIC
NO SQL
CALLED ON NULL INPUT
EXTERNAL NAME 'DWHTEST/QRY_SQL(QRY_SQL)'
PARAMETER STYLE SQL ;
*****************
write at mark(dot)b(at)mail(dot)ru

Sincerely,
Mark B.

Hi All,

In Ops Nav, it's possible to display the current SQL being executed by
a job. However it's rather slow to find the job as it has to populate a
large list of jobs then sort them. I suspect there is a CL command that
takes a job number parameter that would be much faster.

Is there such a command or is Ops Nav somehow using an API that is not
available as a CL command?

Thanks
JohnO

Thanks Mark, you are a mine of information!