field expansion projects

induajayrose · New User Joined: 25 Jul 2005 Posts: 28 Location: Thrissur

hi,

pls giv me details of a field expannsion projects.any one know the coding of expanding field,if it is customer id

vijayamadhuri · Active User Joined: 06 Apr 2005 Posts: 187

Please be more clear

induajayrose · New User Joined: 25 Jul 2005 Posts: 28 Location: Thrissur

frnd,
I hv to do a field expansion projct as part of my training.in it i wnt to expand field of customer id. can u help me.

Prasanthhere · Active User Joined: 03 Aug 2005 Posts: 279

Regarding the field expansion project consider this

if in the case of a bank having account as 5digit no and due 2 more there account no has to b changed to a filed of length which was actually 5 .For this the first thing we r doing is the impact analysis.It mainly comes under Maintenence projects.During the impact all the fields that r affected due to the change in the account id field r found out and then the corresponding changing is done

divya · New User Joined: 10 Aug 2005 Posts: 8

hai prasanth,
Can u clarify it.Can we just declare the field with a 5 digit field and just compile and run the program.can u explain it through a coding part.hope u wil reply soon .
regards indu

ykishore · Active User Joined: 12 Aug 2005 Posts: 53 Location: USA

HI

normally , vll make utilize the FILLER caluse.actully when we declare a record lenght...ideally we give some extract space(FILLER ) for future use.so in future if we wanna change length of the filed vll use that FILLER clause.hope u got my point..

bonniem · Active User Joined: 09 Aug 2005 Posts: 68

Can we just declare the field with a 5 digit field and just compile and run the program.can u explain it through a coding part.hope u wil reply soon .
regards indu

You cannot just change the declaration as 5 and run. The field that is in consideration will be moved to other fields and vice versa. Also if it is a numeric field that is used in computation, then the destination variable size also should be increased so that overflow does not occur. There might be other considerations also, but in short a very thorough analysis on the use of the field is required. Many other fields will also have to be changed to accomodate the change in one field.

shivashunmugam Muthu · Posted: Tue Aug 16, 2005 7:23 pm Post subject:

radhakrishnan82 · Posted: Wed Aug 17, 2005 9:27 am Post subject:

The field expansion will result in change of more number of programs using that field.One more to add in IMPACT ANALYSIS is that we have to take care about the interfaces that links with your shop.We have to make sure that whether the changes will affect other interfaces also.
If yes,
1.what are the interfaces that is to be affected after changes.
2.know the interface that are acting as an input to your shop and interfaces that are taking your shop details as an Input.
2.Whether the affected interfaces are aware of the field change and working on it to adapt the changes.

Though its an minor change as per program point of view,IMPACT analysis is the important aspect here.
Its an interesting tasks to do!.You can get a clear picture about what is happening in your shop functionally.