Re: Is IBM actually doing something with IDS?

Obnoxio The Clown wrote:
Serge Rielau said:
Do you mean SELECT * FROM NEW TABLE(INSERT INTO ...)?
What has that harmless statement done to you to gain your wrath?
It's a manifestation of overkill, where people keep coming up with more
and more abstruse and ludicrous functionality to pretend that something is
moving forward.
Perfect, you are making my point. You do have an OLTP view of the world.
I (who pushed that language instead of INSERT WITH RETURN) have a data warehousing view of the world. We have completely different priorities and they are reflected in the products we each prefer.

This manifestation of overkill was acknowledged to be good my Oracle techies at VLDB. And MS has approached us to get it into the SQL Standard because their brand spanking new simple version wasn't good enough they realized.

SELECT FROM INSERT/UPDATE/DELETE/MERGE is not geared towards OLTP.
INSERT WITH RETURN or a parking the identity column value in a SQLCA.ERRD field does not help in the warehouse, when ingesting tens of thousand of rows in one gulp.

I have no issue with an INSERT WITH RETURN syntactic sugar for the simple single row OLTP case and I suspect the standard will provide for both and DB2 will too.

When you design a language you must design for the future and then simplify the simple cases. Anything else is "painting yourself into a corner".

BTW, I am the guy who made that language happen. I am the proverbial horse's mouth :-)
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
.

Relevant Pages

  • No denotation?
    ... I am struck by what seems to be an understanding among those who ... discuss linguistics frequently that as far as language is a ... manifestation of instinct, no word ever has a denotation, and that ...
    (alt.usage.english)
  • Re: Is IBM actually doing something with IDS?
    ... What has that harmless statement done to you to gain your wrath? ... It's a manifestation of overkill, where people keep coming up with more ...
    (comp.databases.informix)
  • Re: filehandle into a hash?
    ... Nevermind, overkill. ... > Just getting into the best language ever... ... > Fancy a yourname@perl.me.uk or something ...
    (perl.beginners)
  • Re: New limited range type?
    ... >In the case of a (language or implementation defined) attribute, ... >would have to write every calculation such as this as: ... If someone wants to be even more explicit, ... It's overkill to say ...
    (comp.lang.ada)