How to copy a file by inserting quotes?

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
Divya
Member
Posts: 2
Joined: Sat Jan 13, 2007 1:06 pm

How to copy a file by inserting quotes?

Post by Divya » Sat Jan 13, 2007 1:18 pm

I want to copy a sequential file which has all the text fields and the all fields in this file are seperated by commas. My requirement is to copy the same file into other file by adding a single quote around all the text fields (I do not want to delete the existing commas)? Please advise me, thru which jcl utility I can do this and how?

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Sat Jan 13, 2007 10:24 pm

It's not clear what you want to do so you need to answer some questions to clarify things.

I assume you have input records something like this:

text1,text2,text3

Do you want the output to be:

'text1','text2','text3'

or

'text1,text2,text3'

Can some of the text fields have embedded blanks? For example:

John Doe,San Jose,California

What is the maximum length for a text field?

Please show an example of your input records and what you want for output. Also, what is the RECFM and LRECL of your input file?
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

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