Re: Database Schema from the System Tables.......

Get my dbschema replacement utility, myschema, it is written in ESQL/C but all of the SQL you would need are there in the source (most in the main module). Doing the programming logic to duplicate the schema of a table will not be simple in SPL, the language is just too limited, but should be doable IFF you are using IDS 9.xx and have the dynamic SQL databalde installed. Both myschema and the dynamic SQL datablade are available for download from the IIUG Software Repository, myschema is included in the package utils2_ak. Art S. Kagel ----- Original Message ----- From: Abraham Kir.... <bull_informix@yahoo.com> At: 5/ 5 10:40 > Hi, > If you are aware of, or use any SQL to extract the > Schema information about a database from the system > tables, can you send it to me. > Objective : Iam trying to write a SP to drop and > create tables owned by user "informix" , but they need > to be dropped and recreated by another user. > Unfortunatley the "SYSTEM" call inside a SP cannot be > executed by a user who does have only the "EXECUTE" > permission on the SP and hence can't run the dbschema > to extract the schema dynamically. > I am trying to get around this by extracting the > schema from the system tables via a "SELECT" > statement. > > Your inputs will be greatly appreciated. > > Thanks > Abraham > > __________________________________ > Do you Yahoo!? > The New Yahoo! Search - Faster. Easier. Bingo. > http://search.yahoo.com