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: 747
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 Secondary index error while loading d... IMS DB/DC 2
No new posts SKIP LOCKED DATA in UPDATE statement DB2 9
This topic is locked: you cannot edit posts or make replies. Passing a field name to COBOL program COBOL Programming 10
This topic is locked: you cannot edit posts or make replies. Sample CICS Webservices Program CICS 1
No new posts How to find which file contains my se... DFSORT/ICETOOL 6
Search our Forums:

Back to Top