plz help- query related to DB2

[shankarsunmicrosys]

Hi,



Could you please suggest, how to sort the data coming from a select query in DB2 UDB V8, without having order by clause?



My query look like this:



insert into <table1> select name, no from <table2> order by name. Because it’s not allowing to having order by in sub queries.





Thanks in Advance.

Shiva.

[cburnett]

Shiva,
Presume you are using DB2 V8 as V9 supports insert into ... select ... from ... order by ....

I have previously used:

insert into ... select  ... from ... group by ...

successfully to simulate an order by in DB2 V8.

[docdiesel]

Hi,

user your SELECT including the ORDER BY statement to create a VIEW, and then insert into the destination table reading from there:

INSERT INTO
  DESTTABLE
SELECT
  name, no
FROM
  MYVIEW ;

Regards

Doc Diesel

[anijos]

By what purpose is ORDER BY useful or valid on INSERT?
Within an RDBMS one row has no inherent relationship to another row.

AniJos