I'm trying to check all counts for all tables in IBM DB2 using Red Hat Linux. When I try to run this DB2 SQL Script
db2 "SELECT 'SELECT COUNT(*) AS ROW_COUNT FROM '|| tabschema || '.' || tabname || ';' FROM sysibmadm.admintabinfo WHERE tabschema not like 'SYS%' order by tabschema, tabname asc" > script
Linux will return
bash: script: Permission denied
Asked by Taqiuddin Shokordey
(1 rep)
Mar 9, 2021, 02:46 AM
Last activity: Mar 9, 2021, 08:48 AM
Last activity: Mar 9, 2021, 08:48 AM