Re: New feather in IDS for NT version 7.3
Posted in 1998
In article <3556DCB3.6E52@dati.lv>, Leonid Vorontsov <Leonids.Voroncovs@dati.lv> writes >The statement > > SELECT TABNAME TBNAME,OWNER CREATOR,TABTYPE TYPE,NCOLS COLCOUNT,'' > REMARKS,"LABEL" LABELS from "informix".SYSTABLES T where >(USER=T.OWNER or > USER='informix' or exists(select GRANTEE from "informix".SYSTABAUTH >where > (GRANTEE= USER or GRANTEE='public') and TABID=T.TABID and > (TABAUTH[1,1]='s' or TABAUTH[1,1]='S'))) and (TABTYPE = 'T') and >not > ((OWNER='informix' or OWNER='pcuser') and TABNAME in > ('sysblobs','syschecks','syscolauth', > 'syscoldepend','syscolumns','sysconstraints','sysdefaults', > 'sysdepend','sysdistrib', 'sysfragments', 'sysindexes','sysopclstr', > 'sysprocauth', 'sysprocbody','sysprocedures','sysprocplan', > 'sysreferences','syssynonyms', 'syssyntable','systabauth', > 'systables','systriggers','systrigbody', 'sysusers','sysviews', > 'gtitables','gticonvert1','gticolumns', 'gtiextrtab','gtitabauth', > 'gticolauth','gtisyssyntab','gtisynonyms', >'gtiindexes','gticonvert2', > 'gticonvert3','gticonvert4','gticonvert5', 'gtikeys')) ORDER BY >TBNAME ASC; > >brings server down. >Any comments? Leonid. ( Leonids.Voroncovs@dati.lv ) What does the online.log say? -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care