Re: Information about columns with SQL

Thomas Stainer wrote: > > I'd like to get a list for some of my db-tables by a simple ;-) > SQL-Statement: > This list should contain information like: > tablename, > columname, > rights (what does the "su-idxar"-flags in systabauth really mean: s - SELECT u - UPDATE i - INSERT d - DELETE x - INEX CREATION a - ALTER r - REFERENCE The third flag, '-' above, if '*', indicates that there are column level privileges granted on the table's columns. > select, update, ?!?, indexing, delete, exclusive lock, alter table, ?!?) > > data type (integer, varchar, year-to-fraction etc.) > index on column. There is in the FAQ a section on decoding the syscolumns records to determine the scale of complex data types like DECIMAL, DATETIME, VARCHAR, and INTERVAL. > Especially with the data type I'm having problems getting information > about it. > I'm running IDS 7.30 UC6. > Any useful help will greatly be appreciated Of course you can also get the source to my dbschema replacement utility, myschema, from the IIUG Software Repository in the package utils2_ak, and use the source as a reference for how to do this and more or muck it up as a framework to build what you are trying to write. Art S. Kagel