On September 30th, 2015 we presented a webcast titled Easy Mobile Development With Profound Logic Software (click the link to watch a recording of our webcast.) This page provides the sample code from that webinar.
SQL source for HISTFILE (member HISTFILE of QSQLSRC)
Rich Display File DDS source for SCANITEMD (member SCANITEMD of QDDSSRC)
RPG source for SCANITEMR (fully free format. member SCANITEMR of QRPGLESRC)
We also have alternate versions of the RPG code for those not yet using fully free format RPG.
Free format calcs version (/free and /end-free) (alternate member SCANTEMR of QRPGLESRC)
Fully fixed-format version (alternate member SCANITEMR of QRPGLESRC)
To use this source code, download the SQL source, Display File Source, and one of the RPG options above and place them in source members on your IBM i. (Copy/paste into RDi is the easiest way to do that.)
To compile the objects, use these steps:
RUNSQLSTM SRCFILE(QSQLSRC) SRCMBR(HISTFILE) COMMIT(*NONE) ERRLVL(20)
CRTDSPF FILE(SCANITEMD) SRCFILE(QDDSSRC)
CRTSQLRPGI OBJ(SCANITEMR) SRCFILE(QRPGLESRC)