Embedded SQL and RPG time out - montioring

Paul Therrien via RPG400-L <[email protected]> Fri, 10 Apr 2026 13:05:08 +0000

Newsgroups	gmane.comp.lang.as400.rpg
Message-ID	<CH3PR22MB4516AD2FE7E3BED1D927101DF1592@CH3PR22MB4516.namprd22.prod.outlook.com>

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

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.