|
Thanks Charles & Aaron,
That was exactly what I was looking for. I think it was throwing me off because it was in the zendsvr folder.
For the job scheduler, I should be able to put "QSH CMD('/usr/local/zendsvr6/bin/php /scripts/php/fetchXMLforETL.php')" I haven't tried this, but wanted verification first.
Eventually, I'll probably create a QSH script, as Charles eluded to, to run multiple scripts an sequential order. But needed to start somewhere.
Thanks guys.
-JA-
Jason Aleski / IT Specialist
On 10/30/2015 12:57 PM, Aaron Bartell wrote:
Here's the php binary...
$ /usr/local/zendsvr6/bin/php -version
PHP 5.6.5 (cli) (built: Feb 1 2015 02:36:55)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2014 Zend Technologies
with Zend OPcache v7.0.4-dev, Copyright (c) 1999-2014, by Zend
Technologies
with Zend Extension Manager v8.0.0, Copyright (c) 2003-2014, by Zend
Technologies
- with Zend Data Cache v8.0.0, Copyright (c) 2004-2014, by Zend
Technologies [loaded] [licensed] [disabled]
- with Zend Job Queue v8.0.0, Copyright (c) 2004-2014, by Zend
Technologies [loaded] [not licensed] [disabled]
- with Zend Utils v8.0.0, Copyright (c) 2004-2014, by Zend Technologies
[loaded] [licensed] [enabled]
- with Zend Code Tracing v8.0.0, Copyright (c) 2009-2014, by Zend
Technologies [loaded] [not licensed] [disabled]
- with Zend Server Z-Ray v8.0.0, Copyright (c) 1999-2014, by Zend
Technologies [loaded] [not licensed] [disabled]
- with Zend Monitor v8.0.0, Copyright (c) 1999-2014, by Zend
Technologies [loaded] [licensed] [disabled]
- with Zend Debugger v6.0.0-i5, Copyright (c) 1999-2014, by Zend
Technologies [loaded] [licensed] [enabled]
- with Zend Page Cache v8.0.0, Copyright (c) 2004-2014, by Zend
Technologies [loaded] [licensed] [disabled]
- with Zend Monitor UI v8.0.0, Copyright (c) 2004-2014, by Zend
Technologies [loaded] [licensed] [enabled]
PASE is more or less AIX.
Aaron Bartell
litmis.com - Services for open source on IBM i
On Fri, Oct 30, 2015 at 9:42 AM, Jason Aleski <jason.aleski@xxxxxxxxx>
wrote:
I am relatively new to working on the iSeries. In the past (for a
previous non-IBMi employer), I've written PHP scripts on a Linux server
that would perform ETL functions on a web service and store the data to
local SQL server. The PHP script would not require a web server and run
from the CLI via cron. In the cronjob, I would call "0 1 * * *
/usr/bin/php /opt/scripts/fetchXMLData.php" every morning at 1:00am. I
would like to do the same on the iSeries to eliminate the need of building
a linux server, but I'm not sure how to call PHP and the script from
CLI/PASE; which would eventually be called from WRKJOBSCDE. Can anyone
point me in a direction; if this is even possible?
-JA-
--
Jason Aleski / IT Specialist
--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.
As an Amazon Associate we earn from qualifying purchases.
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.