From: Zabach, Elke (elke.zabachsap.com)
Date: Thu May 27 2004 - 02:30:52 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Dusan Kolesar wrote:
>
> Hello,
>
> I have two cursors.
> First is for select lines from 2 tables.
> This is my semi result. This result I want to sort also.
> DECLARE C1 CURSOR FOR
> WITH RECURSIVE PX (ID, PARENT_ID, NAME, TYPE) AS
> (
> SELECT ID, PARENT_ID, NAME, 1 FROM ADMIN.CAR
> UNION ALL
> SELECT ADDRESS.ID, ADDRESS.PARENT_ID, ADDRESS.NAME, 2 FROM
> ADMIN.ADDRESS, PX
> WHERE PX.PARENT_ID = ADDRESS.ID
> )
> SELECT DISTINCT ID, PARENT_ID, NAME, TYPE FROM PX
>
> Using next cursor I want to sort my result table (it is tree
> representation)
> DECLARE C2 CURSOR FOR
> WITH RECURSIVE PX (ID, PARENT_ID, NAME, FOLGE, TREELEVEL) AS
> (SELECT ID, PARENT_ID, NAME, CHR(ID), 1 AS TREELEVEL FROM
> ADDRESS WHERE
> PARENT_ID=-1
> UNION ALL
> SELECT ADDRESS.ID, ADDRESS.PARENT_ID, ADDRESS.NAME,
> FOLGE || lfill (CHR(ADDRESS.ID), ' ', 10), TREELEVEL + 1
> FROM ADDRESS, PX
> WHERE PX.id = ADDRESS.PARENT_ID
> )
> SELECT ID, PARENT_ID, NAME, FOLGE, TREELEVEL
> FROM PX
> ORDER BY FOLGE
>
> Is it possible to combine these cursors?
> I want to put cursor C1 into cursor C2 (insted table ADDRESS).
>
YES
Just change all ADDRESS to C1.

Elke
SAP Labs Berlin

> Thanks for advice.
> Regards, Dusan
>
> -=x=-
> Skontrolované antivírovým programom NOD32
>
>
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
http://lists.mysql.com/maxdb?unsub=elke.zabachsap.com

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]