|
View previous topic :: View next topic
|
| Author |
Message |
Marichamy
New User
Joined: 29 Jan 2006
Posts: 1
Location: hyderabad
|
|
|
|
Hi all,
I have requirement like there is an flat file which contains customer information in different locations. say for eg., firstname and last name may be in poisition 10 and 30 and other information will be in some other location. for some of the fields (say more than 3 columns) i need to replace with new values. I tried doing in Fileaid utility in JCL but I not able to give multiple if conditions to validate the record. Is it possible to give multiple if's for validation the different locations of records.
//SYSIN DD *
$$DD01 COPYALL IF=(225,EQ,C'MI,BC'),
MOVE=(163,2,225),
MOVE=(165,C'12345'),
ELSE,
MOVE=(163,C' '),
MOVE=(165,8,227),
IF=(225,EQ,C'ON'),
MOVE=(163,2,225),
MOVE=(165,C'A1B2C3'),
ELSE,
MOVE=(163,C' '),
MOVE=(165,8,227),
MOVE=(1,26,42),MOVE=(27,34,73), 1ST AND LAST NAME
MOVE=(61,39,108),MOVE=(100,39,148), ADDR1 AND ADD2
MOVE=(139,24,195) CITY
/* |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
Don't know. Why don't YOU try it out and report back to us if it's possible  |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA
|
|
|
|
Why not something like
| Code: |
IF=(225,EQ,C'ON'),
MOVE=(163,2,225),
MOVE=(165,C'A1B2C3'),
IF=(225,NE,C'ON'),
MOVE=(163,C' '),
MOVE=(165,8,227), |
|
|
| Back to top |
|
|
|
|
  |
All times are GMT + 6 Hours |
|
