IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 program returned data is dif than spufi


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
pradeepkit
Warnings : 1

New User


Joined: 25 Jun 2008
Posts: 60
Location: chennai

PostPosted: Tue Mar 03, 2015 5:39 am
Reply with quote

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
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania

PostPosted: Tue Mar 03, 2015 6:12 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Using API Gateway from CICS program CICS 0
No new posts DELETE SPUFI DB2 1
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts SCOPE PENDING option -check data DB2 2
No new posts Adding QMF and SPUFI to the ISPF menu DB2 20
Search our Forums:

Back to Top