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

SYNCSORT-DB2 interface


IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2119
Location: USA

PostPosted: Fri Sep 20, 2024 9:44 pm
Reply with quote

SYNCSORT allows to specify a standard SELECT statement to define input data extracted directly from DB2 table(s) rather than records read from a prepared dataset.

There are no described restrictions on using ORDER BY clause in SQL query to be executed within SYNCSORT, and any correct ORDER BY clause is really accepted. But, surprisingly, the records extracted from DB2 by SYNCSORT are found not ordered by the column from ORDER BY clause!

The same SQL query executed from SPUFI demonstrated ordered results, but after SYNCSORT the same data come not ordered.

Does anyone has any idea on this issue?
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 -> SYNCSORT

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Count Records with a crietaria in a f... DFSORT/ICETOOL 5
No new posts DFSORT/SYNCSORT/ICETOOL JCL & VSAM 8
No new posts Syncsort "Y2C" Function SYNCSORT 1
No new posts Arithmetic division using Syncsort SYNCSORT 6
Search our Forums:

Back to Top