RE: Changing a table to have a new column before existing columns

Martin, if you are on V5R2, this might get you where you need to be:

CREATE TABLE lib/tblNew AS (SELECT f1, 0 AS newColumn, f2 FROM lib/tblOld)
WITH DATA

This will create a copy of the table "tblOld" with its data and name the new
table "tblNew".  
Trick is to order the column names as you'd like them and then insert the
"newColumn" where you'd like it.
Of course you can use WHERE and all the other normal SQL syntax, nested
selects etc.  Simple example listed above is just to illustrate the idea.
Let us know how it goes.

Elvis