Re: Parallel multi-relational collections

On 14 Apr 2005 00:53:58 -0700, "frebe"
<fredrik_bertilsson@xxxxxxxxxxx> wrote:

>Which DBMS supports with syntax? Oracle, SQL Server, DB2, Informix,
>Postgres, ...?

I think that DB2 is the only that supports this. Oracle has a
different syntax for the same: "connect by".

With the rest of the DBMS you should write an stored procedure.

This is explained in the links I gave to you.


Regards
.

Relevant Pages

  • Re: SQL Server replacement
    ... Well migrating to another DBMS is mostly a big challenge. ... We used MS-SQL Server, MySQL, PostgreSQL, Oracle and DB2 in the past and they all have pros and cons. ... DB2 is rock-solid and very, very close on the SQL-92 standard columns should not be removed and so DB2 doesn't removes them on retrieval - most other DBMS do so). ...
    (bit.listserv.ibm-main)
  • Re: Limit UPDATE statements to affect only one row
    ... Perhaps that isn't required with DB2. ... Anyone can write invalid syntax and state it doesn't work. ... that <=1 makes no sense when applied to rownum: ... installed copy of Oracle, comment on Oracle syntax while not one person ...
    (comp.databases.oracle.server)
  • Re: Limit UPDATE statements to affect only one row
    ... Perhaps that isn't required with DB2. ... that <=1 makes no sense when applied to rownum: ... installed copy of Oracle, comment on Oracle syntax while not one person ...
    (comp.databases.oracle.server)
  • Re: Sybase Support
    ... change for oracle or db2. ... Sounds like a troll. ... then pick any DBMS and learn it. ...
    (comp.databases.sybase)
  • Converting Stored Process to other DBMS?
    ... Server to the equivalent in another DBMS such as Oracle or DB2? ...
    (microsoft.public.sqlserver)