Karina_Mankauskas_553

JOBF select count in AH_NAME

Discussion created by Karina_Mankauskas_553 on Aug 1, 2017
Latest reply on Aug 2, 2017 by Karina_Mankauskas_553
Hi,
How do I to count (select count AH_NAME) only the 'main jobf', for example, JOBF.TEST without counting the same jobf that has only change file name after transfer?
How to count?
Example:
JOBF.TEST
JOBF.TESTE(/SFTP/TESTE_01-09-2015.CSV)
JOBF.TESTE(/SFTP/TESTE_02-09-2015.CSV)
JOBF.TESTE(/SFTP/TESTE_03-09-2015.CSV)

I using the following select:

select count(AH_Name), AH_Name from AH where AH_OType in ('JOBS', 'JOBF') and AH_Client='0110' and to_char(AH_TimeStamp4,'yyyy-mm-dd HH24:MI:SS') between '2017-07-31 03:00:00' and '2017-08-01 02:59:59' group by AH_Name order by AH_Name

Thanks and regards,
Karina



Outcomes