Pervasive PSQL User Attributes

For information on the parameters in this dialog that are common to all readers, see:

For information on the parameters in this dialog that are common to all writers, see:

User attributes for this format are defined below.

Name

The name of the field to be written.

Valid values for field name include any character string devoid of SQL-offensive characters and less than 20 characters in length.

Type

The valid values for the field type are listed below:

bit

longvarchar

longvarbinary

char(width)

binary(width)

smallint

tinyint

usmallint

utinyint

smallidentity

integer

bigint

uint

ubigint

identity

real

double

currency

timestamp

date

time

decimal(width,decimal)

numeric(width,decimal)

varchar(width)

Index

The type of index to create for the column.

If the table does not previously exist, then upon table creation, a database index of the specified type is created. The database index contains only the one column.

The valid values for the column type are listed below:

  • Indexed: An index without constraints.
  • Unique: An index with a unique constraint.