I am using the JTOpen JDBC driver to connect to the iSeries (aka AS/400, IBM System-i, IBMi, WTH?!…). I am having problems with a particular statement and it appears I need to go back to the actual SQL job QSQSRVR (or QZDASOINIT?) to find more details. Only problem is that there are hundreds of these on…
Tag: ibm-midrange
Add a column to a DB2/400 table with a specific ordinal position
Is there an SQL command on the AS400/iSeries/System-i/whatever to add a column to a table in a specific ordinal position, or moving an existing column to a different position? Answer IBM i 7.1 now allows you to add a column in front of another. ALTER TABLE table ADD COLUMN colname … BEFORE othercolumn