Custom Table Generation

[Jeremy M.]

I have a simple question here...

If I have a custom table in a OMW project, does the promotion to PY and package build/deploy process at all generate the table in PY? It was my understanding that new tables have to be manually generated. The project promotion will copy the header files but not generate the table. Is that correct?

 

[llallen1113]

Whether a new or updated table, the package build/deploy process does not perform a generation. This is done manually after a build using the table design toolset in OMW. Anytime a table change is made or new index is added, a table should be regenerated and/or re-indexed using the toolset. Just be careful with existing tables with data, the generation drops and recreates the table on the database, wiping out any data.

 

[Jeremy M.]

Thanks, that is what I thought.

 

[Lennon2]

Hi, when creating the table and generating, is the table and index created at the same time during generation?
Or is it necessary to "create table" first and "create index" afterwards in P9860A

 

[MFreitag]

Hi, when creating the table and generating, is the table and index created at the same time during generation?

Option #1 it is.

 

[DaveWagoner]

I've always superstitiously clicked gen table and then gen index

I've never claimed to be NOT superstitious about how I make JDE work for me

 

[MFreitag]

Doesn't hurt to just press Generate Table and take a look at your database and see what happened - IF you have database access, that is.

 

[Neal Scarr]

Generate Table creates the table (if new) or clears the table (if it already exists) and generates all the indexes. Generate Indexes doesn't create or clear the table, it just regenerates all the indexes. That's why they are separate operations in OMW.

 

[alfredorz]

And if you want to generate a specific index, you can use P95150 - Index Selection Tool application in your fat client.