Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts File Tailoring -- Temporary dataset i... samzee71 CLIST & REXX 3 Fri Dec 01, 2017 3:12 am
No new posts Rexx - File tailoring samzee71 CLIST & REXX 10 Thu Nov 30, 2017 10:47 pm
No new posts CA Intertest Batch 555shanth CA Products 0 Tue Nov 28, 2017 11:10 am
No new posts How to query MAXGENS of an existing P... Chuchulo Hatyzak JCL & VSAM 4 Wed Nov 22, 2017 10:23 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us