Re: SQL - Creating a duplicate of an existing column

I have a Java application that uses JDBC to the DB2 for i database on my
i. It is using a RENAME COLUMN function that isn't yet supported by DB2
(someday....). In any case, since I can't change the application I'd
like to build a stored procedure to handle the function. I propose to
do something like:

"ALTER TABLE #{table_name} ADD COLUMN #{new_column_name}"
"Update #{table_name} set #{new_column_name} = #{column_name}"
"Alter table #{table_name} drop column #{column_name}"

The kicker is, in order for this to be generic and work, I have to
retrieve the attributes of the column I want to rename and copy and I
don't know how to do that. Does anybody have an SQL method for
retrieving attributes of a column so that they can be used to create a
column with the same attributes?

Thanks

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.