This library is a general purpose SQL generator. Think of it as a typesafe and expressive SQL DSL (domain specific language), with support for rendering SQL formatted properly for MyBatis3 and ...

Microsoft last week announced the release of SQL Server 2022 Release Candidate (RC) 0. The RC 0 designation is old Microsoft phraseology. It used to mean that the software bits were feature complete ...

IBM shipped the JOBLOG_INFO table function back in IBM i v7r2 as a way to view the joblog from PC-based client access apps, such as RUN SQL Scripts. I use it from time to time to get the joblog for ...

I've used DSPPGMREF for decades. There were some 3rd party software offerings along the way that did a better job of providing a complete object cross reference database. DSPPGMREF is what most people ...

Steps to revoking grants before dropping a user: 1. Find all grants by granted by user to drop and regrant them as another user (superuser preferably). select regexp_replace(ddl,grantor,'<superuser>') ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...