############### USEFUL NOTES ###############
list file fields
output is spool
lstffd [program]
desc fields
Desc type: PRMT15
Desc Key: PSAR15
Desc Desc: PRMD15
Desc limit: PRML15
Find what menu calls a program
WHATMENU Wrkqrys OPSQRYS
Turn date into what system uses
%Dec(%Char( [datevar] :*cymd0):7:0);
Compile sql rpg program with source code
CRTSQLRPGI joshualib/packlist  DBGVIEW(*SOURCE)
View spools of active session (for dumps)
WRKUSRJOB CHANP *ACTIVE
LDA
WRKLDA
LIBRARIES
Live source: OSLPUMAPS3
Live objs: OSLPUMAPP3
Live Data: PUMOSLAPF1
Test Data: OSLTSTAPF1
Send email to calling user
PACKLIST is an example of this
View Dump
WRKJOB [program name]

IBM i access solutions has macro recording and keybinding.

When you log into test, do this:
/excel
1
F3
F12
You've now quickly set up your library list.

Shift+Escape then enter 90 to quit session.