Re: how to find database names for OnLine v5.01

Stefan wrote: > > Michal Hajek wrote: > > > > Is there any way how to find the names of databases which > > OnLine work with ? I mean for example > > > > echo "THE RIGHT SELECT"| isql "THE RIGHT PARAMETERS" > > (for UNIX) > > > > or so. Thanks. > > Hi Michal, > > I'm sure there is s.o. out there, who did s.th. like the following: > > !!! PLEASE, NEVER TRY THE FOLLOWING IN A PRODUCTION ENVIRONMENT !!! > > The OnLine 5.x has an internal table like "sysdatabases". > Unfortunately this table cannot be directly used, because there > is no entry in your data dictionary. But it's possible to first > create an admin database and create a table called "sysdatabases". > This "sysdatabases" table must be created in exactly the same > way as the internal table ( this will be the trouble ). > ( Have a look at your manual: "database tablespace" documentation ) > Afterwards you must update the "partnum" entry of the > "sysdatabases" table ( "partnum" is a column of systables table ) > with the partnum 0x1000002 ( 16777218 decimal ). > > DATABASE yourdatabase; > SELECT partnum FROM systables WHERE tabname = "sysdatabases";> { > Note down the result ! You might need the old partnum later ! > } > UPDATE systables set partnum = 16777218 WHERE tabname = "sysdatabases"; > SELECT * FROM sysdatabases;> > If the above SELECT will not show the correct result, please > UPDATE systables again with the old partnum value, before you > do anything else. If you would try to alter your "sysdatabases" > table without the re-update, you will loose your OnLine instance !!! > > Any comments ??? > > Bye > > Stefan What are you, NUTS? How about in NO environment? Don't diddle with systables, development or production. Unless you have a test data base that's strictly for testing programs that experimently mess up system tables. GEEEZ. systables is sacred. ---- Tim Schaefer \\\\|// tschaefe@mindspring.com (6 6) ------------------------oOOo---( )---o00o--------- http://www.inxutil.com