Data

The tables that you create with PCC are initially empty. You can add data to them through PCC or by importing data with bulk data utility. PCC provides an export wizard to export data from a table populated with data.

Creating Data Through PCC

See To add rows of data to the Grid .

Importing Data with Bulk Data Utility

See bdu in Pervasive.SQL User's Guide.

Exporting Data

The PCC includes an export wizard to help you extract data from a Pervasive.SQL 9 SP1 (9.1) table. The Export wizard supports two different data formats, which can be read and written. The formats are shown in Table 3-5.

Table 3-5 Export Wizards Data Formats
File Format	Description
Standard Data Format	Data is represented as standard ASCII, OEM or Unicode characters. Commas separate the columns. By default, the quote character is used to enclose columns, and carriage return/line feed is used to separate records. The column separator and record separator characters are configurable.
Unformatted MicroKernel	The wizard does not convert the data to ASCII. Binary columns remain in binary format. Each record is preceded by its length in bytes and is followed by a comma delimiter. A carriage return/line feed terminates each record.

An empty string is designated in exported format by double quotes. A column defined as nullable and that contains a NULL is designated in exported format by two commas (two field separators) together.

To export data from a database table

In PCC, click Export in the Tools menu.

Complete the wizard, providing the information as directed by the wizard.