|
View previous topic :: View next topic
|
| Author |
Message |
srvk_2k2
New User
Joined: 07 May 2008
Posts: 36
Location: Chennai
|
|
|
|
What's the SORT card to convert the Text field to SIGNED Numeric format?
Regards,
Saravana S |
|
| Back to top |
|
 |
smijoss
Active User
Joined: 30 Aug 2007
Posts: 114
Location: pune
|
|
|
|
| give some sample data. |
|
| Back to top |
|
|
srvk_2k2
New User
Joined: 07 May 2008
Posts: 36
Location: Chennai
|
|
|
|
My input file-
Field1: '-190000' X(7)
Outfile-
Field1: -190000 S9(07) |
|
| Back to top |
|
|
smijoss
Active User
Joined: 30 Aug 2007
Posts: 114
Location: pune
|
|
|
|
| Code: |
//JS001 EXEC PGM=SORT
//*
//SYSOUT DD SYSOUT=*
//*
//SORTIN DD *
-190000
200
-200
/*
//SORTOUT DD DSN=TEMP.TLM.FTBDATE.OUT,
// DISP=(NEW,CATLG),
// SPACE=(CYL,(1,1),RLSE),UNIT=TSTDA
//*
//SYSIN DD *
OPTION COPY
OUTREC OVERLAY=(15:1,7,FS,EDIT=(STTTTTTT),SIGNS=(+,-)) |
output :
| Code: |
-190000 -0190000
200 +0000200
-200 -0000200
|
|
|
| Back to top |
|
|
srvk_2k2
New User
Joined: 07 May 2008
Posts: 36
Location: Chennai
|
|
|
|
| Thank you smijoss |
|
| Back to top |
|
|
vinu78
Active User
Joined: 02 Oct 2008
Posts: 179
Location: India
|
|
|
|
Hi Smijoss,
If the input field contains decimal point, what will be change in SORT card?
Could you please let me know of that.
Thanks
Vinu |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
|
|
|
|
| Vniu - You already have a thread going on here and the above question seems related to that. If you have a new question, it's good to open up a new thread with a reference to previous thread. Also, you now know that you are using SyncSort not DFSort - so your thread should be in JCL part for the Forum if it's related to Sort-product you are using. |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
| If the input field contains decimal point, what will be change in SORT card? |
The SFF (signed free form) or UFF (unsigned free form) format can be used for values with a decimal point. |
|
| Back to top |
|
|
|
|
