Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Sybase and Transformation Datatypes

Sybase and Transformation Datatypes

The following table compares Sybase ASE and IQ datatypes and transformation datatypes:
Sybase
Range
Transformation
Range
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Bigint
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
Precision 19, scale 0
Binary (n)
  • Sybase ASE: server logical page size
  • Sybase IQ: 1 to 255 bytes
Binary
1 to 104,857,600 bytes
Bit
0 or 1
String
1 to 104,857,600 characters
Char (n)
ASE server logical page size
String
1 to 104,857,600 characters
Date
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
Precision 10, scale 0
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Datetime
Jan 1, 1753 A.D. to Dec 31, 9999 A.D.
Precision 23, scale 3
(precision to 1/300 second)
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Decimal (P,S)
Precision 1 to 38, scale 0 to 38
Decimal
Precision 1 to 28, scale 0 to 28
Float
Machine dependent
Double
Precision 15
Image
1 to 2,147,483,647 bytes
Binary
1 to 104,857,600 bytes
Int
-2,147,483,648 to 2,147,483,647
Integer
-2,147,483,648 to 2,147,483,647
Precision 10, scale 0
Money
-922,337,203,685,477.5808 to
922,337,203,685,477.5807
Decimal
Precision 1 to 28, scale 0 to 28
Nchar (n)
ASE server logical page size
Nstring
1 to 104,857,600 characters
Numeric (P,S)
Precision 1 to 38, scale 0 to 38
Decimal
Precision 1 to 28, scale 0 to 28
Nvarchar (n)
ASE server logical page size
Nstring
1 to 104,857,600 characters
Real
Machine dependent
Real
Precision 7, scale 0
Smalldatetime
Jan 1, 1900, to June 6, 2079
Precision 19, scale 0
(precision to the minute)
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Smallint
-32,768 to 32,767
Small Integer
Precision 5, scale 0
Smallmoney
-214,748.3648 to 214,748.3647
Decimal
Precision 1 to 28, scale 0 to 28
Text
1 to 2,147,483,647 characters
Text
1 to 104,857,600 characters
Time
12:00:00AM to 11:59:59:999PM
Precision 8; scale 0
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Timestamp
8 bytes
Binary
1 to 104,857,600 bytes
Timestamp (Sybase IQ)
0001-01-01
00:00:00.000000 to 9999-12-31 23:59:59.999999
Precision 26, scale 6
Date/Time
Jan 1, 0001 A.D. to Dec 31, 9999 A.D.
(precision to the nanosecond)
Tinyint
0 to 255
Small Integer
Precision 5, scale 0
Unichar
ASE server logical page size
Nstring
1 to 104,857,600 characters
Univarchar
ASE server logical page size
Nstring
1 to 104,857,600 characters
Varbinary (n)
  • Sybase ASE: server logical page size
  • Sybase IQ: 1 to 32,767 bytes
Binary
1 to 104,857,600 bytes
Varchar (n)
ASE server logical page size
String
1 to 104,857,600 characters
The following datatypes are not supported by Sybase IQ:
  • Image
  • Nchar (n)
  • Nvarchar (n)
  • Text
  • Unichar
  • Univarchar


Updated June 25, 2018