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

Query on SORT


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
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
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 Developer


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

PostPosted: Mon Oct 10, 2005 8:59 pm
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:

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
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
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 Developer


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

PostPosted: Tue Oct 11, 2005 8:36 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts RC query -Time column CA Products 3
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
Search our Forums:

Back to Top