Quick Tip: How To Delete Multiple SQLPKGs
Run the following command to delete all the SQLPKG's in the QRECOVERY library with a name beginning with "OW" DLTSQLPKG SQLPKG(QRECOVERY/OW*) Of course, this command...
Quick Tip: Hold All JDE Job Queues
The following SQL statement will put all JDE Job Queues on hold: UPDATE SY920.F986130 SET QCQUSTS='02' This statement is very helpful when dealing with a...
Quick Tip: IBM i (iSeries / AS400) Spool File Navigation
The following commands can be used to navigate spool files after using a command similar to WRKSPLF. Just enter the command into the "Control" field...
Needle: IBM iSeries (AS400) Power Outage JDE Recovery
Crazy to think but this issue has come up a few times in my years as an Oracle JD Edwards CNC Admin as evidenced by...
Quick Tip: 3 Ways To Truncate a File in Linux
The following are 3 quick ways to delete the contents of (truncate) a file in Linux: Truncatebash$ truncate -s 0 filename.txtI/O Redirectionbash$ > filename.txt/dev/nullbash$ cp...