Thanks. I'm not very DB2 literate. Not that stops me from shooting off my mouth. But I do get a number of misfires. <grin/>
On Tue, Apr 2, 2013 at 5:20 AM, Jantje. <[email protected]> wrote: > On Mon, 1 Apr 2013 08:21:06 -0500, John McKown < > [email protected]> wrote: > > > > >SELECT CURRENT-TIME FROM sysibm.systables > > > > Make that > SELECT 1 FROM SYSIBM.SYSDUMMY1 > and test for SQLCode = 0. > > Uses quite a lot less cycles. > > Cheers, > > Jantje. > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > -- This is a test of the Emergency Broadcast System. If this had been an actual emergency, do you really think we'd stick around to tell you? Maranatha! <>< John McKown ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
