× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



So thankful for the response to my last question. I'm banging my head on some of the nuances of get_clob_from_file.

We have successfully used the get_clob_from_file on the IBMi. Where I have manually placed the JSON on the IFS. We are attempting to automate the process.

We run PHP code on a linux machine. It reaches out to the cloud to pickup the json.
I have successfully picked up the file and placed in a windows server folder which is also mapped via QNTC.

I have successfully (with the help of a PTF) used get_clob_from_file with the file on the QNTC folder mapping via run scripts.
But I have not been able to get this to work from the PHP code. I do have an example that works from a native folder mapping on the IFS.

My unsuccessful statement looks something like this:
INSERT INTO RTL
(SQSID,CLQDATA)
VALUES ('SQSID',get_clob_from_file('/qntc/windows_server_folder/19b868fe.JSON')) WITH CS");

I get an SQL0443 - *N in *N type *FILE not found.

Is it not possible to do this? Or is there some nuance in the file path that I don't understand?

Thanks.
Vicki Wilson



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.