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
 

 

Query on SORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
sats456

New User


Joined: 29 May 2005
Posts: 12

PostPosted: Mon Oct 10, 2005 11:41 am    Post subject: Query on SORT
Reply with quote

Hi All,
Could you anyone explain me the use of Below mentioned Control Card in SORT.

SORT FIELDS=COPY
OUTREC FIELDS=(1:32,8,
9:C',',
010:18,07,PD,EDIT=(STTTTTTTTTTTT.TT),SIGNS=(,-,,)


I understand the purpose of OUTREC .But I am not sure as to what EDIT= and SIGNS= are for ?
I have a rough Idea that they are being used for Editing but not clear on what excatly Editing will be done.If someone,Could illustrate me the use of EDIT= & SIGNS= clause with an Example,it would be great..


Thanks in Advance,
Satish
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Mon Oct 10, 2005 8:59 pm    Post subject:
Reply with quote

Code:

EDIT=(STTTTTTTTTTTT.TT),SIGNS=(,-,,)


The EDIT and SIGNS pattern shown here tells DFSORT that you want your converted PD numbers to have a blank sign for plus or a '-' sign for minus followed by 15 decimal digits, with leading zeros, when appropriate and a decimal point before the last two digits. Here are some examples of how various values will be edited:

Code:

   PD value        Editted value
         +1      000000000000.01
      -1234     -000000000012.34
    +123456      000000001234.56
     -99999     -000000000999.99
+1234567890      000012345678.90


For an overview of DSORT's edit functions, see:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CG10/2.4.8?DT=20050223112358
Back to top
View user's profile Send private message
sats456

New User


Joined: 29 May 2005
Posts: 12

PostPosted: Tue Oct 11, 2005 12:08 pm    Post subject: Re: Query on SORT
Reply with quote

Many Thanks Yaeger for your Prompt response.
The EDITS= clause maening is very clear to me now.Also I checked the IBM website where various Comphrensive possibilities on EDIT= clause have been specified.
But while looking for SIGNS= Clause,I found it has following format
SIGNS=(a,b,c,d)
I believe b is for '-' clause

What are a,c,d for ? I couldnot find this.
If you please let me know your suggestions on this,It would be great.

Thanks ,
Satish
Back to top
View user's profile Send private message
MGIndaco

Active User


Joined: 10 Mar 2005
Posts: 432
Location: Milan, Italy

PostPosted: Tue Oct 11, 2005 1:08 pm    Post subject:
Reply with quote

This is from the manual where you found that information:
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ice1cg10/2.4.8?DT=20050223112358
Quote:
You can use SIGNS=(a,b,c,d) to override or set the output signs (leading positive, leading negative, trailing positive and trailing negative).


I hope in this review.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Oct 11, 2005 8:36 pm    Post subject:
Reply with quote

SIGNS=(a,b,c,d)

The S for sign can be on the left (leading sign), on the right (trailing sign) or on both the left and right (leading and trailing sign). a is the leading plus sign, b is the leading minus sign, c is the trailing plus sign, and d is the trailing minus sign. For example:

EDIT=(STTTT),SIGNS=(+,-)
EDIT=(TTTTS),SIGNS=(,,+,-)
EDIT=(STTTTS),SIGNS=(+,-,+,-)
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to change 'K' or 'M' use Sort vice_versa DFSORT/ICETOOL 5 Thu May 18, 2017 7:11 am
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
This topic is locked: you cannot edit posts or make replies. SORT trick needed bshkris SYNCSORT 6 Tue May 02, 2017 4:35 am
No new posts SORT JSON type of data maxsubrat DFSORT/ICETOOL 8 Wed Apr 19, 2017 6:01 pm
No new posts Sort Large record length cmsmoon DFSORT/ICETOOL 14 Tue Apr 11, 2017 5:49 pm


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