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..."