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 thread ...

Follow-Ups:
Replies:

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.