Sorry this is not possible in IDS with normal SPL commands. I beleive there is bladelet that can be used to achieve this in IDS 9. You coulld check the IBM website for this. I think I've seen it in developerswork corener of Informix in the datablade section. But it is not as easy as with Oracle.