SELECT ERRORMESSAGE,io.objectname,valid, * FROM syscat.INVALIDOBJECTS io
INNER JOIN syscat.ROUTINES r ON io.objectname=r.ROUTINENAME
WHERE io.OBJECTSCHEMA='SMB_QA_EB'
AND io.objectname IN (upper('sp_cn_sb_account_tagging_1'))
--AND r.OWNER='MARIO.GALJANIC'
--AND r.VALID='Y'
--ORDER BY ERRORMESSAGE ASC
 ;

SELECT errormessage, * FROM syscat.INVALIDOBJECTS WHERE OBJECTSCHEMA='SMB_QA_EB'
AND ROUTINENAME = upper('%sp_one_time_catchup_load_gmdb_4418_org%');


CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS('function', 'SMB_QA_EB',
upper('sp_fact_site_segment_bp_apj_emea'));
CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS('view', 'SMB_QA_EB', upper('vw_stg_cn_csb_ob_call'));
CALL SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS('procedure', 'LATAM_QA_ETL',
upper('sp_copy_tables'));

CALL SMB_QA_EB.sp_cn_sb_account_tagging_1();
SELECT * FROM SQL_CMD;


SELECT valid, ALTER_TIME, OWNER,* FROM syscat.ROUTINES
WHERE ROUTINESCHEMA='SMB_QA_EB'
AND ROUTINENAME LIKE UPPER('%sp_dim_apj_anz_sb_obtm_backfeed%')
--AND owner='NIKOLA.SAMARDZIC'
--AND valid='N'
--ORDER BY ROUTINENAME
--ORDER BY ROUTINENAME, OWNER
--ORDER BY ALTER_TIME DESC
;


SELECT ROUTINENAME FROM SYSCAT.ROUTINES WHERE ROUTINESCHEMA = 'LATAM_QA_ETL' AND OWNER = 'MARIO.GALJANIC' ORDER BY ROUTINENAME;

CALL LATAM_QA_ETL.SP_AGG_PLAT_SITE_INFO
;
SELECT ROUTINENAME, OWNER, VALID, ALTER_TIME FROM syscat.ROUTINES
WHERE ROUTINESCHEMA='SMB_QA_EB'
AND ROUTINENAME LIKE UPPER('%sp_cn_sb_industry_supplement%')
--AND owner  IN ('MARIO.GALJANIC')
ORDER BY ALTER_TIME DESC;

SELECT ROUTINENAME, OWNER, VALID FROM syscat.ROUTINES
WHERE ROUTINESCHEMA='SMB_QA_EB'
AND ROUTINENAME LIKE UPPER('%sp_qc_end_user_revenue_report%')
--AND owner  IN ('MARIO.GALJANIC')
AND valid='N'
ORDER BY ROUTINENAME
--ORDER BY ROUTINENAME
--ORDER BY ROUTINENAME, OWNER
;