View previous topic :: View next topic
|
Author |
Message |
ppandey07
New User
Joined: 27 Nov 2008 Posts: 51 Location: Delhi, India
|
|
|
|
Hi there,
I have one file that has more than one million records. In this file I have to modify three fields and there is one requirment to change sign of these three fields(make+ve to -ve and -ve to +ve).
Is there any way to do that via JCL or File Aid?
Please advise.
Thanks |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8700 Location: Dubuque, Iowa, USA
|
|
|
|
Quote: |
Is there any way to do that via JCL or File Aid? |
JCL -- absolutely not. You've been on this board over 3 years without reading, once, that JCL does nothing but execute programs? If you had asked if SORT could do this, or IEBGENER, or IDCAMS -- those are programs executed by JCL, and it is possible at least one of them could do this. But JCL, by itself? No way.
Furthermore, your post lacks crucial information -- are these three fields that need their sign reversed zoned decimal with an external sign? zoned decimal with internal sign? packed decimal? binary? floating point? |
|
Back to top |
|
|
ppandey07
New User
Joined: 27 Nov 2008 Posts: 51 Location: Delhi, India
|
|
|
|
Robert Sample wrote: |
Quote: |
Is there any way to do that via JCL or File Aid? |
JCL -- absolutely not. You've been on this board over 3 years without reading, once, that JCL does nothing but execute programs? If you had asked if SORT could do this, or IEBGENER, or IDCAMS -- those are programs executed by JCL, and it is possible at least one of them could do this. But JCL, by itself? No way.
Furthermore, your post lacks crucial information -- are these three fields that need their sign reversed zoned decimal with an external sign? zoned decimal with internal sign? packed decimal? binary? floating point? |
I meant any JCL utility that could do this.
Binary. Please have a look below.
S9(6)V99.
S9(8)V99.
S9(8)V99. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
would be something like jclscan, i.e. a utility that does something to jcl.
i'll not comment on the other silliness of your post. |
|
Back to top |
|
|
ppandey07
New User
Joined: 27 Nov 2008 Posts: 51 Location: Delhi, India
|
|
|
|
dbzTHEdinosauer wrote: |
would be something like jclscan, i.e. a utility that does something to jcl.
i'll not comment on the other silliness of your post. |
Utility I meant - IDCAMS,IEBGENER etc.
Okay. No probs... BUT you must be humble while takling to somebody... |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
Hello,
Depending on the specifics (which you didn't post), you should be able to do this with your sort product.
Multiplying by -1 should accomplish what you want.
Depending on which sort product you use, there are probably examples here in the forum (DFSORT section for DFSORT and JCL section for Syncsort).
If you get stuck, post your issue and someone should be able to clarify. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
no, I MUST nothing.....
besides,
I post so that others reading your mistakes
know that what you have said is incorrect.
I had no illusions that you would see the error of your ways,
you are too busy trying to enforce what you think are Politically Correct Comments.
you have insulted everyone who spends at least enough time to use the correct terminology. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Besides,
you could avoid receiving all this 'bad talk'
if you would just do what most everyone else on the planet does,
Read the Manuals
(there are lots of figures and pictures, too!)
instead of being lazy and asking questions on an internet website. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
ppandey07 wrote: |
I have to modify three fields and there is one requirment to change sign of these three fields(make+ve to -ve and -ve to +ve). |
SORT, INREC/OUTREC OVERLAY, MULtiply by "-1" ? |
|
Back to top |
|
|
ppandey07
New User
Joined: 27 Nov 2008 Posts: 51 Location: Delhi, India
|
|
|
|
dick scherrer wrote: |
Hello,
Depending on the specifics (which you didn't post), you should be able to do this with your sort product.
Multiplying by -1 should accomplish what you want.
Depending on which sort product you use, there are probably examples here in the forum (DFSORT section for DFSORT and JCL section for Syncsort).
If you get stuck, post your issue and someone should be able to clarify. |
Thank you for your suggestions!!! I will try to use this. |
|
Back to top |
|
|
ppandey07
New User
Joined: 27 Nov 2008 Posts: 51 Location: Delhi, India
|
|
|
|
Anuj Dhawan wrote: |
ppandey07 wrote: |
I have to modify three fields and there is one requirment to change sign of these three fields(make+ve to -ve and -ve to +ve). |
SORT, INREC/OUTREC OVERLAY, MULtiply by "-1" ? |
Okay. Let me try this. Thank you!!! |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Subtract from zero. Unless you have millions and millions, maybe you won't notice. But if you do, you may. So I always subtract from zero. |
|
Back to top |
|
|
|