Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Paul Watson — — source: Usenet: comp.databases.informix
If they are not detached then they'll be with the tables. Check
out systabnames/sysdbspaces in the sysmaster database. There are a
number of sites that have the SQL for this, including
www.oninit.com/sysmaster
Cheers
Paul
Five Cats wrote:
>
> Using IDS V7.3x.
>
> We need to find out which indexes are in which dbspace so we can provide
> the correct arguments for 'onload' (don't ask - using it was a bad idea
> but we can't take the live away from the users to do dbexport).
>
> However a quick look at the 'sysindexes' table isn't helpful.
>
> Does someone out there have an SQL that would help, please? I realise
> there might be stuff out there that uses various tools, but unless
> that's restricted to basic stuff (e.g. no Perl for one thing) we can't
> use it. It's not my machine to go trying to install Perl and so on,
> hence wanting an SQL solution.
>
> --
> Five Cats
> Email to: cats_spam at uk2 dot net
--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.