Mamta Satoor wrote:
> Hi, > > I ran following query in a 10.2 db > select alias,systemalias from sys.sysaliases; > I don't think systemalias column in sys.sysaliases is being used in Derby currently. It was probably used in Cloudscape product, from which Derby originally came from. All routines in system schemas have this flag set to 'false'. May be documentation should say this column is 'Reserved'? What information do you need? Satheesh > I was expecting to see true for systemalias column for Derby supplied > routines like SYSCS_COMPRESS_TABLE, SYSCS_EXPORT_TABLE etc. But all > the rows returned by the query above have systemalias set to false. > According to the docs on SYSALIASES table, the column systemalias will > be set to true for system supplief/built-in aliases. Is the doc > incorrect, system table incorrect or I am missing something? > > thanks, > Mamta
