My situation is..... I have a field (Sequence Number) which is a numeric-field (Len 6,0).
Now the records this field can accommodate is limited/restricted to a maximum of 999999.
This application has been running for years together now. Therefore the demand to accommodate maximum no. of records has come into being.
The client is very much concerned by this limit.
Now will changing this Field to a 6-digit char field instead of 6-digit numeric, solve the issue?(incidentally I came up with this idea).
But if we implement this idea; I don't know what will be the impact on the programs(as almost 90% of the programs use this Sequence Number).
Also I'm unaware as to how many records this field will accommodate?
for e.g. if we start with A00001 as the 1st record....continuing till A99999; then start with B00001......B99999; C00001.....C99999 & so on till it reaches Z99999;
Then again Start with "AA0001......AA9999; then continue with AB0001......till..AB9999; & so on till it reaches AZ9999;
Then Again start with AAA001.....AAA999; AAB001.....AAB999; AAC001.....AAC999; till it reaches AAZ999;
Then Again start with AAAA01.....AAAA99; AAAB01.....AAAB99; AAAC01.....AAAC99; till it reaches AAAZ99;
Then Again start with AAAAA1.....AAAAA9; AAAAB1.....AAAAB9; etc., till it reaches AAAAZ9;
I'm unable to visualize what other combinations can be possible like ABA001...ABA999; till it reaches ABZ999; then ACA001...ACA999; till it reaches ACZ999;...like that till AZZ999 etc., then again start with ABAA01...ABAA09 till ABAZ99; then again start with ABB001...ABB999 till ABZ999.
I need a logic how to build this? Any thoughts/help would be greatly appreciated.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!