Salesforce

Pervasive Data Types (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Pervasive Data Types (Magic xpa 4.x)

The following table shows the results of a Get Definition operation from a Pervasive table, and shows equivalents for Pervasive data types.

Pervasive Data Type

Attribute

Magic xpa
Storage
Type

Storage
Size

Picture

SQL_CHAR

Alpha

Zstring

n+1, 2- 256

n, 1-255

SQL_VARCHAR

Alpha

Zstring

n+1, 2- 256

n, 1-255

SQL_LONGVARCHAR

Alpha

Zstring

Default (0)

Default (0)

SQL_NCHAR

Unicode

Zunicode

n+1, 2- 256

n, 1-255

SQL_NVARCHAR

Unicode

Zunicode

n+1, 2- 256

n, 1-255

You must set the Picture for SQL_LONGVARCHAR data type columns to the appropriate size for your project, after getting the table’s definition.

SQL_BIGINT

Numeric

Signed Integer

4

10

SQL_INTEGER

Numeric

Signed Integer

4

10

SQL_SMALLINT

Numeric

Signed Integer

2

5

SQL_TINYINT

Numeric

Unsigned Integer

1

3

SQL_DOUBLE

Numeric

Float

8

According to the Float property in the DBMS Properties (default: 10.3)

SQL_FLOAT

Numeric

Float

4

5.2

SQL_REAL

Numeric

Float

4

5.2

SQL_NUMERIC

Numeric

Float

8

According to the Float property in the DBMS Properties (default: 10.3)

SQL_DECIMAL

Numeric

Float

8

According to the Float property in the DBMS Properties (default: 10.3)

SQL_DATE

Date

String Date

8

##/##/####

SQL_TIME

Time

String Time

6

##:##:##

SQL_BINARY

Alpha

Zstring

N+1, 2- 256

n, 1-255

SQL_VARBINARY

Alpha

Zstring

N+1, 2- 256

n, 1-255

SQL_LONGVARBINARY

Blob

Binary Large Object

Default (12)

SQL_BIT

Logical

Integer Logical

1

5

TIMESTAMP

Date

String Date

8

##/##/####

The storage size is calculated according to the database of the table – according to the gateway's storage table. The storage size is recalculated on import.

Reference
Attachment 
Attachment