Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Meaning of SORT BY <fields> USING <fields>

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries
View previous topic :: :: View next topic  
Author Message
Shanu.sukoor

New User


Joined: 31 Jan 2006
Posts: 32
Location: India

PostPosted: Wed Jan 30, 2008 6:52 pm    Post subject: Meaning of SORT BY <fields> USING <fields>
Reply with quote

What is the meaning of SORT BY <fields> USING <fields>. I am new to natural language.

Thank you.
Back to top
View user's profile Send private message

ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Wed Jan 30, 2008 7:07 pm    Post subject:
Reply with quote

It will be easier for you to read Software AG's manuals and get the answer directly (look at the STATEMENTS manual).

In general, USING will cause the fields mentioned to be kept in intemediate storage. Otherwise, they may be emptied by the SORT operation.

O.
Back to top
View user's profile Send private message
Shanu.sukoor

New User


Joined: 31 Jan 2006
Posts: 32
Location: India

PostPosted: Wed Jan 30, 2008 7:15 pm    Post subject:
Reply with quote

Where can I get the manuals? Could you please post the link or attach the manual?
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Wed Jan 30, 2008 7:26 pm    Post subject:
Reply with quote

Software AG's manuals are copyrighted materials.

However, if you have a licensed NATURAL installed, you should have all the documentation at your shop.

O.
Back to top
View user's profile Send private message
Shanu.sukoor

New User


Joined: 31 Jan 2006
Posts: 32
Location: India

PostPosted: Wed Jan 30, 2008 8:21 pm    Post subject:
Reply with quote

Thank you... I will search for it in my shop.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jan 30, 2008 11:05 pm    Post subject:
Reply with quote

Hello,

If it is not in your shop and your system is licensed, you can get all of the material from Software AG.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORT to unpack a feild shr_amar DFSORT/ICETOOL 7 Fri Jul 07, 2017 4:32 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Optimize sort inrec parse vishwakotin DFSORT/ICETOOL 6 Mon Jun 26, 2017 11:15 pm
No new posts Reduce CPU Times for Join Sort santoshn SYNCSORT 12 Sat Jun 10, 2017 1:40 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us