IBM Support

New HTTP functions based in QSYS2



These HTTP services are used to make HTTP requests that use web services. These functions allow the
SQL programmer to use Representational State Transfer (RESTful) via SQL, including Embedded SQL. The
services provide the same capabilities as the SYSTOOLS HTTP functions without the overhead of creating
a JVM.

The services use the HTTP transport APIs that are part of the Integrated Web Services (IWS) client for ILE support.


You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Functional Enhancements > New HTTP functions based in QSYS2

These HTTP functions exists in QSYS2 and have lower overhead than the SYSTOOLS HTTP functions.
Additional benefits of the QSYS2 HTTP functions are HTTP authentication, proxy support, configurable
redirection attempts, and configurable SSL options.

Enhanced with IBM i 7.5 SF99950 Level 1, IBM i 7.4 SF99704 Level 20, and IBM i 7.3 SF99703 Level 28:

  • Add HTTP_PATCH scalar function
  • Add HTTP_PATCH_VERBOSE table function
  • New header option, verboseResponseHeaderFormat, that specifies how the information in the RESPONSE_HTTP_HEADER column of the HTTP_xxx_VERBOSE functions is to be returned

[{"Type":"MASTER","Line of Business":{"code":"LOB57","label":"Power"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000000C4BAAU","label":"IBM i"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"7.3.0;7.4.0;and future releases"}]

Document Information

Modified date:
03 May 2022