Re: SQL - Creating a duplicate of an existing column

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

DESCRIBE may do the trick, I think you need the SQLDA for that, but is
according to me required in some aspects, as you want ageneric solution..

With regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 16-12-2009 at 14:34 Pete Helgren wrote:

> 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
list
> 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.