b_gilmore
Well Known Member
Re: [Adding a new field/column to an existing table]
I've found that letting JDE gen the table give the best results as far as
allowing the apps to see the new column. Here's what I've found adequate.
Copy the existing table with
create table jdetemp.f554701 like rcdta.f554701;
insert into jdetemp.f554701 select * from rcdta.f554701;
Then regen the table with OMW
Then create an SQL insert statement which names all the columns in the
existing table plus hard code a value for your new column. (e.g. insert into
rcdta.f554701 select SYEDTY, SYEDSQ, SYEKCO, SYEDOC,...., '0' FROM
JDETEMP.F554701
Then all you have to do is build an update package which includes the new
table, deploy to all workstations and servers (which will clear the DD tam
files), regen all the DDTAM for your Citrix Servers (if you have any).
Now you can create or modify your BSVW and rehook it to your app. You should
also be able to view the new column in UTB (because of the DD Tam file
update).
KevinCourtney <[email protected]> wrote:
to use JDE’s “Generate Table” because the table has existing data and I
don’t want to loose it.I’ve added the column using SQL with the
command…ALTER TABLE RCDTA/F554701 ADD E155EDTC CHAR(2)…I’ve added the new
column to the JDE specs and to the business view. Did the trick of adding an
extra column to the table, saving, then deleting the column to clear the
cache.My application is not seeing the new field, even after I’ve attached it
to a new business view. Message in the jde.log is “JDB9900258 - Failed to
find all requested columns in table”More disturbing is that UTB doesn’t see
the new field.I’m going to promote the changes tonight and see if that clears
it up.I’m wondering if any of you have a system of adding a new field/column
to an existing table without loosing the data? Preferably using the ‘alter
table…’ SQL statement.Using an application for grid importing the data into
t!
records that are in the table…Thanks in advance,
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OWDEV&Number=70607
these messages, login to http://www.jdelist.com/forums, click Control Panel,
then click Edit by "Subscribe / Unsubscribe from receiving board posts by
email, change message notifications, etc." and adjust your subscription
preferences. JDEList is not affiliated with JDEdwards®
I've found that letting JDE gen the table give the best results as far as
allowing the apps to see the new column. Here's what I've found adequate.
Copy the existing table with
create table jdetemp.f554701 like rcdta.f554701;
insert into jdetemp.f554701 select * from rcdta.f554701;
Then regen the table with OMW
Then create an SQL insert statement which names all the columns in the
existing table plus hard code a value for your new column. (e.g. insert into
rcdta.f554701 select SYEDTY, SYEDSQ, SYEKCO, SYEDOC,...., '0' FROM
JDETEMP.F554701
Then all you have to do is build an update package which includes the new
table, deploy to all workstations and servers (which will clear the DD tam
files), regen all the DDTAM for your Citrix Servers (if you have any).
Now you can create or modify your BSVW and rehook it to your app. You should
also be able to view the new column in UTB (because of the DD Tam file
update).
KevinCourtney <[email protected]> wrote:
to use JDE’s “Generate Table” because the table has existing data and I
don’t want to loose it.I’ve added the column using SQL with the
command…ALTER TABLE RCDTA/F554701 ADD E155EDTC CHAR(2)…I’ve added the new
column to the JDE specs and to the business view. Did the trick of adding an
extra column to the table, saving, then deleting the column to clear the
cache.My application is not seeing the new field, even after I’ve attached it
to a new business view. Message in the jde.log is “JDB9900258 - Failed to
find all requested columns in table”More disturbing is that UTB doesn’t see
the new field.I’m going to promote the changes tonight and see if that clears
it up.I’m wondering if any of you have a system of adding a new field/column
to an existing table without loosing the data? Preferably using the ‘alter
table…’ SQL statement.Using an application for grid importing the data into
t!
records that are in the table…Thanks in advance,
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OWDEV&Number=70607
these messages, login to http://www.jdelist.com/forums, click Control Panel,
then click Edit by "Subscribe / Unsubscribe from receiving board posts by
email, change message notifications, etc." and adjust your subscription
preferences. JDEList is not affiliated with JDEdwards®
