I'm not sure why this is, but a lot of people don't know that with the E1 Object Management Workbench (OMW) they can create new tables and make copies of existing tables then generate them in any data source. With OMW you can also copy a table and its data from one data source to another. For existing tables you can regenerate them (which removes all data) and also recreate all the indexes.
This first blog on OMW table operations will show you how to copy the structure of a table. You might need a copy of table to use as a work table or part of a custom project. To keep things short, I have to assume you already know the basics of using OMW including how to create projects and add users to a project.
Copy table structure
Go in to OMW and move a table into your project. In this example we'll use the F0010. Using the search screen, find the F0010 and add it to your project.
If you just want a copy of the table structure, all you have to do now is highlight the table in your project and click the Copy button at the top. You'll now see the Copy Object screen. Remember - you're not copying data, only the table structure.
In accordance with best practices, I have named my new table F550010W and changed the description. I've also set the product and product system codes to 55. The rest is fine to leave as-is. Click OK when you are satisfied.
You're now returned to the Table Design screen. In there click the Table Operations tab. There's a lot of buttons in there, but for now we're only concerned with the Generate Table button.
Clicking the Generate Table button takes you to the Generate Table window. Here you can select the data source and the object owner password.
Since I have created a new table name I will leave the data source alone. I won't modify the password because OMW will automatically fill in the correct one if you haven't changed the defaults. Click the OK button when you're ready to create the table.
Success! Your table has been created in the Business Data - Test data source. Click all the OK buttons you can until you are back at the main OMW window. When you find your project again the new table will be listed.
You don't need to check it in or build a package to start using the table for a few things. You can open the table in UTB and even go directly to the database and work on it there if you wish. Check in the table when you want to promote and build it or simply to make the specs available to other developers,
In part two I'll tell you how to delete that table (HINT: Click the delete button) and I'll demonstrate how to copy a table and all of its data to a new location.
This first blog on OMW table operations will show you how to copy the structure of a table. You might need a copy of table to use as a work table or part of a custom project. To keep things short, I have to assume you already know the basics of using OMW including how to create projects and add users to a project.
Copy table structure
Go in to OMW and move a table into your project. In this example we'll use the F0010. Using the search screen, find the F0010 and add it to your project.
 |
| Finding an object in OMW |
 |
| The F0010 in your project |
If you just want a copy of the table structure, all you have to do now is highlight the table in your project and click the Copy button at the top. You'll now see the Copy Object screen. Remember - you're not copying data, only the table structure.
In accordance with best practices, I have named my new table F550010W and changed the description. I've also set the product and product system codes to 55. The rest is fine to leave as-is. Click OK when you are satisfied.
You're now returned to the Table Design screen. In there click the Table Operations tab. There's a lot of buttons in there, but for now we're only concerned with the Generate Table button.
Clicking the Generate Table button takes you to the Generate Table window. Here you can select the data source and the object owner password.
Since I have created a new table name I will leave the data source alone. I won't modify the password because OMW will automatically fill in the correct one if you haven't changed the defaults. Click the OK button when you're ready to create the table.
Success! Your table has been created in the Business Data - Test data source. Click all the OK buttons you can until you are back at the main OMW window. When you find your project again the new table will be listed.
You don't need to check it in or build a package to start using the table for a few things. You can open the table in UTB and even go directly to the database and work on it there if you wish. Check in the table when you want to promote and build it or simply to make the specs available to other developers,
In part two I'll tell you how to delete that table (HINT: Click the delete button) and I'll demonstrate how to copy a table and all of its data to a new location.
