DB2

I have successfully connected from a DB2 client on my ThinkPad to the DB2 server on my Linux box, via TCP/IP, and performed a few queries. Which means I’m very close to getting Domino to do it. I’m sure before long I’m going to have nightmares about CATALOG TCPIP NODE SAMPLE REMOTE HOSTNAME 30000 ATTACH TO SAMPLE USER DB2USR1 USING PASSWORD CATALOG DATABASE SAMPLE AT NODE SAMPLE CONNECT TO SAMPLE USER DB2USR1 USING PASSWORD…

DB2

Wow, DB2 is old school IBM: SQL0119N An expression starting with “LASTNAME” specified in a SELECT clause, HAVING clause, or ORDER BY clause is not specified in the GROUP BY clause or it is in a SELECT clause, HAVING clause, or ORDER BY clause with a column function and no GROUP BY clause is specified. SQLSTATE=42803 I feel like I’ve been sucked back through a time warp to the era of Jurassic Computing, when mainframes ruled the earth…