View previous topic :: View next topic
|
Author |
Message |
Arun Kumar Tupili
New User
Joined: 30 Nov 2006 Posts: 14 Location: Banglore
|
|
|
|
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 |
|
|
Arun Kumar Tupili
New User
Joined: 30 Nov 2006 Posts: 14 Location: Banglore
|
|
|
|
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 |
|
|
Bitneuker
CICS Moderator
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
|
|
|
|
Good for you.........instead of trial and error you also might read manuals |
|
Back to top |
|
|
Arun Kumar Tupili
New User
Joined: 30 Nov 2006 Posts: 14 Location: Banglore
|
|
|
|
But I didn't find proper document for File-Aid/Batch.
Could you please send me the links related |
|
Back to top |
|
|
Bitneuker
CICS Moderator
Joined: 07 Nov 2005 Posts: 1104 Location: The Netherlands at Hole 19
|
|
|
|
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 |
|
|
|