Add a column to a DB2/400 table with a specific ordinal position

sql db2 ibm-midrange db2-400
jwl picture jwl · Oct 20, 2009 · Viewed 16.2k times · Source

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

David G picture David G · Jun 3, 2010

IBM i 7.1 now allows you to add a column in front of another.

ALTER TABLE table ADD COLUMN colname ... BEFORE othercolumn

Related questions

Add a field description to a DB2/400 file

I have a set of files in a library on an AS/400/iSeries/System-I/whatever-IBM-wants-me-to-call-it-these-days which I do not have DDS for (created in SQL I gather) but to which I would like to add field descriptions. I cannot find …

Read More
to_date with AS400

I am writing to you because I can't use the operator to_date on an AS400 database. With Oracle database, I use: datefield >= to_date('01/01/2014','DD/MM/YYYY') But with AS400, I get an error: Incompatible operator …

Read More
Update 1 field in a table from another field in a different table (OS400, not a 1 to 1 relationship)

Im trying to update a field in a table from another field in a different table. The table being updated will have multiple records that need updating from 1 match in the other table. Example, i have a 1 million row sales …

Read More