Re: tables in dbspace (Online 5.x)
there are problems with using the $INFORMIXDIR/etc/makeps.sql script.
namely, informix doesnt support it. additionally, selecting from
some of the 'tables' can result in the engine puking and shutting down.
} Following is a mail posted sometimes back by Graeme Sargent which gives you
} the dbspace name
} +--------------------------+---------------------------+
} | G.T.Madavan, | e-mail: gtmad@smi.mn.org |
} | Systems Migration Inc., | Phone : (612) 890-0040 |
} | Burnsville, MN, U.S.A | Fax : (612) 890-0966 |
} +--------------------------+---------------------------+
}
} ############## OLD MAIL ################
} In <289m2sINNq8c@emory.mathcs.emory.edu> rebowman@catsii.b8.ingr.com (Richard E. Bowman) writes:
}
} > I'm looking for a way in a sql statement to have on-line
} > return me based on a given table name the dbspace name that
} > the table is located in.
}
} Run "dbaccess - $INFORMIXDIR/etc/makeps.sql" then execute the query:
}
} SELECT name FROM systables, master:sysdbstab -- Needs OnLine >= 5.00
} WHERE dbsnum = TRUNC(partnum/16777216, 0)
} AND tabname = "table_name";
}
} graeme
} --
} Disclaimer: The author's opinions are his own, and not necessarily
} those of Pyramid Technology Ltd. or Pyramid Technology Inc.
} ---------------------------------------------------------------------------
} -m------- Graeme Sargent Voice: +44 (0)252 373035
} ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135
} -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who???
} -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk
} ---------------------------------------------------------------------------
} We have the technology. The tricky bit is learning how to use it.
}
}
--
regards,
+----------------------------------------------------------------------------+
| . . | |
| ... ... | Bob Baskett |
| ..... ..... | Software Engineer, DBA |
| .. ... .. | Business Systems Integration Group |
| . . . | Semiconductor Products Sector |
| | Mesa, AZ |
| Motorola, Inc. | |
|----------------------------------------------------------------------------|
| 'connectionLESS IS MORE' -- Data Broker |
|----------------------------------------------------------------------------|
| Duct tape is like the force. It has a light side, and a dark side, and |
| it holds the universe together ... |
| -- Carl Zwanzig |
+----------------------------------------------------------------------------+