Hi All,
I am reading a db2 table in Datastage with DB2 Enterprise stage and using the Read Method = Table. I want to give a order by clause to the columns selected using the select list property. Where do I specify this? I tried to give it in the where clause property though I don't have a where clause, as follows:-
1 = 1 order by cust_id
This is not woking. Is there a work around for this problem other than changing the Read Method?
Order by Clause in DB2 Enterprise stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 36
- Joined: Thu Sep 01, 2005 5:44 am
- Location: Canada
Order by Clause in DB2 Enterprise stage
Thanks & Regards,
Rony
Rony
Re: Order by Clause in DB2 Enterprise stage
No there isn't, you have to override the SQL.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Read Method = Table is a direct read - it does not provide for ORDER BY. Nor GROUP BY nor HAVING for that matter. This is why/how it is fast.
If you want DB2 to sort the data you must use one of the SQL-based read methods.
If you want DB2 to sort the data you must use one of the SQL-based read methods.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 36
- Joined: Thu Sep 01, 2005 5:44 am
- Location: Canada