Order by Clause in DB2 Enterprise stage
Posted: Thu Feb 14, 2008 2:54 pm
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?
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?