IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Fields extract: File-aid for IMS


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
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
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
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

Superior Member


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

PostPosted: Tue Apr 12, 2011 12:05 pm
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
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

Superior Member


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

PostPosted: Mon May 23, 2011 4:06 pm
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
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Tue May 24, 2011 8:44 pm
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Tue May 24, 2011 9:04 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
Search our Forums:

Back to Top