1 / 46

Cool stuff that you may not have known was in i

Cool stuff that you may not have known was in i. By Rob Berendt and others April 2008. Built in Job Scheduler. WRKJOBSCDE allows you to schedule jobs to run at various days, dates, times, etc. Sending email from your i. SNDDST will allow you to send email from i.

elom
Télécharger la présentation

Cool stuff that you may not have known was in i

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Cool stuff that you may not have known was in i By Rob Berendt and others April 2008

  2. Built in Job Scheduler WRKJOBSCDE allows you to schedule jobs to run at various days, dates, times, etc

  3. Sending email from your i SNDDST will allow you to send email from i. SNDDST TYPE(*LMSG) TOINTNET((rob@dekko.com)) DSTD('test description') LONGMSG('test long message') SUBJECT('Test subject') Can be useful for emailing to support, customers, cell phones…

  4. RUNQRY To quickly display the contents of a file, even without Query/400 installed, try RUNQRY *N filename Or RUNQRY QRYFILE((filename))

  5. GO SECTOOLS • You can do a lot with this menu: • Disable User IDs according with its activity (or lack thereof) in • the system. • Enable/Disable users according to a work schedule. • Check any "default" passwords, etc.

  6. CPYTOIMPF Did you know that is *VERY* easy to create a TAB delimited file, put it in the IFS and have it accessed by your users as an EXCEL file?

  7. Customized sign on

  8. 5250 Hotspots

  9. Polymorphic GUI Pull down menus and scroll bars, even in 5250

  10. Imbedding PC commands STRPCO STRPCCMD PCCMD('explorer http://maiL.YAHOO.COM') See also RUNRMTCMD

  11. FTP directly You can ftp directly to, or from, your i. You can even set up ftp scripts to automate this.

  12. WRKQRY WRKQRY requires 5722QU1. If you have it, then WRKQRY is a great tool for easy reports. If you do not have it, then you can use RUNSQLSTM or CRTQMQRY with STRQMQRY. You can use ANZQMQRY and RTVQMQRY to “decompile” queries created with WRKQRY to see the SQL behind it.

  13. UPDDTA UPDDTA allows you to quickly edit the contents of a table. Great for quick fixes, or for simple tables, but not something I would show the general user population.

  14. Journalling • Journalling your data files provides many capabilities. • Such as: • Data auditing • RMVJRNCHG • APYJRNCHG • COMMIT or ROLLBACK when in STRSQL.

  15. Triggers • Triggers can be used to: • Send alerts when inventory balance is below safety stock • Alert IT when an employee is terminated. • Have actions performed on existing applications without • customizing them. (Remember Application Modernization • presentation?)

  16. F9 for command line

  17. F1 for help on a message

  18. F1 (cont)

  19. CALL QCMD Don’t forget F10 for Detail

  20. F14 to show command

  21. F14 (cont)

  22. Ampersand to expand

  23. Ampersand (cont)

  24. EDTF • EDTF is an IFS, or Integrated File System command that is often • used to edit a text file in the IFS. It can be used to edit a source • member in i that does not have an editor such as SEU or RDi. • When used against a directory it can do some interesting things • such as: • Sort by various columns • Recursive deletes • If you use a lot of APIs you’ve used user spaces. They can be easily displayed, or edited by using: • EDTF ‘/QSYS.LIB/MYLIB.LIB/MYDATA.USRSPC’

  25. EDTF (cont)

  26. IFS commands on “normal” stuff You can use IFS commands to perform operations against items in the “normal file system, or QSYS.LIB. One example is: CHGOWN ‘/QSYS.LIB/MYLIB.LIB/*’ NEWOWN(BUBBA)

  27. System Database QSYS2 library contains “views” to the system database. In there are many names familiar to MS SQL Server such as SYSTABLES SYSCOLUMNS SYSVIEWS SYSPARTITIONSTAT

  28. STRSQL – F15 SELECT * FROM QSYS2.SYSPARTITIONSTAT WHERE TABLE_SCHEMA = 'ROB‘ SELECT * FROM QSYS2.SYSPARTITIONSTAT WHERE TABLE_SCHEMA = 'ROB'

  29. RTVCLSRC • RTVCLSRC can be used to decompile CL programs that have not had their observability removed. Quite handy for some programs like: • DSPSYSVAL QSTRUPPGM • System program that is used by GO SAVE option 21. • (By the way, GO SAVE 20 allows you to set the defaults for 21.) • Also, see GENCMDDOC.

  30. Command prompt screens

  31. Command Prompt (cont) CMD PROMPT('Purge file of outdated records') PARM KWD(FILE) TYPE(*CHAR) LEN(10) CHOICE('File + name') PROMPT('File from your library list') PARM KWD(DATEFIELD) TYPE(*CHAR) LEN(10) + CHOICE('Must be YYMMDD 6,0') PROMPT('Date + field') PARM KWD(DAYS) TYPE(*DEC) LEN(3) CHOICE(DAYS) + PROMPT('Number of days to retain')

  32. QSHELL There are numerous commands available within QSHELL, such as built in support for zipping files.

  33. MISC NET.DATA INETD

  34. MISC CPYF RGZPFM REXX Virtual LAN

  35. RTVDSKINF & PRTDSKINF

  36. PTF Management Fix Central to locate, order and download PTF’s directly to the system. Image catalogs to move PTFs between systems.

  37. Running a Query in debug Some good index advice can be retrieved by running that query under STRDBG.

  38. iNav spool files

  39. iNav Shortcuts

  40. iNav, GUI UPDDTA

  41. iNav Run Sql Scripts

  42. Index Advisor

  43. Visual Explain

  44. Index Advisor (more)

  45. System Monitors

  46. iNav for Wireless

More Related