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
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
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    Post subject: Changing a Key Field of Child Segement in File-Aid/Batch
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    Post subject: Re: Changing a Key Field of Child Segement in File-Aid/Batch
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: 1105
Location: The Netherlands at Hole 19

PostPosted: Tue Dec 19, 2006 3:25 pm    Post subject:
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    Post subject:
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: 1105
Location: The Netherlands at Hole 19

PostPosted: Wed Dec 20, 2006 5:52 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts How to generate a new unique Input fi... for1ranjith CLIST & REXX 11 Sat Jul 01, 2017 12:09 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm


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