Decidedly mundane…

Posts Tagged ‘iSeries

How to Spawn a Second AS/400 Console Session

Friday, 13 November 2009

This is a neat trick I was told when I was heavily tasked with querying The Company’s main system for various data. Sometimes, I need two simultaneous sessions with the AS/400 console, but the system won’t allow it (actually, it’s a security parameter implemented by my QSECOFR). So here’s the work around so we can […]

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 […]