Create Tables in Vantage

Yahoo Archive
1
Start up the Progress Data Dictionary (-p _dict.p). From there you have "Create Table" buttons and "Create Field" & "Create Index" buttons, just fill in the information. I believe you do need to be the only one (single user) accessing the database to create/modify tables. Look through some of the Vantage tables to see how fields and indexes are configured is the best example (you can view the tables and fields any time). One thing to keep in mind is make sure you create your table names with unique names (something Epicor won't ever use/create in new versions). My custom tables and data have migrated up with each Vantage upgrade I've done without any problems.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Jasper Recto
Sent: Tuesday, April 10, 2007 11:53 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Create Tables in Vantage



Michael,

Do you have a small example I could run with or do you know where I could find a small example of creating a new table?

Thanks,
Jasper

-----Original Message-----
From: Podlin, Michael [mailto: michael.podlin@ <mailto:michael.podlin%40v-s.com> v-s.com]
Sent: Tuesday, April 10, 2007 11:52 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Create Tables in Vantage

Yes, you need to use the Progress Data Dictionary to create your own tables and fields. You can also then have a BAM trigger a procedure to populate data in your table based upon changes to Vantage existing tables.

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]On Behalf Of Jasper Recto
Sent: Tuesday, April 10, 2007 10:41 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Create Tables in Vantage

Is it possible to create custom tables in Vantage using data from existing tables? OR Is it possible to create a custom table that gets generated when you run a report, Kind of like the way Crystal creates those tables on your hard drive to us for its reports?

Thanks,
Jasper

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
2
Is it possible to create custom tables in Vantage using data from existing tables? OR Is it possible to create a custom table that gets generated when you run a report, Kind of like the way Crystal creates those tables on your hard drive to us for its reports?

Thanks,
Jasper


[Non-text portions of this message have been removed]
3
Yes, you need to use the Progress Data Dictionary to create your own tables and fields. You can also then have a BAM trigger a procedure to populate data in your table based upon changes to Vantage existing tables.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Jasper Recto
Sent: Tuesday, April 10, 2007 10:41 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Create Tables in Vantage



Is it possible to create custom tables in Vantage using data from existing tables? OR Is it possible to create a custom table that gets generated when you run a report, Kind of like the way Crystal creates those tables on your hard drive to us for its reports?

Thanks,
Jasper

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
4
Michael,

Do you have a small example I could run with or do you know where I could find a small example of creating a new table?

Thanks,
Jasper

-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Tuesday, April 10, 2007 11:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Create Tables in Vantage



Yes, you need to use the Progress Data Dictionary to create your own tables and fields. You can also then have a BAM trigger a procedure to populate data in your table based upon changes to Vantage existing tables.


-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]On Behalf Of Jasper Recto
Sent: Tuesday, April 10, 2007 10:41 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Create Tables in Vantage

Is it possible to create custom tables in Vantage using data from existing tables? OR Is it possible to create a custom table that gets generated when you run a report, Kind of like the way Crystal creates those tables on your hard drive to us for its reports?

Thanks,
Jasper

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
5
If you are creating tables with data from existing tables, I would
recommend using sql explorer with the creat table command from a
selection string.



Example, If you wanted to create a table of customers on the west coast
:



CREATE TABLE PUB.CustWest (name, street, city, state)

AS

SELECT name, street, city, state

FROM PUB.customer

WHERE state IN ('CA','OR', 'WA') ;



Commit;







As an aside, I would create a new user schema first and create my
personal tables within it.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Tuesday, April 10, 2007 11:41 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Create Tables in Vantage



Is it possible to create custom tables in Vantage using data from
existing tables? OR Is it possible to create a custom table that gets
generated when you run a report, Kind of like the way Crystal creates
those tables on your hard drive to us for its reports?

Thanks,
Jasper

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]