September 2011

Must try to get more of my notes, etc. here

Ayrton Senna

We've had a couple of quotes from Ayrton Senna (see left sidebar).
Some of his quotes relate to his qualifying laps at Monaco in 1988.
The laps he describes with a couple of sentences were breathtaking to watch.

Sometimes, when you see Bruno Senna sitting in a F1 car you can, just for moment, imagine it's Ayrton Senna.

DB2 versions

In general our SAP installs have included DB2 9.7.2.
SAP Global Trade Services is a bit odd in that it apparently requires DB2 9.1 (ours is 9.1.8).
So far this has caused us a couple of small problems:

• CLPPlus isn't distributed with, or available for, DB2 9.1
  That's a bit of a blow as some of our DB2 scripts use it.
• Sometime after DB2 9.1 implicit character conversion was introduced for string concatenation.
  We have a script to generate 'prune history' commands which was affected by this.
  It's easy to reproduce the error returned in 9.1

     Database Connection Information
  
   Database server        = DB2/LINUXX8664 9.7.2
   SQL authorization ID   = DB2
   Local database alias   = ED1
  
  db2 =>  select 'a' || 1 from sysibm.sysdummy1
  
  1
  --
  a1
  
     Database Connection Information
  
   Database server        = DB2/LINUXX8664 9.1.8
   SQL authorization ID   = DB2
   Local database alias   = GD1
  
  db2 => select 'a' || 1 from sysibm.sysdummy1
  SQL0440N  No authorized routine named "||" of type "FUNCTION" having
  compatible arguments was found.  SQLSTATE=42884

  The fix is simple enough though.

  db2 => select 'a' || char(1)  from sysibm.sysdummy1
  
  1
  ------------
  a1