This is Part II of a tour of rlwrap for idql/iapi. For Part I, please follow the link here. Enhanced output visualization This is one rlwrap’s most fantastic enhancement. It is not that different from what I suggested here only much smoother. idql does not provide any flexible formatting and lines longer than the screen width get wrapped around, which…
The rant I have a confession to make: I’m obsessed with idql/iapi. These tools so central to Documentum administrative tasks are so lame for interactive work that they have probably disgusted more than their share of administrators. The problem is that I have to use them almost daily, and everyday I grumble: there must be a better way. Sure, there…
By Franck Pachot . Let’s say you have a PEOPLE table with FIRST_NAME and LAST_NAME and you want, in many places of your application, to display the full name. Usually my name will be displayed as ‘Franck Pachot’ and I can simply add a virtual column to my table, or view, as: initcap(FIRST_NAME)||’ ‘||initcap(LAST_NAME). Those are simple SQL functions. No…
