Eliminate hard-coded plug sizes in iToolkitService.php

[alanseiden]

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]

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

[alanseiden]

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]

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:

• Spool file name
• Spool file number
• Job number
• Job name
• Job user

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.