Simplicty and flexibility!


Command::

reorganize


Parameters


Returns/Result


Examples


Reference

reorganize

Type

Control Command

Purpose

The reorganize command reorganizes the specified table by updating the table's indices and physically erasing deleted records from disk.

The reorganize command functions like selecting Application>>Utilities>>Reorganize.

Syntax

reorganize "TABLENAME" [UNCLUSTERED|CLUSTERBY FIELD1 [ ; FIELD2...]] .

Usage

The reorganize command, used by itself, reorganizes the specified table as described above. If the table contains a clustered index, the records are reorganized according to the table-defined cluster order.

The tablename must be enclosed in quotes.

When a table is reorganized, all records that have been deleted since the last reorganization are permanently erased and all indices used to organize the data in the table are recreated.

If the table has become inconsistent (signaled by an error message), the reorganize command reorganizes the records in the table and returns the table to a consistent status.

The reorganize unclustered command overrides any table-defined cluster order. DataEase reorganizes the table in unclustered order. Any records entered since the table was last reorganized are left in the order they were entered.

The reorganize cluster by command lets you override the table-defined cluster order. The table is reorganized in order according to the field name(s) you specify. DataEase prohibits you from including any fields specified in the table-defined cluster order.

LAN

On a LAN (Local Area Network), if another user is currently using any resource required by the reorganize command, DataEase displays a Resource Conflict message. While this message is displayed, DataEase automatically tries to execute the command at brief intervals.

When the required resource becomes available, DataEase automatically resumes processing and executes the rest of the procedure.

Example 1

reorganize "MEMBERS" .

run report "PRINT INVOICES" .

 

This script tells DataEase: (1) Reorganize the MEMBERS table, and (2) when the reorganization is completed, run the PRINT INVOICES procedure.

Example 2

reorganize "DEPARTURE ZONES" cluster by DEPARTURE ZONE .

 

This script tells DataEase to reorganize the DEPARTURE ZONES table. Cluster the data in order by the DEPARTURE ZONE field.

See Also


On the forum about reorganize

Reorganize documents & DQL

There's a way to reorganize all the documents of a database in version 8 ?I only find the possibility to reorganize all the tables but not ALL the documents. I need to check and save all the DQL in My database....

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 06/03/14 at 15:40:31

Re:Reorganize documents

Reorganzation is a Data feature and what is does is simply to compact the DBM files by removing deleted records. It also check the number of records in the DBM and update the RDRR file with the correct number of records.When one get the error...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 10/03/14 at 09:38:12

Re:Re:Reorganize documents

The problem is due to a migration form 6.52 version. The reorganization of the documents is the last step of the DEMigrate program. I mean , when I migrate the database, not all the steps are performed due to an error (I have not be able to solve it...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 11/03/14 at 15:15:10

How to reorganize all tables from a DQL.

I perform every month a massive load of data into the DB and It’s very important to reorganize all the tables before starting the loading procedures.(There’s a way to reorganize all tables via DQL in a single command? – I would like to start t...

Product: Dataease [{8}]FIVE. Written by Marco 07/05/14 at 11:05:02

Re:How to reorganize all tables from a DQL.

The possibilities in DE8 is vast compared to earlier versions, but a lot of it is still to be unlocked for existing users….I guess I can start the unlocking a little here: The following script would reorganize all the tables in your da...

Product: Dataease [{8}]FIVE. Written by DataEase 07/05/14 at 11:06:56

GPF on reorganize

We tried to delete all the records in a table using "delete records in &lt;table&gt;" but DE leave the table in "inconsistent mode". <img data-mozilla-paste-image="0" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAZ0AAACUCAIAAADHxWOJAAAN0E...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 18/06/14 at 12:50:13

4.53 LegEasy 4DOS: reorganize issues: won't reorganize any form and can't save new data

I try to reogranize a form but it does not take.&nbsp; I don't know if after 30 years I have too much data.&nbsp; I was just trying to create new forms with relationships that was a little data intense and it reacted like this.&nbsp; My data is still...

Product: LegEasy 4DOS. Written by JimmyB 16/01/22 at 17:01:09

Re:4.53 LegEasy 4DOS: reorganize issues: won't reorganize any form and can't save new data

HI Jimmy.What you can try first is to run the reorganization from a control procedure rather than from the menu.You should anyhow take a full backup/copy of the application before you try to fix it.If that doesn't work, take a...

Product: LegEasy 4DOS. Written by DataEase 18/01/22 at 09:56:11

Reorganize - Cluster Records

when should you use Cluster Records? I have never wondered about this since i encountered DataEase 100 yrs ago...

Product: Dataease [{8}]FIVE. Written by BLESSED SHUMBA 14/02/24 at 05:30:45

Re:Reorganize - Cluster Records

100 ? we had used DataEase clay tablets in Babylon already.&nbsp;&nbsp;"UNSW Sydney scientists have discovered the purpose of a famous 3700-year old Babylonian cl...

Product: Dataease 9 Developer. Written by Ihor Zakharchenko 16/02/24 at 09:26:53

Re:Reorganize - Cluster Records

Clustered records is in many ways a very "old fashioned" way of looking at tables and should in many way "never" be used.Instead of using an index to find and sort data, the data is re-sorted in "index" order so when listed out sequentially th...

Product: Dataease [{8}]FIVE. Written by DataEase 19/02/24 at 10:52:01

Re:Re:Reorganize - Cluster Records

Thank you for that reply, nothing is better than to know the complete truth to one's curiosity...

Product: Dataease [{8}]FIVE. Written by BLESSED SHUMBA 19/02/24 at 13:29:50

Re:Re:Re:Reorganize - Cluster Records

in fact, all end users prefer non abstract databases, but tuned datasets related to a certain data management task. so did guys from&nbsp;Software Development Laboratories, in 1985, under their&nbsp; new name Oracle ;) really in our life we are not so...

Product: Dataease [{8}]FIVE. Written by Ihor Zakharchenko 20/02/24 at 12:47:48

Re:Re:Re:Re:Reorganize - Cluster Records

Users don't care how data is stored but how it is presented.A clustered database store the data in the order its sorted which in reality is very impractical if the data isn't static.&nbsp;So back in the day when you for instance put th...

Product: Dataease [{8}]FIVE. Written by DataEase 20/02/24 at 13:29:38

Re:Re:Re:Re:Re:Reorganize - Cluster Records

yup! but as abstract algebraist from math department of my uni I consider other abstraction levels as those ancient clusterisation ;) and if this my level of understanding can be never achieved by finite automata like computer progs then it is better...

Product: Dataease [{8}]FIVE. Written by Ihor Zakharchenko 20/02/24 at 13:55:05

Re:Re:Re:Reorganize - Cluster Records

it was in 199* we used DE 4.53 SQL with option to choose between Native or Oracle type of db. that was sales system for a huge cardboard paper mill near Kyiv based on Novell netware, Oracle and DataEase. this true story became a legend now ... but clu...

Product: DataEase Infrastructure License (DIS). Written by Ihor Zakharchenko 21/02/24 at 11:24:39

Re:Re:Re:Re:Reorganize - Cluster Records

DQL from 1981 is real AI nowso DataEase AI =DFD...

Product: DataEase Infrastructure License (DIS). Written by Ihor Zakharchenko 15/03/24 at 10:39:25

On the blog about reorganize


dg3_HelpView