× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.