Formatting a numeric field to make it negative.

IBM's Sort Product, ICETOOL, ICEMAN and ICEGENER.
Previous topicNext topic

Topic Author
utkarsh
Registered Member
Posts: 31
Joined: Fri Jun 21, 2013 10:32 pm
Zodiac: Sagittarius

Formatting a numeric field to make it negative.

Post by utkarsh » Tue May 02, 2017 4:49 pm

Hi,

For a test SORT job I need to format a numeric field to make it negative. For that, I can think of two options, one is to multiply yhr fied with "-1" or subtractit from 0. In both the case which one is more efficeint and why, please let me know.

If I have to test such scenario my own what can I do to get a fair estimate on this?




enrico-sorichetti
Global Moderator
Global Moderator
Posts: 874
Joined: Wed Sep 11, 2013 3:57 pm

Re: Formatting a numeric field to make it negative.

Post by enrico-sorichetti » Tue May 02, 2017 5:02 pm

how many billions of records do You have to process that would make any difference ?


cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort 8-)


Topic Author
utkarsh
Registered Member
Posts: 31
Joined: Fri Jun 21, 2013 10:32 pm
Zodiac: Sagittarius

Re: Formatting a numeric field to make it negative.

Post by utkarsh » Thu Nov 09, 2017 5:42 pm

Not billions of records are there but I shall have considerable amount of records, at least in millions. This job would be a daily job.



User avatar

Robert Sample
Global Moderator
Global Moderator
Posts: 1331
Joined: Fri Jun 28, 2013 1:22 am
Location: Dubuque Iowa
Zodiac: Virgo

Re: Formatting a numeric field to make it negative.

Post by Robert Sample » Thu Nov 09, 2017 8:52 pm

Even if you are processing 10 million records per day, that is only 3.65 billion per year. With the cycle time of the system Z machines, you might (and I stress MIGHT) make a few CPU seconds difference over the course of the entire year. You have already spent more time worrying about this than you could possibly save in several years or more.




enrico-sorichetti
Global Moderator
Global Moderator
Posts: 874
Joined: Wed Sep 11, 2013 3:57 pm

Re: Formatting a numeric field to make it negative.

Post by enrico-sorichetti » Thu Nov 09, 2017 9:02 pm

...I can think of two options, one is to multiply the field by -1 or subtract it from 0.
You are not making a field negative You are just switching the sign :?


cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort 8-)

Previous topicNext topic

Return to “IBM DFSort, ICETOOL, ICEMAN, ICEGENER.”