Home      Mainframe Forum      Mainfarme Tutorials      IBM Manuals      Mainframe Interview Questions      Mainframe Books      IT News     SiteMap     Downloads


     
 
MAINFRAME - TIP OF THE DAY : All available storage is assigned to the job or jobstep, If REGION is coded 0K or 0M

Google
 
Web mainframegurukul.com

XREF Creation

 
Post new topic   Reply to topic    mainframegurukul.com Forum Index -> FILE-AID
  View previous topic :: View next topic  
Author Message
kotesh
Member


Joined: 26 Jun 2007
Posts: 1

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Wed Jun 27, 2007 12:28 am    Post subject: XREF Creation Reply with quote

Hi,
Could some one help me,in creating an XREF File.
How Can I view a file in Fileaid which has multiple Record Layouts.
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.

Sagarmukkawar
Member


Joined: 23 Jan 2008
Posts: 5

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Mon Jan 28, 2008 2:36 pm    Post subject: Reply with quote

Somewhat late......Smile

We may use file-aid for the creation of XREF with the help pf w;f;7 option in the endevour.

Hope it Might be useful...........
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
sharadgarg123
Member


Joined: 03 Mar 2009
Posts: 2

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Tue Mar 03, 2009 9:21 am    Post subject: Reply with quote

To view a XREF file for multiple recordsets enter the details of XREF. member name and appropiate selection criteria for recordset to be viewed and it is opened in the format as selected.
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
Anuj Dhawan
Moderator


Joined: 09 Aug 2008
Posts: 1631
Location: Mumbai, India

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Tue Mar 03, 2009 3:27 pm    Post subject: Reply with quote

Hi,

Please note this thread is been inactive for nearly 1 year, it's good to add in though - but question was how to create XREF & not how to use them?
_________________
Regards,
Anuj
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
Dave E
Member


Joined: 25 Jun 2009
Posts: 9

Answer was approved by Question owner.
Useful Post
1 votes
Not an useful post
Greate Post!! Salute Author
1 salutes

PostPosted: Fri Jun 26, 2009 6:28 pm    Post subject: Reply with quote

Hi,

Creating an XREF is really easy.

1. Take option 7 (labeled XREF) from the primary menu of File-AID.

2. Enter the dataset name of your XREF library and a member name for the XREF you want to create. For example, FILEAID.XREF as the dataset and PAYMENTS as the XREF member name, if this is for a payments data file. Note, the following are the attributes for the XREF dataset if you don't have one already allocated RECFM=VB, LRECL=300, BLKSIZE=304 and this MUST be a PDS.

3. On the same screen, enter the name of your record layout dataset (usually a copybook library). Then press enter.

4. On the next screen, enter a description for this XREF (this is optional). Then, on the bottom half of the screen, enter member names of members in the layout dataset which you want to use. When you press enter, File-AID automatically gets the 01 level record definitions from the layout members.

5. Using the S line command, against each of the record layout members, will bring up the record layout on the screen for you. Here i swhere you specify the condition that must be met in order for File-AID to use this record layout in your edit/browse session. For example, if you have a field called PAYMENT-TYPE, then under the RO column (which stands for relational operator) enter EQ and then to the right of that you can specify a value, for example DIRECT. This means that this record layout will be used whenever the PAYMENT-TYPE field has a value equal to the literal DIRECT. You will need to repeat this process for every record layout that you want to use in this XREF, obviously each one will have a different condition attached to it. Once you have finished, simply PF3 back out to your primary menu of File-AID.

6. You are now ready to use the XREF. Take option 2 (EDIT) from the primary menu. Enter the name of the dataset you want to edit and select edit mode of F (formatted). Enter record layout usage of X, specify the record laout dataset but NO member name. Specify the name of your XREF dataset and also the XREF member name. Then press enter. Now you will be in your edit session in formatted mode. As you scroll through your records, using PF11, File-AID will automatically select the correct layout definition depending on the selection criteria you defined in the XREF set up.

Easy as that ...

Good luck.
_________________
Dave E
Software Engineer
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
20sam13
Member


Joined: 13 Feb 2013
Posts: 6
Location: United States

Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Thu Jul 25, 2013 9:30 pm    Post subject: ** Using an XREF in File-Aid Reply with quote

I created an XREF that contains a 400-byte "data area" with over 340 redefined layouts within the single copybook.

Created the selection criteria
Selected the corresponding 05 group level data name that redefines the 400-byte "data area" (starting in col 100)
Saved everything, no errors

I try to browse the file, but it never shows the top 99-bytes + the CORRECT 400-byte "data area" redefined layout.

The criteria is based upon an error # in COL #10 defined as S9(04).

When I go and view the XREF, the criteria condition is trying to match on a "+9999" formatted type of number. But, the screen shows the top 99-bytes along with ALL of the XREF layouts I created.

What am I doing wrong??
_________________
Scott M
Back to top
View user's profile Send private message
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
academyindia4
Guest





Answer was approved by Question owner.
Useful Post
0 votes
Not an useful post
Greate Post!! Salute Author
0 salutes

PostPosted: Sat Jan 30, 2016 10:40 pm    Post subject: Topic deleted by Admin Reply with quote

<< Content deleted By Admin >>
Back to top
Click here, If this post answer your question. <-- Click on right mark icon. If this post answer your question.
Display posts from previous:   
Post new topic   Reply to topic    mainframegurukul.com Forum Index -> FILE-AID All times are GMT + 5 Hours
Page 1 of 1



 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Related topics
 Topics   Replies   Author   Views   Last Post 
No new posts Search Batch file-aid help 14 frenchman 31561 Mon Feb 01, 2016 10:23 pm
academyindia4 View latest post
No new posts File-Aid Help 3 Nicholas 21374 Mon Feb 01, 2016 10:22 pm
academyindia4 View latest post
No new posts Hi plz help me out 7 Guest 21197 Mon Feb 01, 2016 10:14 pm
academyindia4 View latest post
No new posts Need urgent HELP 4 Sulagna 12528 Mon Feb 01, 2016 1:39 am
academyindia4 View latest post
This topic is locked: you cannot edit posts or make replies. executing java program thru JCL 6 Guest 24809 Tue Feb 12, 2013 1:56 pm
Anuj Dhawan View latest post
 


Cobol Tutorial
This cobol tutorial covers most of the important topics like STRING, UNSTRING, COMP, COMP-3.....
DB2 Tutorial
DB2 Tutorial focuses on DB2 COBOL Programming. Explains in simple language. Some Chapters are locked, Forum members have free access to these chapters
CICS Tutorial
This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming...
JCL Tutorial
This is most popular JCL tutorial from mainframegurukul. It does contain important jcl ....
SORT Tutorial
This Tutorial covers all important aspects of DFSORT. Has more SORT examples
INTERVIEW Questions
This page covers important interview questions
Mainframe Jobs
Mainframe Jobs posted by members of mainframegurukul forum
FaceBook Page
MainframeGurukul FaceBook Page
LinkedIn Page
MainframeGurkul Linkedin Page

This widget requires Flash Player 9 or better







Go to top of the page
 

Online ABEND Reference ||  JCL References ||  COBOL References ||  VSAM References ||  Tutorials by Drona Series ||  SQL tutorial ||  BOOKS  ||  DB2 INTERVIEW QUESTIONS ||  COBOL INTERVIEW QUESTIONS  ||  JCL INTERVIEW QUESTIONS ||  JCL2 INTERVIEW QUESTIONS ||  VSAM INTERVIEW QUESTIONS ||  CICS INTERVIEW QUESTIONS  ||  Online tutorials ||  Online ABEND Reference ||  JCL References ||  COBOL References ||  VSAM References ||  Tutorials by Drona Series ||  SQL tutorial ||  BOOKS  ||  SiteMap  ||  Expeditor Tutorial  ||  FILE-AID Tutorial  ||  Changeman Tutorial  ||  COBOL   ||  DB2   ||  JCL  ||  CICS  ||  VSAM  ||  DB2 Interview Questions ( 110 )   || Simple JCL Tutorials  || JCL Tutorial from MainframeGurukul.com   || Simple JCL Tutorial - Chapter1 ;|| Mainframe Forum - Tutorials  || Mainframe Tutorials || Mainframe CICS tutorial|| Mainframe COBOL Tutorial

Drona Educational Forums - Mainframe Cobol DB2 CICS Board
Powered by phpBB

mainframetopic-2449.html