Re: [EXTERNAL] Change order (sort) print file in COBOL program

Re Rob's #4 - Of course SQL is effusively going to be building a view/index under the covers anyway - but it will be transitory. If the report is to be run regularly the creating it permanently will save resources.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On May 13, 2019, at 12:38 PM, Rob Berendt <rob@xxxxxxxxx> wrote:

1 - There's a part of me that feels like helping you get through this competency check is about the same as helping someone with the same assignment during a college final exam. Oh well, maybe creative problem solving is part of the test?
2 - I'd use your gut as to the "best way". Personally I agree with Jon here as I would stay away from Open Query File as it's now time to showcase your SQL skills. However, if you're dealing with someone who thumps his chest due to his Open Query File skills you may be falling flat on your face.
3 - As far as whether or not to create another index, it's probably necessary if you plan to avoid SQL and Open Query File and you want to process by key.
4 - If you use SQL you might be able to avoid the other index but you may want to comment your code to check the index advisor to see if it recommends another key for performance enhancement. Knowing about the index advisor may be a feather in your cap in proving your competency.


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jon Paris
Sent: Monday, May 13, 2019 12:48 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [EXTERNAL] Change order (sort) print file in COBOL program

Then I'd certainly consider using SQL as an option since it will demonstrate that you are au fait with current technology. Also consider the logical/SQL view file approach. Personally I'd stay away from Open Query file 'cos it smacks of the 1900s - I know it is still used but it is not really the way we are going.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On May 13, 2019, at 8:37 AM, Richard Reeve <rjrjr64@xxxxxxxxx> wrote:

Hi Alan,

This is an exercise given me by a potential employer. I was
just given a short COBOL program (don't even know the current key
because it is an externally described file) and they want the print
file sorted by div/date. That's all they requested.

Thanks again for your time.

All the best,

Richard Reeve


On Mon, May 13, 2019 at 8:13 AM Alan Shore via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Richard
You may still need to change the COBOL program What totals does it
provide, the new order is by Division & Date. What was the old order
- and what totals - if any did the program provide Not knowing
everything about this program, current file and new file hampers how
we can answer

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
‘If you're going through hell, keep going.’
Winston Churchill


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On
Behalf Of Rich Loeber
Sent: Monday, May 13, 2019 9:09 AM
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [EXTERNAL] Re: Change order (sort) print file in COBOL
program

Richard,

You can create a temporary LF by using the OPNQRYF command in CL just
before you call the Cobol program. I've used this successfully.

Rich Loeber - @richloeber
Kisco Information Systems
[1]http://www.kisco.com


---------------------------------------------------------------------
-----

On 5/13/2019 9:03 AM, Richard Reeve wrote:

Hi Alan,

I haven't done any COBOL on the i since 2004,. so you're
right, I'm no longer an expert but am trying to get back up to
speed. Not to be argumentative, but is a logical file really the
best solution for a report? If not, what is?

Thanks much for taking the time to help me out.

All the best,

Richard Reeve


On Mon, May 13, 2019 at 7:52 AM Alan Shore via MIDRANGE-L < [2]
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:


It sounds like you are not that conversant with COBOL In my opinion
- create the logical No matter which way you go - there will
probably be changes needed

Alan Shore
E-mail : [3]ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

-----Original Message-----
From: MIDRANGE-L [[4]mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On
Behalf Of David Gibbs via MIDRANGE-L
Sent: Monday, May 13, 2019 8:49 AM
To: Midrange Systems Technical Discussion [5]<
midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: David Gibbs [6]<david@xxxxxxxxxxxx>
Subject: [EXTERNAL] Re: Change order (sort) print file in COBOL
program

On Mon, May 13, 2019 at 7:17 AM Richard Reeve [7]<rjrjr64@xxxxxxxxx>
wrote:

I have been asked to change the order of a print file in a COBOL

program.

This question would be more appropriate on the COBOL400-L list ( [8]
https://mlists.org/cobol400-l).

david

--
IBM i on Power Systems: For when you can't afford to be out of business!

I'm riding 615 miles (Yes, you read that right) in the American
Diabetes Association's Tour de Cure to raise money for diabetes
research, education, advocacy, and awareness. You can make a
tax-deductible donation to my ride by visiting [9]https://mideml.diabetessucks.net.

You can see where my donations come from by visiting my interactive
donation map ... [10]https://mideml.diabetessucks.net/map (it's a
geeky thing).

I may have diabetes, but diabetes doesn't have me!
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email:
[11]MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: [12]https://lists.midrange.com/mailman/listinfo/midrange-l
or email: [13]MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at [14]
https://archive.midrange.com/midrange-l.

Please contact [15]support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link: [16]https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email:
[17]MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: [18]https://lists.midrange.com/mailman/listinfo/midrange-l
or email: [19]MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at [20]
https://archive.midrange.com/midrange-l.

Please contact [21]support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link: [22]https://amazon.midrange.com

References

Visible links
1. http://www.kisco.com/
2. mailto:midrange-l@xxxxxxxxxxxxxxxxxx
3. mailto:ASHORE@xxxxxxxx
4. mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx
5. mailto:midrange-l@xxxxxxxxxxxxxxxxxx
6. mailto:david@xxxxxxxxxxxx
7. mailto:rjrjr64@xxxxxxxxx
8. https://mlists.org/cobol400-l
9. https://mideml.diabetessucks.net/ 10.
https://mideml.diabetessucks.net/map
11. mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx
12. https://lists.midrange.com/mailman/listinfo/midrange-l
13. mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
14. https://archive.midrange.com/midrange-l
15. mailto:support@xxxxxxxxxxxx
16. https://amazon.midrange.com/
17. mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx
18. https://lists.midrange.com/mailman/listinfo/midrange-l
19. mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
20. https://archive.midrange.com/midrange-l
21. mailto:support@xxxxxxxxxxxx
22. https://amazon.midrange.com/
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link: https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)
mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com