Re: IIUG - New engine survey, your input needed

Klaus Weitzer wrote: > > After filling out your form i wonder if only those 'new' features are being > discussed. > > My additional wishes are: > Conversion functions in insert statements. > eg. todate ( as oracle ) > > Definition of 'atomic' transactions > cause of problems in a multithreaded environment > > update/insert able views > eg by a triggered action you can define which values go to which tables > cause of using an 'intelligent' frontend like MS access :~-( > > extended role capabilities > eg one user can be in different roles, but only in one at time > > yours > Klaus Weitzer Yes, and what about table constructors: the ability to write something like (SELECT what FROM somewhere WHERE x = y) in all places that a table name is allowed, eg in the FROM clause of SELECT. It does away with temporary tables and makes SQL more orthogonal (hooray). Of course, it is in SQL-92. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/