|
View previous topic :: View next topic
|
| Author |
Message |
ant1271
New User
Joined: 19 Apr 2007
Posts: 9
Location: Richmond
|
|
|
|
| Hi, i am trying to find a way to copy selected fields from a flat file into another flat file using IBM file manager. Currently i am doing it using FileAid, but my organisation has decided to part ways with fileaid. Has anyone used IBM file manager in this regard. Appreciate you help on this. |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forums,
If you search a bit you may find some topics that do this with File Manager.
If you look in DFSORT, there are several examples of copying selected data using the sort and/or icetool. Does your system use DFSORT or Syncsort or ?
If you would like to pursue this using your sort product, please post back and your topic can be moved. |
|
| Back to top |
|
|
ant1271
New User
Joined: 19 Apr 2007
Posts: 9
Location: Richmond
|
|
|
|
| I hope they allow me to do so. Yes sir, you can move my topic, but i am failing to search more topic to do with the help of file manager. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Yes, we don't have a lot of discussion about File Manager.
Does your system use DFSORT, Syncsort, or some other product?
Depending on which product you use, i'll relocate your topic. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| Use this link to display the Bookshelves for the different releases of FILE MANAGER. When you know the release that you are running at your shop, pick a shelf and I'd start with the USER's Guide. |
|
| Back to top |
|
|
Gursharan Khalsa
New User
Joined: 04 Sep 2007
Posts: 33
Location: Salinas
|
|
|
|
hi,
i was earlier using FILEAID , where I used to open more than one sessions,but with file manager I am able to open only one session.Can I open more than 1 session of filemanager?
thanks in advance |
|
| Back to top |
|
|
Biswajit D
New User
Joined: 17 Apr 2012
Posts: 50
Location: India
|
|
|
|
was browsing thru the forum and lost my way to this post...
what you need can definitely be done using FM...goto FM - option 3.3... fill in your dataset and layout details and edit the template...
| Code: |
ssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss
File Manager Copy Utility
Command ===>
From Partitioned, Sequential or VSAM Data Set, or HFS file:
Data set/path name . . 'XX.X.XXXXXX.FILE' +
Member . . . . . . . . (Blank or pattern for member list)
Volume serial . . . . . (If not cataloged)
Start key . . . . . . . key or slot
Skip count . . . . . . Include Repeat skip
Copy count . . . . . . ALL number of records to be copied
From Copybook or Template:
Data set name . . . . . 'XX.X.XXXXXX.PDS'
Member . . . . . . . . LAYOUT (Blank or pattern for member list)
Processing Options:
Copybook/template Enter "/" to select option
1 1. Above Batch execution Advanced member selection
2. None Use proc Skip member name list
3. Create dynamic Ignore length mismatch REXX member selection: P
/ Edit template JCL Source format Directory integrity
Type (1,2,S) Export mode Report PDS record counts
Binary mode, reclen |
now put a 'S' in front of the field you want and hit Enter... now copy the file and check your output... the output will have only the selected field...
| Code: |
Cmd Seq SHE Ref Field Name Picture Type Start Length
**** Top of data ****
1 1 LAYOUT AN 1 4080
s 2 2 FIELD1 99 BI -3 2
3 2 FIELD2 99 BI -1 2 |
|
|
| Back to top |
|
|
|
|
