help me in creating EXCEL document as OUTPUT FROM COBOL PROG

This is a Mainframe COBOL forum - you can post your queries on Mainframe COBOL, VS COBOL II, COBOL/370 , Enterprise COBOL

Moderators: dbzTHEdinosauer, Moderator Group

William Collins
Active Member
Posts: 732
Joined: Thu May 24, 2012 4:07 am

Post by William Collins » Mon Apr 21, 2014 12:51 pm

You are missing the point. NicC is saying that SQZ is not JCL. If you look at the JCL Reference Manual you will see that he is 1000% correct.

SQZ is from SORT. You use it in a Sort Control Card. Where did you find "CENTRE"?

Please don't use OUTREC (or INREC or OUTFIL) FIELDS=. Use BUILD= instead. FIELDS= is still supported so that old SORT control decks work unchanged. Get up-to-date and use BUILD.

NicC
Active Member
Posts: 650
Joined: Sun Jul 24, 2011 5:27 pm
Location: Down on the pig farm

Post by NicC » Mon Apr 21, 2014 1:02 pm

If you want to insert characters .. DELIM is there .. dunno the syntax .. OK

So try using MID
You can also align SHIFT, LEFT and CENTRE
(Please note corrections that I made to the original text whilst quoting)

Code: Select all

OUTREC FIELDS=(1,80,SQZ=(SHIFT=LEFT,MID=C','))
Why should I call sort to process a dataset that I can create correctly in the first place? That is just slothful and a waste of resources.
Regards
Nic

Attack1988
Member
Posts: 18
Joined: Tue Apr 15, 2014 4:18 pm

Post by Attack1988 » Mon Apr 21, 2014 1:52 pm

NicC, i am just new .. to mainframe and to forums .

No only learnt how to use code tags

.
Attack1988

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Sun Apr 27, 2014 2:27 pm

First page to second page of this thread and it feels like you've read multiple threads in a single go!

Attack1988 - suggest you could start a different thread if you've more questions.
Regards,
Anuj

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others