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...
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...
A Work Submitted Job (WSJ, P986110B) Grid Format You Can’t Live Without!
As an Oracle JD Edwards EnterpriseOne (E1) CNC Administrator, I spend a ton of time tracking down UBE errors. Usually, it starts by getting some...
Quick Tip: Limit The Number Of Rows Returned From A SQL Query
This is pretty basic, but I had to look up the syntax to use for SQL on IBM DB2 so I thought I'd write a...