RE: RPG/SQL : Column Labels getting renamed?!

Sorry for the vagueness, I'm pretty frustrated with the situation..


- My Java program, calls an iSeries strored procedure, via a
CallableStatement.
- The stored procedures wrappers my RPG program.

- The RPG program builds my select statement, that looks something like
this.
- SELECT TRIM(FIELD1) as
dft_orderinquiryoption_numberofpriormonths FROM ITEMFILE;

- The Cursor is then declared, prepated & opened.

- The ResultSet is extracted out, within my Java (CallableStatement) call.

- I use the ResultSet's metadata, to extract out the columns names &
labels.

And my result is : dft_o00001


Hopefully that makes sense.



David L. Mosley, Jr.
Technical Solutions Architect
Dancik International, Ltd.
2000 CentreGreen Way, Suite 250
Cary, NC 27513

www.dancik.com



"Dennis Lovelady" <iseries@xxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
11/18/2010 12:09 PM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>


To
"'RPG programming on the IBM i / System i'" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
RE: RPG/SQL : Column Labels getting renamed?!






When you say your column labels are being renamed, where are you seeing
these labels? iSeries stores two names for columns (always had). One is
a
short name that's picked up by RPG and several other "utilities." The
other, often called ALIAS, is used, for example, by "COPY DD-ALL-FORMATS"
in
COBOL. Either/Both may be used in SQL.

What are the details behind the issue?

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
Light travels faster than sound. This is why some people appear bright
until
you hear them speak.

I have a stored procedure wrapper around an RPG program. The RPG
program
is
opening a dynamic SELECT statement. The open cursor is then passed
back
to the client (in this case a Java call),
and is building a simple Hashtable, using the column labels and their
values.

The problem is some of my larger column labels are getting renamed, to
the
IBM 10-character standard.

Example :
Label :
dft_orderinquiryoption_numberofpriormonths
Renamed to : dft_o00001

We are on V6R1, and I thought this stuff taken care of when V5Rx came
around.
Per the V5R3 documention, the Maximum length of column label is 60.


Any ideas would be greatly appreciated.

Thanks
David

David L. Mosley, Jr.
Technical Solutions Architect
Dancik International, Ltd.
2000 CentreGreen Way, Suite 250
Cary, NC 27513

www.dancik.com
--
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.