Re: IDS Next Version - back on topic

paul@oninit.com said: > I'd like a > > DROP PROCEDURE ALL <SPLNAME>> > but is pure laziness And what would it do? > Obnoxio The Clown wrote: > >> May I commit a heresy here, and try and drag something off-topic back >> onto >> the original topic? >> >> I was just thinking how nice it would be to have declarative PDQ built >> into stored procedures and views: >> >> 1. onconfig parameter to enable / disable this feature, default is >> disabled. >> 2. CREATE VIEW ... WITH PDQPRIORITY x; where 0 <= x <= 100 or x is >> CURRENTPDQ (the default -- take it from the current session) >> 3. CREATE PROCEDURE / FUNCTION ... WITH PDQPRIORITY x; where 0 <= x <= >> 100 >> or x is CURRENTPDQ (the default -- take it from the current session) >> 4. EXECUTE PROCEDURE ... WITH PDQPRIORITY x; where 0 <= x <= 100 or x is >> COMPILEDPDQ (the default -- take it from compile time) >> >> I suppose the tricky thing would be how to force PDQPRIORITY 0, as that >> would be the default you'd want to override. Perhaps something like "SET >> PDQPRIORITY 0 FORCE;"? >> >> Clearly, I haven't thought it through, but something like that would be >> helpful in a number of sites I've seen where you only want PDQ available >> rarely, and it's difficult to make all the developers use it correctly >> so >> it gets left off, rather than allowing the developers to break more >> stuff. >> > > -- > Paul Watson # > Oninit Ltd # Growing old is mandatory > Tel: +44 1436 672201 # Growing up is optional > Fax: +44 1436 678693 # > Mob: +44 7818 003457 # > www.oninit.com # > -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche A smile is a gift that is free to the giver and precious to the recipient. But giving someone the finger is free too, and I find it more personal and sincere. sending to informix-list