JDE中改变一个表的中字段大小(DD)的步骤。

本文详细介绍了如何在Oracle环境中更改标准企业级数据字典项目,包括更改长度、刷新数据字典规格、重新生成表格等步骤。同时强调了在变更前进行影响分析的重要性,以确保对其他对象的影响最小化。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

 从Oracle的官方支持中得来的,以示留住:

 

If you are changing a standard EnterpriseOne data dictionary item -> please note that this is NOT RECOMMENDED OR SUPPORTED.
E1: DD: Impact of Changing the Size of a Standard Data Dictionary Item (Doc ID 643221.1)
E1: DD: Increase UDC field KY 00|DT (Doc ID 632367.1)
E1: DD: Frequently Asked Questions on Data Dictionary (Doc ID 626537.1)

If you are changing a customized DD item from a customized table
1) Make the change in DD for the length
2) Refreshing the data dictionary specs
a) Run the following on the FAT client where the table generation will run
b) open the jde.ini
c) add entry TAMMenus=Show in the section [INTERACTIVE RUNTIME]
d) save the jde.ini (no need to sign out of OneWorld)
e) in fastpath, enter UTB
f) lick
on File|Open Local TAM, double-click on DDDICT.DDB and find the DD
alias in szDict column, column nLength stores the length of DD Alias
g) click on File|Open Table, find F9210, find the DD Alias in column FRDTAI, column FRDTAS stores the length of DD Alias
h) if
the DD specs has the original length, inquire on the DD alias in P92001
and click OK to refresh the DD specs, verify again in UTB
 

3) Regenerate the table
a) OMW,
go to Table Design Aid of the custom table, in Indices window,
right-click Add New and then delete the entry in order to enable the
Save button,
Save and Exit.
b) Verify that the table header file in the
pathcode/include directory contains the new length of the DD item.

c) run the table generation.

4) Please note that you need do a  perform an impact analysis on the change that will affect other objects and do the necessary changes as well.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值