RE: Syntax for doing an SQL - select splat and append RRN

From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
JRusling@xxxxxxxxxxx
Sent: Thursday, May 3, 2018 8:38 AM
To: midrange
Subject: Syntax for doing an SQL - select splat and append RRN

Hello,

I want to be able to pass a key from my list (work with) rpg program

edit panel rpg program.
(noone here has heard of unique keys..., list panels either for that

<g>)

In the list program i want to fetch it into this data structure -
dcl-ds listds extname('EDIMAST') qualified ;
rrn int(10) ;
end-ds ;

I can implicitly list each field from the file, followed by

. . that works but. ...

select *,rrn(edimast) from edimast

is just easier (if it worked)

I've rearranged the syntax many ways and no luck.

Has anyone done this or have i ventured into deal-breaking sql syntax

Thanks for any help,

John
<br />
The information in this email is confidential and may be legally

It is intended solely for the addressee. Access to this email by

unauthorized. If you are not the intended recipient, any disclosure,

distribution or any action taken or omitted to be taken in reliance on

prohibited and may be unlawful.
--
This is the RPG programming on the IBM i (AS/400 and iSeries)

mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To

unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD