Monthly Archive: April 2016

Apr 26

Installing Python3/Spyder on Linux Mint 17

sudo apt-get install python3-pip python3-pyqt4 sudo pip3 install spyder sudo pip3 install rope

Apr 11

List tables without Primary Keys in a DB2 database

— — List DB2 base tables which don’t have Primary Keys — SELECT sit.TABLE_NAME, ‘No Primary Key’ FROM SYSIBM.TABLES sit LEFT OUTER JOIN SYSIBM.SYSCOLUMNS sic ON sic.TBNAME = sit.TABLE_NAME AND sic.KEYSEQ > 0 WHERE sit.TABLE_SCHEMA = ‘@MVPADM’ AND sit.TABLE_TYPE = ‘BASE TABLE’ AND sic.NAME IS NULL;