AS400 Cheat Sheet.

1. How to view version of AS400:
1. GO LICPGM -> 10 -> F11
2. DSPSFWRSC (display software resources Hit F11 to see version)

2. How to create a new database on AS400 using any sql tool
create collection databasename (new schema command)

3. Clear contens of a file
clrpfm library/filename (clear contents of a file)

4. Get IP address of as400
On the iSeries you can use CFGTCP option 10.

5. View ports being used
NETSTAT from PC or AS400.

6. Kill a program immediately (in QShell) like [kill -9 in unix]
On as400 it is: kill -12

7. ALTER BLOB LENGTH
alter table attachment alter column document set data type blob(10485760)

8. DSPFFD (DISPLAY FULL FILE DESCRIPTION)
DISPLAYS COLUMN LENGTHS AND OTHER INFORMATION ABOUT A FILE.

9. Start QShell on AS400
Command: strqsh