Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

INSYNC utility via JCL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
Sudhanshu Shekhar

New User


Joined: 23 Jul 2008
Posts: 27
Location: City of Joy

PostPosted: Mon Dec 14, 2009 4:54 pm    Post subject: INSYNC utility via JCL
Reply with quote

Hi,

We have a utility in INSYNC to convert FB files to CSV format, i want to know how to incorporate that in a JCL? Currently we write a cobol program to do the same, so was trying to reduce effort and use an inbuilt utility.

Shekhar
Back to top
View user's profile Send private message

Sudhanshu Shekhar

New User


Joined: 23 Jul 2008
Posts: 27
Location: City of Joy

PostPosted: Mon Dec 14, 2009 5:06 pm    Post subject: Reply to: INSYNC utility via JCL
Reply with quote

I have found many examples so far, where you can delimit with "," using DFsort. But wat i am looking for is a utility that will delimit based on a copybook to create a .CSV.....
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Dec 14, 2009 8:15 pm    Post subject:
Reply with quote

Hello,

How do you use it now? Suggest the same control information will be used in batch. The documentation should show the necessary jcl or you might talk with someone who is responsible for support of INSYNC.

If all else fails, you might look in the product documentation. . .
Back to top
View user's profile Send private message
Sudhanshu Shekhar

New User


Joined: 23 Jul 2008
Posts: 27
Location: City of Joy

PostPosted: Wed Dec 16, 2009 2:59 pm    Post subject:
Reply with quote

Thanks Dick,

I finally found the way to do it.... hewre is how

Code:

//STEP1    EXEC PGM=INSYNC,PARM=MVS,REGION=??           
//STEPLIB  DD DISP=SHR,DSN=SYS1.M4.INSYNC.LOADLIB       
//*                                                     
//#ELIBDD  DD DISP=SHR,DSN=SYS1.M4.INSYNC.ELIB         
//SYSTSPRT DD SYSOUT=*                                 
//#LOG     DD SYSOUT=*                                 
//#PRINT   DD SYSOUT=*                                 
//#STATS   DD SYSOUT=*                                 
//#INDD    DD DSN=IN.FILE,DISP=SHR
//#OUTDD   DD DSN=OUT.FILE,DISP=SHR
//#PARM    DD *                                         
FUNCTION=EXTRACT                                       
INDD=#INDD                                             
OUTDD=#OUTDD                                           
RDW=ON                                                 
REPLACEDUPS=NO                                         
CSVDELIM=,                                             
CSVQUOTE=SINGLE                                         
CSVQUOTECHARS=NO                                       
CSVQUOTENUMS=NO                                         
CSVLEADINGBLANKS=NO                                     
CSVTRAILINGBLANKS=NO                                   
CSVLEADINGZEROS=NO                                     
CSVEXCLUDEFILLER=NO                                     
CSVINCLUDEHEADER=YES                                   
ADDTOOUTPUT=NO                                         
LINESPERPAGE=080                                       
FORMATDSN=(LAYOUT.COPYLIB)               
FORMATMBR=(TEST)
//*
[/quote]
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Dec 16, 2009 9:46 pm    Post subject: Reply to: INSYNC utility via JCL
Reply with quote

Good to hear it is working - thank you for letting us know your solution icon_smile.gif

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 - TERMINATE utility vasanthz DB2 5 Mon May 15, 2017 11:49 pm
No new posts HLIST Utility In Batch Virendra Shambharkar TSO/ISPF 4 Fri Apr 07, 2017 3:38 pm
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts TAPE VERIFY utility?? MrExtraordinare JCL & VSAM 3 Fri Dec 09, 2016 10:57 pm
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us