BUILD tablename[remotehost, remotedbpass, remoteport, verb]

The syntax above recreates a piece of the source database on a remote server based on the verb parameter.

  • tablename: The table name with full path on source database.
  • remotehost: Computer name or IP address of the external database.
  • remotedbpass: Password of the external database.
  • remoteport: Data port of the external database.
  • verb: Can be the following:
    • TABLE: The selected table and it's data content on the source database.
    • PATH: An entire path from the root to the selected table including all tables with entire data content between the route.
    • RELPATH: The selected table with all living assignments including the entire data content. No data content will be replicated between the selected table and the root, only the table structure itself.
    • BRANCH: PATH with RELPATH.



BUILD ROOT[remotehost, remotedbpass, remoteport]

The syntax above recreates the local database on a remote server.

  • remotehost: Computer name or IP address of the external database.
  • remotedbpass: Password of the external database.
  • remoteport: Data port of the external database.



BUILD FILES[remotehost, remotedbpass, remotedataport:remotefileport]

The syntax above sends all the files to a remote server.

  • remotehost: Computer name or IP address of the external database.
  • remotedbpass: Password of the external database.
  • remotedataport: Data port of the external database.
  • remotefileport: File port of the external database.



BUILD SHOW

The syntax above shows building states.

Only works in Catalog Manager!

Practical example

Command:

BUILD SHOW

Output:

BUILD SHOW
{
0^test-server^10202^2376^168^TABLE01.TABLE10.TABLE20^TABLE01&cr;&lf;TABLE01.TABLE10&cr;&lf;TABLE01.TABLE10.TABLE20
1^test-server^10202^2376^168^TABLE02^TABLE01&cr;&lf;TABLE02&cr;&lf;TABLE02.TABLE20
}

The output returns a process list based on build tasks. Each row represents a task. “^” behaves like a separator therefore each row contains seven parameters:

  1. Process ID or Index
  2. Remote host
  3. Remote data port or file port
  4. Total items coated to processing
  5. Processed items
  6. Last processed table's name
  7. Build list containing table's names coated to processing




BUILD SHOW[]-

The syntax above shows building states without build list.

Only works in Catalog Manager!

Practical example

Command:

BUILD SHOW[]-

Output:

BUILD SHOW[]-
{
0^test-server^10202^2376^168^TABLE01.TABLE10.TABLE20
1^test-server^10202^2376^168^TABLE02
}

The output returns a process list based on build tasks. Mainly the same as the keyword above, however the output only contains six parameters respectively.


BUILD SHOW[index]

The syntax above shows a building state based on the process ID/Index.

  • index: Building process's index.

Only works in Catalog Manager!

Practical example

Command:

BUILD SHOW[1]

Output:

BUILD SHOW[1]
{
1^test-server^10202^2376^168^TABLE02^TABLE01&cr;&lf;TABLE02&cr;&lf;TABLE02.TABLE20
}

The output returns a process state based on build-task index. Mainly the same as the BUILD SHOW keyword, however the output only contains the specified task's parameters.


BUILD SHOW[index]-

The syntax above shows a building state based on the process ID/Index without build list.

  • index: Building process's index.

Only works in Catalog Manager!

Practical example

Command:

BUILD SHOW[1]-

Output:

BUILD SHOW[1]-
{
1^test-server^10202^2376^168^TABLE02
}

The output returns a process state based on build-task index. Mainly the same as the BUILD SHOW[]- keyword, however the output only contains the specified task's parameters.