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

Changing a Key Field of Child Segement in File-Aid/Batch


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Arun Kumar Tupili

New User


Joined: 30 Nov 2006
Posts: 14
Location: Banglore

PostPosted: Wed Dec 13, 2006 1:23 pm
Reply with quote

Hi,
I want to change some fields of a Particular Child Segment Occurance of a Specific Root Segment in a Database using File-Aid Batch.The Database has three segments.

Roota------Root Segment
Childa----child segment of Roota
Childb----child segment of Roota

The Root Segment key filelds are and valuse are
COMPANY PS 1 =0
FIELD-TYPE PS 1 =2
COLUMN PS 3 =1
TABLE PS 3 =1

The Child Segment Key fields and vlaues are
NUMERICA PS 7 =1
RANGE PS 1 =1
NUMERICZ PS 7 =16

I want to change NUMERICZ value 16 to 20 using File-aid/Batch
I know the syntax of Selecting a root segment and changing it.
But I don't know the syntax for changing the child segment.
Also if you have any document of the syntax for file-aid batch for IMS please send me.

The syntax that I used was

SELECT SEGMENT=ROOTA MAX=ALL
WHERE COMPANY=0
AND FIELD-TYPE=2
AND COLUMN=1
AND TABLE=1
SEGMENT=CHILDA
WHERE NUMERICA=1
AND RANGE=1
AND NUMERICZ=16
CHANGE SEGMENT=CHILDA
SET=(NUMERICA=1);
SET=(RANGE=1);
SET=(NUMERICZ=24);

But I am getting Some Syntax Errors.
Back to top
View user's profile Send private message
Arun Kumar Tupili

New User


Joined: 30 Nov 2006
Posts: 14
Location: Banglore

PostPosted: Mon Dec 18, 2006 3:33 pm
Reply with quote

By doing trail and error at last I got the syntax corrected.

SELECT SEGMENT=ROOTA MAX=ALL
WHERE COMPANY=0
AND FIELD-TYPE=2
AND COLUMN=1
AND TABLE=1
SEGMENT=CHILDA
WHERE NUMERICA=1
AND RANGE=1
AND NUMERICZ=16
DELETE SEGMENT=CHILDA;

SELECT SEGMENT=ROOTA MAX=ALL
WHERE COMPANY=0
AND FIELD-TYPE=2
AND COLUMN=1
AND TABLE=1
SEGMENT=CHILDA
WHERE NUMERICA=1
AND RANGE=1
AND NUMERICZ=24
INSERT SEGMENT=CHILDA
SET=(NUMERICA=1)
SET=(RANGE=1)
SET=(NUMERICZ=24);
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19

PostPosted: Tue Dec 19, 2006 3:25 pm
Reply with quote

Good for you.........instead of trial and error you also might read manuals icon_confused.gif
Back to top
View user's profile Send private message
Arun Kumar Tupili

New User


Joined: 30 Nov 2006
Posts: 14
Location: Banglore

PostPosted: Wed Dec 20, 2006 4:06 pm
Reply with quote

But I didn't find proper document for File-Aid/Batch.
Could you please send me the links related
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19

PostPosted: Wed Dec 20, 2006 5:52 pm
Reply with quote

File-aid is a Compuware product so I suggest you do some searching for that. There might even be some info at this forum.

From IBM something similar:
file manager for IMS by IBM
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 -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 7
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