Re: Key field info

Tony,

Your looking in the header section for the api, not the generic header 
section.  Once again, on the V5R3 infocenter for QUSLFLD you'll see:

Format of the Generated List
The field list consists of:

A user area 
A generic header 
An input parameter section 
A header section 
The FLDL0100, FLDL0200, or FLDL0300 list data section 
For details about the user area and generic header, see User space format 
for list APIs. 

And you'll notice that 'User space format for list APIs' is blue 
underlined indicating it is a hot link.  The properties of that hot link 
is
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/info/apis/usf.htm

Scott and I ain't $hitting you buddy.

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





Tony Carolla <carolla@xxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
09/23/2004 12:36 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


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

Fax to

Subject
Re: Key field info






On Thu, 23 Sep 2004 11:36:12 -0500, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:
> Frankly reading the file QSYS2/SYSCOLUMNS will tell you most of the
> information in that API.
> 
> Basic property of api's is to check out the list header.  See the 
section
> For details about the user area and generic header, see User space 
format
> for list APIs.
> or
> 
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/info/apis/usf.htm

> This will return the number of list entries.
> 
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 


Thanks Rob.

All of the information I have on APIs is located at IBM's site -- I
don't even have QSYSINC loaded, so I have to hand-code the PR's (oh,
the agony -- never forget that Binary4 = 10I 0!!!).

In the description of the QUSLFLD API, in the header section, I don't
see anything indicating the number of fields returned.  I know that
this is the norm, but I am not seeing it for this API.

I looked in QSYS2/SYSCOLUMNS, and I don't see a field that indicates
which fields are keys.  I looked in several of the views in QSYS2
(syskeys, syskeycst, systables, sysindexes), and I don't see any
columns in these views that tell the key fields.



-- 
"Enter any 11-digit prime number to continue..."
--
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.