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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.