search

zendtech / IbmiToolkit

PHP frontend to XMLSERVICE for IBM i development.
BSD 3-Clause "New" or "Revised" License
46 stars 34 forks source link

Eliminate hard-coded plug sizes in iToolkitService.php #70

Open alanseiden opened 8 years ago

alanseiden commented 8 years ago

Eliminate hard-coded plug sizes in iToolkitService.php and newer classes. E.g. 1M for spool file retrieval. Perhaps configure default plug sizes for specific task types as a better way to specify defaults.

alanseiden commented 8 years ago

Consider migrating miscellaneous iToolkitService.php functionality to DB2 Services and code examples.

alanseiden commented 4 years ago

We suggest providing documentation and examples of spool file tasks via IBM i SQL Services as an alternative to using this iToolkitService class. Aside from the hard-coded plug size and other limitations of this class, it requires a special service program shipped only with Zend Server and not with the RPMs. When examples have been created of spool file retrieval via IBM i Services, this issue can be closed.

alanseiden commented 4 years ago

What we need to replace is: GetSPLF($SplfName , $SplfNbr, $JobNmbr, $JobName, $JobUser . We suggest we write an SQL query, at first just as a sample for users, and perhaps later as a compatibility layer, that retrieves spool file data given the parameters:

Refer to https://www.rpgpgm.com/2019/05/using-sql-to-retrieve-data-from-spooled.html for details about SYSTOOLS.SPOOLED_FILE_DATA, which became available in IBM i v7.3, TR6.