Re: Changing table ownerships & IQ

In article <41i4bn$a7l@cssun.mathcs.emory.edu> dheisler@bassinc.com "Dave Heisler" writes: > > We will be releasing IQ with our product soon. We have > ran into a problem in that IQ needs informix table ownerships > to be the same as what has been defined in the data dictionary. > > The problem is table ownerships are not consistent among > our established customers. To get around this problem with our customers, I used an 'nawk' script to reformat the table details in the unloaded data dictionary to remove the table owner so that 'myself.mytable' became 'mytable'. You must ensure fill up with spaces at the end of 'mytable', however, otherwise the altered data dictionary won't load! -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================