Some useful site

1. A good guide to port usage is available on the web at
http://www.sockets.com/services.htm

2. A detailed database of file extensions and programs that use them at
http://filext.com/index.php

3. A detailed list of MIME type
http://www.w3schools.com/media/media_mimeref.asp

List all queries in AS400

I recently need list all queries in AS400 and get the definistion of the query.

To do that,
First, run following command,

DSPOBJD OBJ(*ALLUSR/*ALL) OBJTYPE(*QRYDFN) OUTPUT(*OUTFILE)
OUTFILE(WZJLIB/QRYLIST)

Second, for each query in the file, run following command to retrive the definition,

RTVQMQRY QMQRY(&ODLBNM/&ODOBNM) SRCFILE(WZJLIB/QUERIES) ALWQRYDFN(*YES)

the full CL program is named as LISTQUERY.