|
View previous topic :: View next topic
|
| Author |
Message |
sharan savadattimath
New User
Joined: 04 Apr 2011
Posts: 1
Location: Canada
|
|
|
|
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 |
|
 |
mprobst
New User
.jpg)
Joined: 14 Oct 2006
Posts: 14
Location: Appleton Wi USA
|
|
|
|
| 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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
|
|
|
|
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 |
|
|
Vinay N.G
New User
Joined: 15 Sep 2008
Posts: 36
Location: Bangalore
|
|
|
|
| But i think its possible to extract only certain fields with the help of FLEX commands. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
|
|
|
|
| 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 |
|
|
Vinay N.G
New User
Joined: 15 Sep 2008
Posts: 36
Location: Bangalore
|
|
|
|
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 |
|
|
DB2 Guy
New User
Joined: 28 Oct 2008
Posts: 98
Location: Cubicle
|
|
|
|
| Sorry, but I, for one, don't follow your answer - how and where to use, what you show? |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10891
Location: italy
|
|
|
|
| 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 |
|
|
DB2 Guy
New User
Joined: 28 Oct 2008
Posts: 98
Location: Cubicle
|
|
|
|
| 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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10891
Location: italy
|
|
|
|
 sorry for the tupoghripical/braincheck error , I really meant FILEAID
( I had IBM FILEMANAGER open on my tso session ) |
|
| Back to top |
|
|
|
|
