Creating a non-partitioned table

Note Check the solidDB Release Notes for any limitations that are associated with using a grid in the current release.

A non-partitioned (shared) table is the same type of table that you create on a standard solidDB server.

Complete the following steps to create a non-partitioned table on a grid.

1 Connect to one of the nodes in the grid by using a grid connection. For example:

solsql "grid tcp myhost1 1964" dba dba

For more information, see Connecting to a grid.

2 Run the CREATE TABLE statement in the same way as for a standard solidDB server. For example:

CREATE TABLE GRID_NON_PARTITIONED(
  I INTEGER NOT NULL PRIMARY KEY,
  J INTEGER NOT NULL,
  C VARCHAR);

For the complete syntax, see CREATE TABLE.

You can now add data to the table by using a grid connection from your application or the solidDB solloado utility, see solidDB Speed Loader (solloado and solload).

Go up to