AS400 Flat files
Hi,
I have a flat files which contains address, phone numbers, etc.. i want to update the address (ABC..) and phone numbers (1234..) for all the records commenly which is placed in some position in the file. Can any one suggest me that how it can be done (any qry or program)?
- Jack Spenzer
Software/Hardware used:
Software/Hardware used:
ASKED:
July 30, 2009 6:26 AM
UPDATED:
July 30, 2009 3:53 PM
Answer Wiki:
Frequently or one-time
Change effects all records with ...
give a couple of examples.
______________________________________________________________
That's what I thought.
I would do it in interactive sql
but first make a backup of the file!!! this is likely to take a couple of tries
Update filexxx
Set fieldyyy = substring(fieldyyy,1,55)
+ 'Your Value'
+ substring(fieldyyy, 66, 999
Where 55 was the last char before your change
'Your Value' is obviously the new stuff
66 is the start of the unaltered data
999 is the length third part, the length of the record - 65 (or is it 66)
Phil
________________________________________________________________
To see all answers submitted to the Answer Wiki: View Answer History.
this updation is for one time…
Ex. i want to give ‘abcdefgh’ as name (say position 55 -65) in the flat file for all the records.