RE: Use of the SQLDA - Example for SQL DESCRIBE TABLE

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

> Basically, I want to retrieve the column attribute information about a
> specific column in a table and create a duplicate of that column with a
> new name and then drop the old column name.  I can handle the column
> drop and copy of the data but the creation of an exact duplicate of the
> column is the difficult part.  The suggestion from Midrange-L was to
> use
> an SQL DESCRIBE TABLE function and retrieve the info into an SQLDA.
> Having never done that, I need an example to help me along.

If you're in RPG already, you may prefer to go after the QUSLFLD API instead
since that is (in my way of thinking) easier to digest than the DESCRIBE
TABLE complexities.  Just a thought.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"If you look like your passport photo, you're too ill to travel."
        -- Will Kommen