IBM i hints and tips #5 to #12

Don't want to lose these in the depths of Twitter.

Assorted #ibmi hints and tips #5 : how to improve usability of CL commands very easily - great tool at http://www.itjungle.com/fhg/fhg092204-story01.html

Assorted #ibmi hints and tips #6 : RTVQMQRY ALWQRYDFN(*YES) allows retrieval of the equivalent SQL from a Query definition (*QRYDFN object)

Assorted #ibmi hints and tips #7: IBM i Access value add: socket level ping: cwbping any-hostname-or-ip-address /port:any-port-you-like

Assorted #ibmi hints and tips #8 : Limiting the size of an SQL result set : FETCH FIRST n ROWS ONLY

Assorted #ibmi hints and tips #9 : Want to know the total size of a library? DSPLIB to a spool file shows it at the bottom

Assorted #ibmi hints and tips #10: Hints for creating a usable AFP overlay from a letterhead stored in Microsoft Word: http://short.zen.co.uk/?id=1255

Assorted #ibmi hints and tips #11: To get a list of IFS items: RTVDIRINF. 2 linked outfiles:…D hierarchy,…O list of stream files/directories

#ibmi hints & tips #12: Spool files for jobs that change user belong to the current user, not to the job. OVRPRTF SPLFOWN(*JOB) changes this