I don’t think you are allowed to use the "exec sql execute Stmt1 into :wField..." into part of the statement with the "execute" statement.

You have several other options but if the statement is that simple just use,

exec sql select AFIELD into :wField from aMachine/aLibrary/aFile where rrn(aFile) = :wSeed:

Prepare is best suited for statements that need to be dynamically built because their structure changes, mainly in the WHERE clause.


-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Booth Martin
Sent: Thursday, January 24, 2019 4:09 PM
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Subject: SQLRPLE prepare statement into

       exec sql prepare Stmt1 from
          'select AFIELD from aMachine/aLibrary/aFile'
               + ' where rrn(aFile) = ?';
       exec sql execute Stmt1 into :wField using :wSeed;

SQL0104 Token : was not valid. Valid tokens: SQL DESCRIPTOR

What is missing?  I am finding nothing that I understand about DESCIPTORs

This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx 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=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=VnqbpmhuinCuFGzZNLKlLOzfcZ4x1lK1z-Q1UAL3pp0&s=oZrHpR9J2wb2KH1i3L3M0a4HD4uFUXa3OCjBTBmH0dQ&e=
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
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=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=VnqbpmhuinCuFGzZNLKlLOzfcZ4x1lK1z-Q1UAL3pp0&s=GHbdp5BKJSnR7g4yat0ZYTci7gryPfzzoPfY7Es5nuU&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=https-3A__amazon.midrange.com&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=VnqbpmhuinCuFGzZNLKlLOzfcZ4x1lK1z-Q1UAL3pp0&s=-FmLyzIdIKXqh3EopWOki3zw3rzXZQKuoZe5pSDzquY&e=

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].