RandomScrawls
Decidedly mundane…

Posts Tagged ‘database

How to Mimic SQL’s SELECT DISTINCT Clause with IBM AS/400’s WRKQRY

Friday, 13 November 2009

Several days ago, I was stuck with this problem: how do I do a version of SQL’s SELECT DISTINCT clause with IBM AS/400’s (iSeries) WRKQRY command. In other words, how to summarize a field. You see, my user ID on the system is restricted to a menu – not even given the command-line, in fact […]