RE: Retrieving the DDS field description in an RPG program

By the way, the SQL catalog is QSYS2/SYSCOLUMNS.

I like API's as much as anyone.  And I've coded at least 4 of them in a 
program today.  However, that file beats an API hands down.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Bob Cozzi" <cozzi@xxxxxxxxx> 
Sent by: rpg400-l-bounces+rob=dekko.com@xxxxxxxxxxxx
07/13/2004 02:33 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
RE: Retrieving the DDS field description in an RPG program






Mike,
Once you've seen all the stuff you have to code to get the field
descriptions, you might consider using the CrtFldList() procedures in the
RPG xTools library. Or if you don't have or can't get the xTools, use the
SQL Catalog which contains most of the information you need.
-Bob Cozzi
www.rpgxtools.com

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Martin Rowe
Sent: Tuesday, July 13, 2004 2:27 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Retrieving the DDS field description in an RPG program

On Tuesday 13 July 2004 18:22, Dan Bale wrote:
> Try the QUSLFLD API.
>
> hth, db
>
> > -----Original Message-----
> > From: rpg400-l-bounces@xxxxxxxxxxxx / mikesoucy1262@xxxxxxxx
> > Sent: Tuesday, July 13, 2004 12:59 PM
> >
> > Is there a way to retrieve the DDS field description (COLHDG or
> > TEXT) value from a file that is defined on a F-spec in RPG?  I
> > have a program that I am writing where I would like to get the
> > value of the TEXT paramter for the fields in a DDS file that I am
> > using.  Any feedback would be greatlty appreciated

Hi Mike

You can see an example of QUSLFLD getting those values here:

http://dbg400.homeip.net/cgi-bin/viewcvs.cgi/*checkout*/dbg400/QRPGLESRC/DBG

201R4.rpgle

Regards, Martin
-- 
martin@xxxxxxxxxx  AIM/Gaim: DBG400dotNet  http://www.dbg400.net   /"\
DBG/400 - AS/400 & iSeries Open Source/Free Software utilities     \ /
Debian GNU/Linux | ASCII Ribbon Campaign against HTML mail & news   X
                                                                   / \
--
This is the RPG programming on the AS400 / iSeries (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.



--
This is the RPG programming on the AS400 / iSeries (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.