Sending a trigger file from the IBM i to an HTTPS server website

Tags:
HTTPS
IBM i
Hello, first of all, we haven't done this before so we'd like to find out if it can be done or not. We have a new project that requires us to to send a trigger file from our IBM i using the HTTPS protocol. Basically, when our database file on IBM is available for update, we have been asked to send a trigger file to an HTTPS URL so that they can perform an SQL on our file, and perform an update. Once the file has been updated, we will set up a process to send another trigger file saying something like the file update is completed. Can someone tell me how we can send the trigger file from our IBM i?  note that our IBM is is a V7R2 O/S, with C8032720 cume package.
Thanks in advance for your help.


Software/Hardware used:
IBM i DB2/https url
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    A trigger file need something to fire on. Usually an add , update or delete. I'm not sure how you would get it to fire when a file is not in use. Can this happen more than once a day? What do you need to send the url, just a simple text file in a specific format or something else. How are the going to do the SQL update? Will they run a job or login remotely and run the SQL statement? If they are running the SQL they should know when the update is finished and you should not have to do anything else. Provide as much detail as you can so we can better understand the project needs.
    0 pointsBadges:
    report
  • TheRealRaven
    Please clarify "send" and "trigger file". What exactly will be 'sent'? Are you simply sending some object that will signal the remote system when updates are allowed or restricted, later sending an object that reverses state?

    Are you also managing connections on the DB2 side? What happens if updates are executed during restrictions?
    35,640 pointsBadges:
    report
  • Subhendu Sen
    Who are they that perform an SQL on your file? Is there an external consultant who does this job ? However what type of job that you did not reveal. Database means what? Is it NSF/or other type of file?
    0 pointsBadges:
    report
  • GregManzo
    I assume where you mention 'send a trigger file', you are talking about sending a flag file with a pre-determined name, the existence of which will cause some process to be run on the HTTPS server? The contents are not important, just the name. (On an IBMi we are used to 'trigger' having a very different meaning).
    If my assumption is correct, then you need to have some process that can determine 'available for update'. This could be something that occasionally tries to get an *EXCLRD lock on the file then sends your flag-file.
    There are lots of ways to achieve this; which is best would depend more on the design of the rest of your systems. eg. if we were to do something similar it would be a 'sleeper' job that spends most of its time in a DLYJOB, wakes up every 2 minutes, test for controlled shutdown, test for the lock, go back to sleep.
    2,960 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: