View previous topic :: View next topic
|
Author |
Message |
pradeepkit Warnings : 1 New User
Joined: 25 Jun 2008 Posts: 60 Location: chennai
|
|
|
|
Hi,
I have a db2 program which is having a cursor.
Select *
From TableA
with ur;
when this program is running in the job result is diiferent than when I ran the same select statement in spufi.
order is not coming correct.
Can you please suggest what could be the issue. |
|
Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
Quote: |
order is not coming correct. |
This is because you do not have an ORDER BY clause stated.
Without this clause the order of the data returned cannot guaranteed.
Add this clause to both, and all should be OK. |
|
Back to top |
|
|
|