Report containing sysouts

Iceman · Post by **Iceman** » 03 Jul 2012 12:52

Hello,

I need to generate a report with the following fields,
Memname, Scheduling Table, Sysout.

Im using ControlM 6.3 and need this report with sysouts. I need this urgently.

Appreciate the help.

Regards,
Ice.

Iceman · Post by **Iceman** » 03 Jul 2012 4:37

Hello Chookgate,

Yes, you are absolutely right, not possible to get the information from report tool in 6.3.

I got the below error when running the command,

1> select MEMNAME,SCHEDTAB,SYSPRM from CMS_JOBDEF inner join CMS_SYSOUT
2> where CMS_JOBDEF.JOBNO=CMS_SYSOUT.JOBNO
3> go
Msg 156, Level 15, State 2:
Server 'CONTROLM', Line 2:
Incorrect syntax near the keyword 'where'.

P.S. Im very new to sql, so could you please let me know if Im doing something wrong

Regards,
Ice.