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

Special Sorting help required


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3053
Location: NYC,USA

PostPosted: Sat Mar 21, 2015 12:00 am
Reply with quote

Rahul, MID is not compatible with DB2 on Zos.
Chandan, No worries. You were very helpful.
Back to top
View user's profile Send private message
RahulG31

Active User


Joined: 20 Dec 2014
Posts: 446
Location: USA

PostPosted: Sat Mar 21, 2015 12:04 am
Reply with quote

Quote:
I just want to keep things simple. Look at this query (replace 'Mid' by 'Substr'). You should get the desired result.

Let's end this thread here please.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3053
Location: NYC,USA

PostPosted: Sat Mar 21, 2015 12:45 am
Reply with quote

Quote:
Let's end this thread here please.


That's Okay Sir!! Thanks for your inputs.
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
This topic is locked: you cannot edit posts or make replies. Automation need help in sorting the data DFSORT/ICETOOL 38
No new posts Sorting a record spanned over multipl... DFSORT/ICETOOL 13
No new posts Problem while sending special charact... JCL & VSAM 4
No new posts Creating additional seqnum/Literal wh... DFSORT/ICETOOL 4
No new posts Converting Hex to PD Special Condition SYNCSORT 3
Search our Forums:

Back to Top