|
Hi Mike,
Thanks for your reply.
I'm sorry I'm not sure what you mean by "3 Part SQL" would it be possible
for you to elaborate a little?
The DDM is not my design and I'm not married to it so if there is a way you
think is preferable I'm certainly open to suggestions.
thanks kindly,
Craig
On 5 January 2018 at 16:46, Mike Jones <mike.jones.sysdev@xxxxxxxxx>
wrote:
Hi Craig,use
I've not tried that specific DDM example, but I have successfully used
IDENTITY_VAL_LOCAL() when I connected to, for example, system A, and I
3 part SQL referencing system B involving INSERTs into a table on systemuse,
B. That is an alternative to use, and in my opinion is preferable to
versus the DDM route to get that done.(RPG400-L)
Mike
On Fri, Jan 5, 2018 at 4:27 AM, Craig Richards <craig@xxxxxxxxxxxxxxxx>
wrote:
Hi All,File?
Does anyone know offhand if you can use Identity_Val_Local() on a DDM
to
I don't have the opportunity to test this at the moment but I will need
tweak my design if not.
Specifically:
1. Client on LPAR 1 has a DDM File pointing to a file on LPAR2.
2. The file on LPAR2 has a "generated always as identity" column.
3. Client on LPAR 1 writes a record to the DDM File
4. Can the client then use identity_val_local() to retrieve the
generated column value?
Thanks kindly in advance,
Craig
--
This is the RPG programming on the IBM i (AS/400 and iSeries)
--mailing list--
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, 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
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://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
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://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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.