IBM i Global

IBM i 

A space for professionals working with IBM’s integrated OS for Power systems to exchange ideas, ask questions, and share expertise on topics like RPG and COBOL development, application modernization, open source integration, system administration, and business continuity.


#Power


#IBMi
#Power
 View Only

  • 1.  New sql http function in qsys2 RFE

    Posted Wed February 16, 2022 03:01 AM

    Hi IBM i community,

    have you tried the new sql http functions in qsys2?
    I personally find them very fast, and above all they no longer use java. When the http functions of the systools came out we made extensive use of them, now I find myself on the system dozens of open JVMs that take up a lot of RAM, with all the problems related to Java, including CLI interface errors. (have you ever tried to do an http_get_clob and then a cpyfrmimpf in the same job?)
    So the new functions for me are better. But there is no possibility to download a binary file, such as a .zip. This is why I made this RFE, please vote it!

    https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=154150

    Many thanks



    ------------------------------
    Paolo Salvatore
    ------------------------------


  • 2.  RE: New sql http function in qsys2 RFE

    Posted Thu February 17, 2022 08:38 AM
    in a recent DB2 group a new set of "http" functions were released.
    some do not require JAVA, so maybe they would work for you.

    New HTTP functions added to SYSTOOLS
    -and-
    HTTP functions

    the following has existed for a very long time and works quite well.
    Hypertext Transfer Protocol API
    Scott still supports it.











    ------------------------------
    Bryan Dietz
    ------------------------------

    Original Message


Related Content