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.

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>:

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
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.