Yes. The INSERT...SELECT worked using a hardcoded value and the following DELETE using the variable worked fine!
Steve Needles
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Mildenberger
Sent: Tuesday, July 29, 2014 2:48 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: RE: Accessing Remote Database using SQL - requesting an SQL Package?
If you remove the variable from your SQL and just hard code a value does it then work ok?
Scott
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Needles,Stephen J
Sent: Tuesday, July 29, 2014 1:40 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: RE: Accessing Remote Database using SQL - requesting an SQL Package?
Ok...i figured out what caused the SQL0805 error...
The library I was developing in didn't exist on the remote_machine, so the compiler couldn't get the SQLPKG to the remote_machine. I had the library created on the remote_machine and now the SQL0805 error is gone. The SQLPKG had someplace to go that the compiler could recognize.
But now I get an SQL0312 error (Variable xxx not defined or usable), except that no variable is noted. And the only variable in the SQL is readily viewed when debugging the code in STRDBG.
"Variable not defined or not usable." Note: There are two blanks after "Variable" where the 'bad' variable should be. The description for this the SQL0312 message does not indicate what to do if there is no identified variable. I looked in the great and powerful internet and discovered that Google doesn't know everything. I found no references that were like this instance.
The only variable in that SQL is defined using like() from the table.
exec sql insert into local_machine.needles.test
(select * from remote_machine.needles.test
where key = :key );
dtest e ds extname(test)
d prefix(d_)
dtest_row ds
d key like(d_key)
Still struggling along.
Steve Needles
--
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:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
________________________________
This communication, including attachments, is confidential, may be subject to legal privileges, and is intended for the sole use of the addressee. Any use, duplication, disclosure or dissemination of this communication, other than by the addressee, is prohibited. If you have received this communication in error, please notify the sender immediately and delete or destroy this communication and all copies.
TRVDiscDefault::1201
midrange.com
