Ben Berry

Author's details

Name: Ben Berry
Date registered: December 11, 2015
URL: http://www.humbletown.org

Latest posts

  1. List all base tables in a DB2 database — August 18, 2017
  2. List unreferenced tables in a DB2 database — August 18, 2017
  3. Installing notepadqq on Debian-based Linux — May 29, 2017
  4. Making a replacement lathe leadscrew nut — January 9, 2017
  5. Windows Symbolic Links — December 6, 2016

Most commented posts

  1. In the beginning… — 2 comments
  2. All-terrain Mobility Scooter, Part 4 — 1 comment
  3. List tables without Primary Keys in a DB2 database — 1 comment

Author's posts listings

Aug 18

List all base tables in a DB2 database

— — List DB2 base Tables — select sit.TABLE_NAME, sit.TABLE_TYPE, substr(sit.TABLE_NAME,2,instr(sit.TABLE_NAME,’_’)-2) as SYSTEM, sct.COLCOUNT, sct.CARD as ROWCOUNT from SYSIBM.TABLES sit inner join syscat.TABLES sct on sct.TABSCHEMA = sit.TABLE_SCHEMA and sct.TABNAME = sit.TABLE_NAME where sit.TABLE_SCHEMA=’@MVPADM’ and sit.TABLE_TYPE = ‘BASE TABLE’;

Aug 18

List unreferenced tables in a DB2 database

— — List DB2 base tables which don’t have References — SELECT sit.TABLE_NAME, ‘No References’ FROM SYSIBM.TABLES sit left outer join syscat.REFERENCES ref1 on ref1.tabschema = sit.TABLE_SCHEMA and ref1.tabname = sit.TABLE_NAME left outer join syscat.REFERENCES ref2 on ref2.reftabschema = sit.TABLE_SCHEMA and ref2.reftabname = sit.TABLE_NAME where ref1.constname is null and ref2.constname is null and sit.TABLE_SCHEMA = …

Continue reading »

May 29

Installing notepadqq on Debian-based Linux

sudo add-apt-repository ppa:notepadqq-team/notepadqq sudo apt-get update sudo apt-get install notepadqq

Jan 09

Making a replacement lathe leadscrew nut

re_img_20170111_212102

My milling machine has a #3 Morse Taper spindle. I’ve spent a few days making #3 Morse Taper arbors from steel, which I’ll use to make various tools for my mill. Unfortunately this took a toll on my lathe’s topslide screw nut. That little bronze coil spring is actually the threads from inside the nut. …

Continue reading »

Dec 06

Windows Symbolic Links

C:\>mklink /? Creates a symbolic link. MKLINK [[/D] | [/H] | [/J]] Link Target /D Creates a directory symbolic link. Default is a file symbolic link. /H Creates a hard link instead of a symbolic link. /J Creates a Directory Junction. Link specifies the new symbolic link name. Target specifies the path (relative or absolute) …

Continue reading »

Oct 09

All-terrain Mobility Scooter, Part 4

small087

Shortly after this photo was taken, Pete said “Here, hold my beer and watch this!” The first test run of the drivetrain, with the wheels up on blocks and running at half power (12V). I needed the sprocket drives for two reasons: (a) The axles coming out of the motors weren’t nearly strong enough to …

Continue reading »

Sep 29

All-terrain Mobility Scooter, Part 3

Brackets constructed for axle housings, clamped up ready for welding. Axle housings and mounting plates. The axle housing on the left is upside down to show the construction. This is probably massively over-engineered, but I reckon it’s better to have a kilo too much chassis than a single gram too little. The loops leaning against …

Continue reading »

Sep 29

All-terrain Mobility Scooter, Part 2

I’m using some thick-walled steel pipe to make the bearing housings for the rear axles. My chop saw doesn’t cut perfectly squarely, and it tends to leave swarf behind on the cut. Same housing, with the swarf filed off. The axle is only going to be 17mm diameter, so the housings will extend all the …

Continue reading »

Sep 29

All-terrain Mobility Scooter, Part 1

small070

A few months ago I decided to build an all-terrain mobility scooter for a handicapped friend. This blog series will show the machine taking shape. This is an Ortho-Kinetics Triumph Model 4390 mobility scooter, circa 1990. This works OK for Pete, but isn’t too good over boggy or bumpy ground in the paddock. I bought …

Continue reading »

Aug 02

Windows msc commands

Computer Management compmgmt.msc Disk Manager diskmgmt.msc Local Users and Groups Manager lusrmgr.msc Scheduled Tasks taskschd.msc Services Management services.msc

Older posts «