RE: Embedded SQL and RPG time out - montioring

Thanks. That’s helpful.

Paul Therrien
Ext. 2230
ptherrien@xxxxxxxxxxx

From: Daniel Gross <daniel@xxxxxxxx>
Sent: Friday, April 10, 2026 9:13 AM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Cc: Paul Therrien <ptherrien@xxxxxxxxxxx>
Subject: Re: Embedded SQL and RPG time out - montioring

Of course Paul - you can control the different timeouts with HTTP options - this is the second parameter of HTTP_GET. ht͏​​‌͏
[External email]<https://summary.us1.defend.egress.com/v3/summary?ref=email&crId=69d8fc0d9219f7d4f33e4420&lang=en>
External email <https://summary.us1.defend.egress.com/v3/summary?ref=email&crId=69d8fc0d9219f7d4f33e4420&lang=en>
[External email]<https://summary.us1.defend.egress.com/v3/summary?ref=email&crId=69d8fc0d9219f7d4f33e4420&lang=en>

Of course Paul - you can control the different timeouts with HTTP options - this is the second parameter of HTTP_GET.

https://www.ibm.com/docs/de/i/7.6.0?topic=functions-http-get-http-get-blob#rbafzscahttpget__HTTP_options<https://www.ibm.com/docs/de/i/7.6.0?topic=functions-http-get-http-get-blob#rbafzscahttpget__HTTP_options>

You should experiment with

- connectTimeout
- ioTimeout

and set the timeouts to your needs - and then check the SQL code and state.

HTH
Daniel



Am 10.04.2026 um 15:05 schrieb Paul Therrien via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx<mailto:rpg400-l@xxxxxxxxxxxxxxxxxx>>:
Is there a way in RPG with SQL to place a timeout on an sql statement.
We are using SQL to interface with Vertex and we hit an issue where the request to vertex never returned with a response. There was no error, the exec sql just sat there:

// Send request & receive response. Move response into responseText
exec sql
values qsys2.HTTP_POST (trim(:url), :requestText)
into :responseText;

Is there a way to force the SQL to error out or time out?
Is there a way to force qsys2.HTTP_POST to timeout?


Thanks for any help.

Paul
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx<mailto:RPG400-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l<https://lists.midrange.com/mailman/listinfo/rpg400-l>
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx<mailto:RPG400-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l<https://archive.midrange.com/rpg400-l>.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.