not so active anymore, yet still stuff and code that works in Perl, bash, sh, PLSQL, TSQL, NZPLSQL , XML, HTML, XSL, C#, Scala , Python, Teradata SQL, cmd batch scripts, Oracle , MySql some old Java stuff , Linux , DB2 , Sun Solaris , NSIS , VB 6.0 , some old Essbase VB API and plain English - all this in non-user friendly fashion combined with occasionally strong statements and opinions about IT best practices, Agile Development , energy ... dump end ...Wait - https://qto.fi
# which tables have been groomed lately
for db in `nzsql -d SYSTEM -qAtXm -c "\l" |perl -nle 'm/^(.*?)\|(.*)/g;print $1'`; do echo $db ; nzsql -q -F "|" -d "$db" -c "SELECT TABLENAME, MODE, START_TIME,COMPLETE_TIME,RECOVERED_EXTENTS , PURGED_RECORDS , PROCESSED_RECORDS FROM _V_GROOM_HISTORY LIMIT 100;" ; done ;
Posts
No comments:
Post a Comment
- the first minus - Comments have to be moderated because of the spammers
- the second minus - I am very lazy at moderating comments ... hardly find time ...
- the third minus - Short links are no good for security ...
- The REAL PLUS : Any critic and positive feedback is better than none, so your comments will be published sooner or later !!!!