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
 

 

Fields extract: File-aid for IMS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
sharan savadattimath

New User


Joined: 04 Apr 2011
Posts: 1
Location: Canada

PostPosted: Mon Apr 04, 2011 11:12 pm    Post subject: Fields extract: File-aid for IMS
Reply with quote

Hi All,
Could you please help me on how to extract specific fields of a segment using file-aid for IMS?
Extract/Load extracts the whole segment based on my selection criteria. But my requirement is to have fewer fields in my output.

Thanks!
Back to top
View user's profile Send private message

mprobst

New User


Joined: 14 Oct 2006
Posts: 14
Location: Appleton Wi USA

PostPosted: Tue Apr 12, 2011 2:05 am    Post subject: Reply to: Fields extract: File-aid for IMS
Reply with quote

I don't believe there is a way to extract just certain fields from IMS segments using Fileaid/IMS. It is designed to extract segments and then load those segments back to another IMS database. You could however, extract segments based on the field criteria and then use Fileaid/MVS to extract just certain fields from the Fileaid/IMS extract file into another output file.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Apr 12, 2011 12:05 pm    Post subject:
Reply with quote

In IMS, you play with segments not with fields. I agree with mprobst.

An after though... think, how the IMS is structured! As Sandy (Zimmer) has already said it many times...
Back to top
View user's profile Send private message
Vinay N.G

New User


Joined: 15 Sep 2008
Posts: 36
Location: Bangalore

PostPosted: Sat May 21, 2011 9:41 am    Post subject: Reply to: Fields extract: File-aid for IMS
Reply with quote

But i think its possible to extract only certain fields with the help of FLEX commands.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon May 23, 2011 4:06 pm    Post subject:
Reply with quote

Could you please share an example with us, for FLEX. It's been a while when I worked with File-Aid IMS.
Back to top
View user's profile Send private message
Vinay N.G

New User


Joined: 15 Sep 2008
Posts: 36
Location: Bangalore

PostPosted: Mon May 23, 2011 6:17 pm    Post subject: Reply to: Fields extract: File-aid for IMS
Reply with quote

Here is an example,

TYPE RUN ;
PSB DBNAME=DB1234 XREF=XREF1234 ;
SET OUTPUT=IXPOUT;
SELECT SEGMENT=SEG1234 MAX=ALL
WHERE FIELD1=1234
PRINT SEGMENT=SEG1234
FIELD=(FIELD1,FIELD2);

DB1234 -> DBD name
XREF1234 - > Corresponding Xref
SEG1234 -> Segment which you want to access.
FIELD1 -> Field which should satisfy your condition
FIELD=(FIELD1,FIELD2) - > Fields that are to be displayed
Back to top
View user's profile Send private message
DB2 Guy

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Tue May 24, 2011 8:39 pm    Post subject: Reply to: Fields extract: File-aid for IMS
Reply with quote

Sorry, but I, for one, don't follow your answer - how and where to use, what you show?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Tue May 24, 2011 8:44 pm    Post subject: Reply to: Fields extract: File-aid for IMS
Reply with quote

Quote:
how and where to use, what you show?


Jut a guess, it could be the syntax for mangling IMS databases using FILEMANAGER
Back to top
View user's profile Send private message
DB2 Guy

New User


Joined: 28 Oct 2008
Posts: 98
Location: Cubicle

PostPosted: Tue May 24, 2011 8:50 pm    Post subject:
Reply with quote

Thanks Enrico, however, it looks like it's about File-Aid (as per the subject line of the thread); and if it is - I'd like to use it as I've File-Aid installed at this shop. On the other hand, if it is about FILEMANAGER, I'm out of luck.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Tue May 24, 2011 9:04 pm    Post subject: Reply to: Fields extract: File-aid for IMS
Reply with quote

icon_redface.gif sorry for the tupoghripical/braincheck error , I really meant FILEAID
( I had IBM FILEMANAGER open on my tso session )
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 -> Compuware & Other Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm


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