Copybook reformatting

Compuware's data management products: File-AID for IMS, File-AID/MVS, File-AID for DB2 and DBA-XPERT for DB2
thermalchu
Posts: 38
Joined: Thu Aug 30, 2012 3:47 pm
Skillset: JCL,COBOL,CICS,DB2,REXX
Referer: Internet

Copybook reformatting

Postby thermalchu » Mon Sep 24, 2012 2:25 pm

I have a data file with copybook. I have to reformat this file according to new copybook in which some fields are removed. The new file should contain data only from the common fields of both copybook. Can it be done using XREF?

thermalchu
Posts: 38
Joined: Thu Aug 30, 2012 3:47 pm
Skillset: JCL,COBOL,CICS,DB2,REXX
Referer: Internet

Re: Copybook reformatting

Postby thermalchu » Mon Sep 24, 2012 4:09 pm

k,got it...Thanks

BillyBoyo
Global moderator
Posts: 3805
Joined: Tue Jan 25, 2011 12:02 am
Skillset: Easytrieve Plus, Cobol, Utilities, that sort of stuff
Referer: Google

Re: Copybook reformatting

Postby BillyBoyo » Mon Sep 24, 2012 5:49 pm

Thanks for letting us know. Would you like to share your solution, which may help others facing a similar task in the future?

thermalchu
Posts: 38
Joined: Thu Aug 30, 2012 3:47 pm
Skillset: JCL,COBOL,CICS,DB2,REXX
Referer: Internet

Re: Copybook reformatting

Postby thermalchu » Tue Sep 25, 2012 4:08 pm

I used REFORMAT option in File aid. It is working when I do it as online but while trying to generate jcl to submit it via batch mode, it shows error: UTILITY DATA SET NOT IN CATALOG OR CATALOG CAN NOT BE ACCESSED. I searched in google for the screenshots/File aid tutorials which shows how to do batch REFORMAT. I didn't got any. :(

NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

Re: Copybook reformatting

Postby NicC » Tue Sep 25, 2012 4:14 pm

Did you search with your File-Aid support people?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic

thermalchu
Posts: 38
Joined: Thu Aug 30, 2012 3:47 pm
Skillset: JCL,COBOL,CICS,DB2,REXX
Referer: Internet

Re: Copybook reformatting

Postby thermalchu » Tue Sep 25, 2012 4:30 pm

I think we don't have support people.

NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

Re: Copybook reformatting

Postby NicC » Tue Sep 25, 2012 4:40 pm

Someone must have installed it and be responsible for maintaining and updating it. Or some group - possibly the sysprogs. Ask around. Ask your manager if necessary.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic

thermalchu
Posts: 38
Joined: Thu Aug 30, 2012 3:47 pm
Skillset: JCL,COBOL,CICS,DB2,REXX
Referer: Internet

Re: Copybook reformatting

Postby thermalchu » Tue Sep 25, 2012 5:04 pm

k,I'll try. Still can you suggest any reference?

NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

Re: Copybook reformatting

Postby NicC » Tue Sep 25, 2012 6:53 pm

The order of applying references:
F1 key
Manual/documentation
colleagues
support group
software supplier
internet search
forums
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic

thermalchu
Posts: 38
Joined: Thu Aug 30, 2012 3:47 pm
Skillset: JCL,COBOL,CICS,DB2,REXX
Referer: Internet

Re: Copybook reformatting

Postby thermalchu » Thu Sep 27, 2012 2:35 pm

I got an error:
$$DD01 REFORMAT OUT=0,REFOUT=ALL
ABOVE FUNCTION ENDED ON DD01R IS NOT A REFORMAT DEFINITION

How to write correct Reformat definition??