Programming Languages on Power

Power Programming Languages

IBM Power, including the AIX, IBM i, and Linux operating systems, support a wide range of programming languages, catering to both traditional enterprise applications and modern development needs.


#Power

 View Only

  • 1.  JSON_TABLE with HTTP_POST_VERBOSE Example

    Posted Mon December 05, 2022 06:50 PM
    Edited by Amy Vozza Mon December 05, 2022 07:37 PM
    Can someone point me to an example of using JSON_TABLE to parse out the RESPONSE_MESSAGE and the RESPONSE_HTTP_HEADER from an HTTP_POST_VERBOSE?  Sorry, I realized after this that I really wanted an example of an HTTP_GET_VERBOSE.  

    ------------------------------
    Amy Vozza
    ------------------------------
    #SQL


  • 2.  RE: JSON_TABLE with HTTP_POST_VERBOSE Example

    Posted Tue December 06, 2022 02:44 AM
    Dear Amy

    I hope you find one sample in this article :  https://www.linkedin.com/pulse/fun-sql-ep-01-covid-data-bob-cozzi/      This sample does not use certificate. For one using certificate :

    Example

    • Retrieve service information from the IBM® PSP website using a certificate store created from a Java™ certificate store. See SSL considerations for more information. 
      
SELECT * FROM TABLE(QSYS2.HTTP_GET_VERBOSE(
                         'https://www.ibm.com/support/pages/sites/default/files/inline-files/xmldoc.xml',
                         '{"sslCertificateStoreFile":"/home/javaTrustStore/fromJava.KDB"}'));


    ------------------------------
    Right action is better than knowledge; but in order to do what is right, we must know what is right.
    -- Charlemagne

    Satid Singkorapoom
    ------------------------------

    Original Message


Related Content