Hi all.
    I'm really stuck with getting the right output from a XML query.

   Given this structure:

create table GENCMP.SCRIPTS
(
  SCRIPT_ID            CHAR(10)               not null,
  PAGE_NO              INTEGER                not null
);

CREATE unique INDEX GENCMP.SCRIPTS_0 on GENCMP.SCRIPTS
              (SCRIPT_ID, PAGE_NO) pctfree 2 allow reverse scans ;

insert into GENCMP.SCRIPTS (SCRIPT_ID, PAGE_NO) values ('CUSTCARE',
1);
insert into GENCMP.SCRIPTS (SCRIPT_ID, PAGE_NO) values ('CUSTCARE',
2);
insert into GENCMP.SCRIPTS (SCRIPT_ID, PAGE_NO) values ('LEAD', 1);
insert into GENCMP.SCRIPTS (SCRIPT_ID, PAGE_NO) values ('LEAD', 2);

   What query do I use to get the following output:

<SCRIPTS>
   <SCRIPT>CUSTCARE</SCRIPT>
   <SCRIPT>LEAD</SCRIPT>
</SCRIPTS>

I just can not get it happening.

I would appreciate any support/help.

-Chris