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...
Needle – Overview of Specifications (SPEC) in Oracle JDE EnterpriseOne
I'm starting a new category of posts called "Needles". It is going to have Oracle Support Documents that I have found useful or interesting. Sometimes...
IBM iSeries SQL Packages FAQ
If you use an IBM iSeries, AS/400, System i, just i or whatever IBM is calling their powerhouse processing server nowadays, SQL Packages seem to...
Quick Tip: Where Is An Application On The Menu?
The following SQL will give you a good idea if an application or UBE is on the menu and where it is: SELECT * FROM...
Quick Tip: Decline All Update Packages Using SQL
A quick way to decline all packages that have been marked for deployment on a development client is use SQL: UPDATE SY900.F98825 SET UPINPKST=40 --Decline...