change field size

coexistence_cnc

Active Member
My programming days are long behind me. Was hoping someone could answer the following question for me.

Is it possible to set the length of a field (ie. order number) to a larger size? (Currently 10 - maybe to 16 or 20?)

I would think that if this is an actual database change the answer would be no BUT is there something that can be done via the data dictionary or vocabulary override.

Thanking you in advance for your assistance.

RS/6000..AIX...DB2/UDB...OneWorld xe base, on our way to Update 6.
 
Once the table is generated, all db fields' length is hard coded. But you can combine other db fields to make it larger and then create new index(es) for the new keys.

In Edwards' table file, there are user reserved db fields such as User Reserved Code, User Number, User Reserved Reference and etc., you can combine the Order Number (8 bytes) with User Reserved Number (8 bytes) to make it a total size of 16. Then add new index(es) for DOCO and URAB so you attach it to the BSVW and perform table I-O in the Event Rule or attach the BSVW to a APPL/UBE. This would involve ER code changes for existing application.
 
Back
Top