RE: more of an sql question

Use SYSKEYS.

-Matt


-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jay Vaughn
Sent: Wednesday, November 15, 2017 9:38 AM
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxx>
Subject: Re: more of an sql question

Thanks Dave - i ran across syscolumns but couldn't find which column indicated column was a key.??

On Wed, Nov 15, 2017 at 11:17 AM, <dlclark@xxxxxxxxxxxxxxxx> wrote:

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 11/15/2017
11:09:02
AM:

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 11/15/2017
10:51:46
AM:

Is there an sql catalog table I can query to return key fields for
a particular PF/Table?

I have used SYSCOLUMNS for this.

There is also SYSKEYS.


Sincerely,

Dave Clark
--
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300

Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331




************************************************************
*********************************
This email message and any attachments is for use only by the named
addressee(s) and may contain confidential, privileged and/or
proprietary information. If you have received this message in error,
please immediately notify the sender and delete and destroy the
message and all copies. All unauthorized direct or indirect use or
disclosure of this message is strictly prohibited. No right to
confidentiality or privilege is waived or lost by any error in transmission.
************************************************************
*********************************
--
This is the RPG programming on the IBM i (AS/400 and iSeries)
(RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.co
m_mailman_listinfo_rpg400-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPv
SZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=AJI1Ot1
b_ivRCLzk0HbvTndGht7LMv7LzGTuKiAvU3I&s=dnwVf2-A3X9PCqkpSs73j0RFSGYmdoS
4Ub6UUHIeo04&e= or email: RPG400-L-request@xxxxxxxxxxxx Before
posting, please take a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_rpg400-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=AJI1Ot1b_ivRCLzk0HbvTndGht7LMv7LzGTuKiAvU3I&s=Reqc61txYxm0VZROfxNM4P2oZ1pUdHkv8ZPciaVQO-8&e=.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=
DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJh
t2RKpmz7qvL2YDU_M-VhnRH6r43I&m=AJI1Ot1b_ivRCLzk0HbvTndGht7LMv7LzGTuKiA
vU3I&s=TLTqpQnja0a4ZvzpssM09n1lzvtZI5bgssUd1mikNQ0&e=

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_rpg400-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=AJI1Ot1b_ivRCLzk0HbvTndGht7LMv7LzGTuKiAvU3I&s=dnwVf2-A3X9PCqkpSs73j0RFSGYmdoS4Ub6UUHIeo04&e=
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_rpg400-2Dl&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=AJI1Ot1b_ivRCLzk0HbvTndGht7LMv7LzGTuKiAvU3I&s=Reqc61txYxm0VZROfxNM4P2oZ1pUdHkv8ZPciaVQO-8&e=.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_2dEadiD&d=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=AJI1Ot1b_ivRCLzk0HbvTndGht7LMv7LzGTuKiAvU3I&s=TLTqpQnja0a4ZvzpssM09n1lzvtZI5bgssUd1mikNQ0&e=