ODBC and VB, whats this then?

HPUX 10.20 IDS 7.30.UC7 INFORMIX ODBC Driver Version 3.31 NT4 We are experimenting in the new ( to us) brave world of VB development accessing our Unix IDS. When the application first connects to the database it executes a massive SELECT stmnt against systables, see onstat -g ses info below. Presumably this is gathering schema info for the database. Given that this is an application not a dynamic access tool, I.e. the programmer knows the schema and codes accordingly, is there some way of disabling this option? Or am I barking up the wrong tree, probably in the wrong forest as well? :o/ TIA. onstat -g ses 2610 Informix Dynamic Server Version 7.30.UC7 -- On-Line -- Up 15 days 00:21:14 -- 71344 Kbytes session #RSAM total used id user tty pid hostname threads memory memory 2610 obs TIM 219 tim 1 499712 74312 tid name rstcb flags curstk status 2698 sqlexec c47f7698 Y--P--- 35048 c47f7698 cond wait(netnorm) Memory pools count 1 name class addr totalsize freesize #allocfrag #freefrag 2610 V c4e0a018 499712 425400 518 97 name free used name free used overhead 0 128 scb 0 360 opentable 0 38616 filetable 0 952 ru 0 224 log 0 2152 temprec 0 1608 keys 0 3368 gentcb 0 12472 ostcb 0 2160 sort 0 56 sqscb 0 8920 rdahead 0 472 hashfiletab 0 280 osenv 0 600 sqtcb 0 1768 fragman 0 176 Sess SQL Current Iso Lock SQL ISAM F.E. Id Stmt type Database Lvl Mode ERR ERR Vers 2610 - mars CR Not Wait 0 0 9.15 Last parsed SQL statement : select 'Q', t.owner, t.tabname, 'Z', ' ', ' ', 'S', 0, ' ', 0, t.nrows, t.npused, 'F' from mars:informix.systables t where 1 = 1 and t.owner like 'informix' and t.tabname like 'sw_upgrade' union select 'Q', t.owner, t.tabname, i.idxtype, i.owner, i.idxname, i.clustered, 1, c.colname, i.part1, i.nunique, i.leaves, 'F' from mars:informix.systables t, mars:informix.sysindexes i, mars:informix.syscolumns c where t.tabid = i.tabid and c.tabid = i.tabid and c.colno = ABS(i.part1) and t.owner like 'informix' and t.tabname like 'sw_upgrade' union select 'Q', t.owner, t.tabname, i.idxtype, i.owner, i.idxname, i.clustered, 2, c.colname, i.part2, i.nunique, i.leaves, 'F' from mars:informix.systables t, mars:informix.sysindexes i, mars:informix.syscolumns c where t.tabid = i.tabid and c.tabid = i.tabid and c.colno = ABS(i.part2) and t.owner like 'informix' and t.tabname like 'sw_upgrade' union select 'Q', t.owner, t.tabname, i.idxtype, i.owner, i.idxname, i.clustered, 3, c.colname, i.part3, i.nunique, i.leaves, 'F' from mars:informix.systables t, mars:informix.sysindexes i, mars:informix.syscolumns c where t.tabid = i.tabid and c.tabid = i.tabid and c.colno = ABS(i.part3) and t.owner like 'informix' and t.tabname like 'sw_upgrade' union select 'Q', t.owner, t.tabname, i.idxtype, i.owner, i.idxname, i.clustered, 4, c.colname, i.part4, i.nunique, i.leaves, 'F' from mars:informix.systables t, mars:informix.sysindexes i, mars:informix.syscolumns c where t.tabid = i.tabid and c.tabid = i.tabid and c.colno = ABS(i.part4) and t.owner like 'informix' and t.tabname like 'sw_upgrade' union select 'Q', t.owner, t.tabname, i.idxtype, i.owner, i.idxname, i.clustered, 5, c.colname, i.part5, i.nunique, i.leaves, 'F' from mars:informix.systables t, mars:informix.sysindexes i, mars:informix.syscolumns c where t.tabid = i.tabid and c.tabid = i.tabid and c.colno = ABS(i.part5) and t.owner like 'informix' and t.tabname like 'sw_upgrade' union select 'Q', t.owner, t.tabname, i.idxtype, i.owner, i.idxname, i.clustered, 6, c.colname, i.part6, i.nunique, i.leaves, 'F' from mars:informix.systables t, mars:informix.sysindexes i, mars:informix.syscolumns c where t.tabid = i.tabid and c.tabid = i.tabid and c.colno = ABS(i.part6) and t.owner like 'informix' and t.tabname like 'sw_upgrade' union select 'Q', t.owner, t.tabname, i.idxtype, i.owner, i.idxname, i.clustered, 7, c.colname, i.part7, i.nunique, i.leaves, 'F' from mars:informix.systables t, mars:informix.sysindexes i, mars:informix.syscolumns c where t.tabid = i.tabid and c.tabid = i.tabid and c.colno = ABS(i.part7) and t.owner like 'informix' and t.tabname like 'sw_upgrade' union select 'Q', t.owner, t.tabname, i.idxtype, i.owner, i.idxname, i.clustered, 8, c.colname, i.part8, i.nunique, i.leaves, 'F' from mars:informix.systables t, mars:informix.sysindexes i, mars:informix.syscolumns c where t.tabid = i.tabid and c.tabid = i.tabid and c.colno = ABS(i.part8) and t.owner like 'informix' and t.tabname like 'sw_upgrade' union select 'Q', t.owner, t.tabname, i.idxtype, i.owner, i.idxname, i.clustered, 9, c.colname, i.part9, i.nunique, i.leaves, 'F' from mars:informix.systables t, mars:informix.sysindexes i, mars:informix.syscolumns c where t.tabid = i.tabid and c.tabid = i.tabid and c.colno = ABS(i.part9) and t.owner like 'informix' and t.tabname like 'sw_upgrade' union select 'Q', t.owner, t.tabname, i.idxtype, i.owner, i.idxname, i.clustered, 10, c.colname, i.part10, i.nunique, i.leaves, 'F' from mars:informix.systables t, mars:informix.sysindexes i, mars:informix.syscolumns c where t.tabid = i.tabid and c.tabid = i.tabid and c.colno = ABS(i.part10) and t.owner like 'informix' and t.tabname like 'sw_upgrade' union select 'Q', t.owner, t.tabname, i.idxtype, i.owner, i.idxname, i.clustered, 11, c.colname, i.part11, i.nunique, i.leaves, 'F' from mars:informix.systables t, mars:informix.sysindexes i, mars:informix.syscolumns c where t.tabid = i.tabid and c.tabid = i.tabid and c.colno = ABS(i.part11) and t.owner like 'informix' and t.tabname like 'sw_upgrade' union select 'Q', t.owner, t.tabname, i.idxtype, i.owner, i.idxname, i.clustered, 12, c.colname, i.part12, i.nunique, i.leaves, 'F' from mars:informix.systables t, mars:informix.sysindexes i, mars:informix.syscolumns c where t.tabid = i.tabid and c.tabid = i.tabid and c.colno = ABS(i.part12) and t.owner like 'informix' and t.tabname like 'sw_upgrade' union select 'Q', t.owner, t.tabname, i.idxtype, i.owner, i.idxname, i.clustered, 13, c.colname, i.part13, i.nunique, i.leaves, 'F' from mars:informix.systables t, mars:informix.sysindexes i, mars:informix.syscolumns c where t.tabid = i.tabid and c.tabid = i.tabid and c.colno = ABS(i.part13) and t.owner like 'informix' and t.tabname like 'sw_upgrade' union select 'Q', t.owner