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

I am looking for an example of using an SQLDA with a DESCRIBE TABLE
function in an RPG program.  I found a few general examples of using an
SQLDA in RPG but nothing specific that would help me unpack the
complexities of the SQLDA.  The goal is to eventually package this into
a stored procedure that will mimic the RENAME COLUMN function that is
missing in DB2 for i.

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.

I would love to do this only with SQL and without a stored procedure and
I came up with a hack to make it work but there are some potential
issues with the approach I have taken and so a stored procedure is
probably the best route to go.

Anyone have an example or a code snippet that would illuminate the basic
steps?

Thanks

Pete

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.