|
I have a SELECT in an RPG program that joins an existing view MYVIEWto
(in QTEMP) and a table MYTABLE. I tried to declare the combined input
buffer like this:
d ddLWRK1 e ds ExtName(MYVIEW)
d ddLWRK2 e ds ExtName(MYTABLE)
d ddLWRK ds Qualified
d ddLWRKDS1 LikeDS(ddLWRK1)
d ddLWRKDS2 LikeDS(ddLWRK2)
and my fetch would be:
exec sql
FETCH SqlCsr Into :ddLWRK;
But I get an "SQL0312: Position 40 Variable DDLWRK not defined or not
usable" error
Is it even possible to do what I'm attempting - i.e. avoiding having
define the input fields manually?************************************************************************
We're currently on bare-bones release 7.1.
Thanks,
Trevor Briggs
Analyst/Programmer
Lincare, Inc.
(727) 431-1246
TBriggs2@xxxxxxxxxxx
This message originates from Lincare Holdings Inc. It containsinformation which may be confidential or privileged and is intended only
It is prohibited for anyone else to disclose, copy, distribute or usethe contents of this message.
All personal messages express views solely of the sender, which arenot to be attributed to Lincare Holdings Inc., and may not be copied or
If you received this message in error, please notify us immediately atMailAdmin@xxxxxxxxxxx or (800) 284-2006.
************************************************************************
As an Amazon Associate we earn from qualifying purchases.
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.