RE: Debugging embedded SQL statements.

Use a dimmed DS with at least one element ( DIM(1) ) and "FETCH ..... for 1 rows into :DSARRAY". SQL code in RPG then does DS moves and reduces the amount of debug steps you have to take.

-Matt

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Jason Olson
Sent: Tuesday, May 14, 2019 8:21 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Debugging embedded SQL statements.

So one thing that has been bugging me for a while now is debugging certain SQL statements in RPGLE. The ones specifically I"m talking about are the ones that move data into data structures. For each field you have to keep hitting step into or step over until all the data has been moved into the DS. Is there a way like no debug IO where I can just step over that statement and it's complete? For now I have been using breakpoints, but that gets annoying too.


Thanks,

Jason E. Olson
IBM i Engineer/Developer
josys36@xxxxxxxxx
480.223.2952
--
This is the RPG programming on IBM i (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=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=Q5HNHzuJHBzRJs83oYIvnZklaFPK7YUIsV4fJ4qTQ9U&s=21z3MhYr1gW4DQ4qcDLwGh58ek5q7As8Lt7PktPvfho&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=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=Q5HNHzuJHBzRJs83oYIvnZklaFPK7YUIsV4fJ4qTQ9U&s=YyPEfEFeFWYojGuokXBhtPeulXgAqIjomhV3xcZb6-U&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=DwICAg&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=Q5HNHzuJHBzRJs83oYIvnZklaFPK7YUIsV4fJ4qTQ9U&s=q4x_qun_LWZEM0a9vYFT9aU_G0C7vbtQxOZZMoHvlP8&e=