RE: SQL SYSKEYS table question

I still have a copy of MS DOS 5.0 if you need it. :)

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
DrFranken
Sent: Monday, July 20, 2015 8:41 PM
To: Midrange Systems Technical Discussion
Subject: Re: SQL SYSKEYS table question

WARNING: Failure to disclose the solution to a problem no matter how simple
when you have requested help may result in:

1) Pointing and laughing.
2) Temporary banishment from asking new questions.
3) Random unrelated answers being provided to your next query (e.g.
PWRDWNSYS *IMMED or DELETE FROM SYSKEYS or ...)
4) And in extreme cases we'll send you a copy of Windows 95. On floppies.
Out of sequence.

- Larry "DrFranken" Bolhuis

www.Frankeni.com
www.iDevCloud.com - Personal Development IBM i timeshare service.
www.iInTheCloud.com - Commercial IBM i Cloud Hosting.

On 7/20/2015 1:29 PM, Englander, Douglas wrote:

Never mind. I just answered my question below.


-----Original Message-----
From: Englander, Douglas
Sent: Monday, July 20, 2015 12:29 PM
To: 'midrange-l@xxxxxxxxxxxx'
Subject: SQL SYSKEYS table question


We are on V7R1.

I noticed when I run a SELECT statement on the SYSKEYS table for a

specific index, not all of the key fields are returned. Specifically, the
first key field seems to be missing. Has anyone else experienced this, and
if so, do you know how I can find the first column name of a key?

Thank you,

Doug

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.