4GL with Progress 9.1 - Delete all table contents

Yahoo Archive
1
Ned, do you need the 8.03.400 D&L? I can email it to you. Email me
directly.



Otherwise, it's not difficult coming up with a "DELETE FROM xxxxx" script
listing every table. Query the zDataTable table for a list of tables and
concatenate a string together within the query's results to give you a
DELETE FROM for every table.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ned
Sent: Thursday, July 25, 2013 5:01 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 4GL with Progress 9.1 - Delete all table contents





I know it does for 8.03, but I only have the ASCII D&L Kit for version 6.1
on Progress 9.1.

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Calvin Dekker
Sent: Thursday, July 25, 2013 4:35 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] 4GL with Progress 9.1 - Delete all table contents

Ned -

I believe if you follow the instructions in the binary dump & load, the
instructions have you create a blank database from the current database
structure.

HTH,
Calvin Dekker
Office: 630-672-7688 Ext. 1484
Email: calvin@... <mailto:calvin%40codabears.com>
<mailto:calvin@... <mailto:calvin%40codabears.com> >
http://www.codabears.com<http://www.codabears.com/>
[cid:image001.jpg@01CE894C.8A3C98F0
<mailto:image001.jpg%4001CE894C.8A3C98F0> ]<http://www.codabears.com/>

Solutions for Epiday living.

"No trees were harmed during the sending of this message, however a large
number of electrons were terribly inconvenienced."

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Ned
Sent: Thursday, July 25, 2013 3:25 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] 4GL with Progress 9.1 - Delete all table contents

So, does anyone have any good ways to completely blank a database in
Progress 9.1?

I am working on a project to do a dump and load, but I can't use the
standard empty database because the customer has some custom tables, fields,
and indexes, and if I manually recreate them then there ends up being a CRC
mismatch with the program.

I know I can manually write out a script to clear the contents of each table
individually, but if I can save my own time, and save them some money if
someone has already done something like this?

I will probably be using either the truncate or the delete command, I am
just not sure if there is an easier way to do all tables versus wiring them
all out one by one in a script.

I would look to Epicor, but there is no maintenance contract anymore, so
it's not an option to work with them.

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

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
2
So, does anyone have any good ways to completely blank a database in
Progress 9.1?

I am working on a project to do a dump and load, but I can't use the
standard empty database because the customer has some custom tables, fields,
and indexes, and if I manually recreate them then there ends up being a CRC
mismatch with the program.

I know I can manually write out a script to clear the contents of each table
individually, but if I can save my own time, and save them some money if
someone has already done something like this?

I will probably be using either the truncate or the delete command, I am
just not sure if there is an easier way to do all tables versus wiring them
all out one by one in a script.

I would look to Epicor, but there is no maintenance contract anymore, so
it's not an option to work with them.
3
Ned -

I believe if you follow the instructions in the binary dump & load, the instructions have you create a blank database from the current database structure.

HTH,
Calvin Dekker
Office: 630-672-7688 Ext. 1484
Email: calvin@...<mailto:calvin@...>
http://www.codabears.com<http://www.codabears.com/>
[cid:image001.jpg@01CE894C.8A3C98F0]<http://www.codabears.com/>

Solutions for Epiday living.

"No trees were harmed during the sending of this message, however a large number of electrons were terribly inconvenienced."

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ned
Sent: Thursday, July 25, 2013 3:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 4GL with Progress 9.1 - Delete all table contents



So, does anyone have any good ways to completely blank a database in
Progress 9.1?

I am working on a project to do a dump and load, but I can't use the
standard empty database because the customer has some custom tables, fields,
and indexes, and if I manually recreate them then there ends up being a CRC
mismatch with the program.

I know I can manually write out a script to clear the contents of each table
individually, but if I can save my own time, and save them some money if
someone has already done something like this?

I will probably be using either the truncate or the delete command, I am
just not sure if there is an easier way to do all tables versus wiring them
all out one by one in a script.

I would look to Epicor, but there is no maintenance contract anymore, so
it's not an option to work with them.



[Non-text portions of this message have been removed]
4
I know it does for 8.03, but I only have the ASCII D&L Kit for version 6.1
on Progress 9.1.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Calvin Dekker
Sent: Thursday, July 25, 2013 4:35 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 4GL with Progress 9.1 - Delete all table contents

Ned -

I believe if you follow the instructions in the binary dump & load, the
instructions have you create a blank database from the current database
structure.

HTH,
Calvin Dekker
Office: 630-672-7688 Ext. 1484
Email: calvin@...<mailto:calvin@...>
http://www.codabears.com<http://www.codabears.com/>
[cid:image001.jpg@01CE894C.8A3C98F0]<http://www.codabears.com/>

Solutions for Epiday living.

"No trees were harmed during the sending of this message, however a large
number of electrons were terribly inconvenienced."

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ned
Sent: Thursday, July 25, 2013 3:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 4GL with Progress 9.1 - Delete all table contents



So, does anyone have any good ways to completely blank a database in
Progress 9.1?

I am working on a project to do a dump and load, but I can't use the
standard empty database because the customer has some custom tables, fields,
and indexes, and if I manually recreate them then there ends up being a CRC
mismatch with the program.

I know I can manually write out a script to clear the contents of each table
individually, but if I can save my own time, and save them some money if
someone has already done something like this?

I will probably be using either the truncate or the delete command, I am
just not sure if there is an easier way to do all tables versus wiring them
all out one by one in a script.

I would look to Epicor, but there is no maintenance contract anymore, so
it's not an option to work with them.



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



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links