Product Documentation
Abstract
Below are the supported datatypes for Cognos Series 7 Version 5.
Content
DB2 UDB | DB2/400 V5R2 | DB2/MVS 7.1 | Informix | ODBC 2.5 | Oracle
SQL Server ODBC | SQL Server OLE-DB | Sybase ASE via CT-LIB
| Database | Vendor Datatype | Architect | Cognos Query | Impromptu and IWR | PowerPlay Transformer |
| DB2 UDB | BIGINT | Yes | Yes | Yes | Yes |
| DB2 UDB | BLOB | Yes | Yes | No | No |
| DB2 UDB | CHAR | Yes | Yes | Yes | Yes |
| DB2 UDB | CHAR FOR BIT DATA | Yes | Yes | No | No |
| DB2 UDB | CLOB | Yes | Yes | Yes | No |
| DB2 UDB | DATALINK | Yes | Yes | No | No |
| DB2 UDB | DATE | Yes | Yes | Yes | Yes |
| DB2 UDB | DBCLOB | Yes | Yes | No | No |
| DB2 UDB | DECIMAL | Yes | Yes | Yes | Yes |
| DB2 UDB | DOUBLE | Yes | Yes | Yes | Yes |
| DB2 UDB | FLOAT | Yes | Yes | Yes | Yes |
| DB2 UDB | GRAPHIC | No | No | No | No |
| DB2 UDB | INTEGER | Yes | Yes | Yes | Yes |
| DB2 UDB | LONG VARCHAR | Yes | Yes | Yes | No |
| DB2 UDB | LONG VARCHAR FOR BIT DATA | Yes | Yes | No | No |
| DB2 UDB | NUMERIC | Yes | Yes | Yes | Yes |
| DB2 UDB | REAL | Yes | Yes | Yes | Yes |
| DB2 UDB | SMALLINT | Yes | Yes | Yes | Yes |
| DB2 UDB | TIME | Yes | Yes | Yes | Yes |
| DB2 UDB | TIMESTAMP | Yes | Yes | Yes | Yes |
| DB2 UDB | VARCHAR | Yes | Yes | Yes | Yes |
| DB2 UDB | VARCHAR FOR BIT DATA | Yes | Yes | No | No |
| DB2 UDB | VARGRAPHIC | No | No | No | No |
| Database | Vendor Datatype | Architect | Cognos Query | Impromptu and IWR | PowerPlay Transformer |
| DB2/400 | other datatypes same as DB2 UDB | Yes | Yes | Yes | Yes |
| DB2/400 | ROWID | Yes | Yes | No | No |
| Database | Vendor Datatype | Architect | Cognos Query | Impromptu and IWR | PowerPlay Transformer |
| DB2/MVS | BIGINT | No | No | No | No |
| DB2/MVS | DATALINK | No | No | No | No |
| DB2/MVS | other datatypes same as DB2 UDB | Yes | Yes | Yes | Yes |
| DB2/MVS | ROWID | Yes | Yes | No | No |
| Database | Vendor Datatype | Architect | Cognos Query | Impromptu and IWR | PowerPlay Transformer |
| Informix | BYTE | Yes | Yes | No | No |
| Informix | CHAR(n) | Yes | Yes | Yes | Yes |
| Informix | DATETIME | Yes | Yes | Yes | Yes |
| Informix | DECIMAL(p) | Yes | Yes | Yes | Yes |
| Informix | DECIMAL(p,s) | Yes | Yes | Yes | Yes |
| Informix | FLOAT | Yes | Yes | Yes | Yes |
| Informix | INT8 | Yes | Yes | Yes | Yes |
| Informix | INTEGER | Yes | Yes | Yes | Yes |
| Informix | INTERVAL | Yes | Yes | No | No |
| Informix | MONEY | Yes | Yes | Yes | Yes |
| Informix | NCHAR(n) | No | No | No | No |
| Informix | NVARCHAR(m<,r>) | No | No | No | No |
| Informix | REAL | Yes | Yes | Yes | Yes |
| Informix | SERIAL | Yes | Yes | Yes | Yes |
| Informix | SERIAL8 | Yes | Yes | Yes | Yes |
| Informix | SMALLFLOAT | Yes | Yes | Yes | Yes |
| Informix | SMALLINT | Yes | Yes | Yes | Yes |
| Informix | TEXT | Yes | Yes | Yes | No |
| Informix | VARCHAR(m<,r>) | Yes | Yes | Yes | Yes |
| Database | Vendor Datatype | Architect | Cognos Query | Impromptu and IWR | PowerPlay Transformer |
| ODBC 2.5 | SQL_BIGINT | Yes | Yes | Yes | Yes |
| ODBC 2.5 | SQL_BINARY | Yes | Yes | No | No |
| ODBC 2.5 | SQL_BIT | Yes | Yes | Yes | Yes |
| ODBC 2.5 | SQL_CHAR | Yes | Yes | Yes | Yes |
| ODBC 2.5 | SQL_DATE | Yes | Yes | Yes | Yes |
| ODBC 2.5 | SQL_DECIMAL | Yes | Yes | Yes | Yes (1) |
| ODBC 2.5 | SQL_DOUBLE | Yes | Yes | Yes | Yes |
| ODBC 2.5 | SQL_FLOAT | Yes | Yes | Yes | Yes |
| ODBC 2.5 | SQL_INTEGER | Yes | Yes | Yes | Yes |
| ODBC 2.5 | SQL_LONGVARBINARY | Yes | Yes | No | No |
| ODBC 2.5 | SQL_LONGVARCHAR | Yes | Yes | Yes | No |
| ODBC 2.5 | SQL_NUMERIC | Yes | Yes | Yes | Yes |
| ODBC 2.5 | SQL_REAL | Yes | Yes | Yes | Yes |
| ODBC 2.5 | SQL_SMALLINT | Yes | Yes | Yes | Yes |
| ODBC 2.5 | SQL_TIME | Yes | Yes | Yes | Yes |
| ODBC 2.5 | SQL_TIMESTAMP | Yes | Yes | Yes | Yes |
| ODBC 2.5 | SQL_TINYINT | Yes | Yes | Yes | Yes |
| ODBC 2.5 | SQL_VARBINARY | Yes | Yes | No | No |
| ODBC 2.5 | SQL_VARCHAR | Yes | Yes | Yes | Yes |
| Database | Vendor Datatype | Architect | Cognos Query | Impromptu and IWR | PowerPlay Transformer |
| Oracle | bfile | No | No | No | No |
| Oracle | blob | No | No | No | No |
| Oracle | char(n) | Yes | Yes | Yes | Yes |
| Oracle | clob | Yes | Yes | Yes | No |
| Oracle | date | Yes | Yes | Yes | Yes |
| Oracle | interval day to second | Yes | Yes | Yes | Yes |
| Oracle | interval year to month | Yes | Yes | Yes | Yes |
| Oracle | long | Yes | Yes | Yes | No |
| Oracle | long raw | No | No | No | No |
| Oracle | nchar *new in S7V2 MR2* | Yes | Yes | Yes | Yes |
| Oracle | number | Yes | Yes | Yes | Yes |
| Oracle | number(p,s) | Yes | Yes | Yes | Yes |
| Oracle | numeric(p,s) | Yes | Yes | Yes | Yes |
| Oracle | nvarchar *new in S7V2 MR2* | Yes | Yes | Yes | Yes |
| Oracle | raw(n) | Yes | Yes | No | No |
| Oracle | timestamp | Yes | Yes | Yes | Yes |
| Oracle | timestamp with local timezone | No | No | No | No |
| Oracle | timestamp with timezone | Yes | Yes | Yes | Yes |
| Oracle | varchar(n) | Yes | Yes | Yes | Yes |
| Oracle | varchar2(n) | Yes | Yes | Yes | Yes |
| Database | Vendor Datatype | Architect | Cognos Query | Impromptu and IWR | PowerPlay Transformer |
| SQL Server ODBC | binary(n) | Yes | Yes | No | No |
| SQL Server ODBC | bit | Yes | Yes | Yes | Yes |
| SQL Server ODBC | char(n) | Yes | Yes | Yes | Yes |
| SQL Server ODBC | datetime | Yes | Yes | Yes | Yes |
| SQL Server ODBC | decimal(p,s) | Yes | Yes | Yes | Yes |
| SQL Server ODBC | float | Yes | Yes | Yes | Yes |
| SQL Server ODBC | identity decimal | Yes | Yes | Yes | Yes |
| SQL Server ODBC | identity int | Yes | Yes | Yes | Yes |
| SQL Server ODBC | identity numeric | Yes | Yes | Yes | Yes |
| SQL Server ODBC | identity smallint | Yes | Yes | Yes | Yes |
| SQL Server ODBC | identity tinyint | Yes | Yes | Yes | Yes |
| SQL Server ODBC | image | Yes | Yes | No | No |
| SQL Server ODBC | int | Yes | Yes | Yes | Yes |
| SQL Server ODBC | money | Yes | Yes | Yes | Yes |
| SQL Server ODBC | numeric(p,s) | Yes | Yes | Yes | Yes |
| SQL Server ODBC | real | Yes | Yes | Yes | Yes |
| SQL Server ODBC | smalldatetime | Yes | Yes | Yes | Yes |
| SQL Server ODBC | smallint | Yes | Yes | Yes | Yes |
| SQL Server ODBC | smallmoney | Yes | Yes | Yes | Yes |
| SQL Server ODBC | text | Yes | Yes | Yes | No |
| SQL Server ODBC | timestamp | Yes | Yes | No | No |
| SQL Server ODBC | tinyint | Yes | Yes | Yes | Yes |
| SQL Server ODBC | varbinary(n) | Yes | Yes | No | No |
| SQL Server ODBC | varchar(n) | Yes | Yes | Yes | Yes |
| Database | Vendor Datatype | Architect | Cognos Query | Impromptu and IWR | PowerPlay Transformer |
| SQL Server OLE-DB | binary(n) | Yes | Yes | No | No |
| SQL Server OLE-DB | bit | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | char(n) | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | cursor | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | datetime | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | decimal(p,s) | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | float | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | identity decimal | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | identity int | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | identity numeric | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | identity smallint | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | identity tinyint | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | Image | Yes | Yes | No | No |
| SQL Server OLE-DB | int | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | money | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | nchar(n) | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | ntext | Yes | Yes | No | No |
| SQL Server OLE-DB | numeric(p,s) | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | nvarchar(n) | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | real | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | smalldatetime | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | smallint | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | smallmoney | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | sql_variant | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | table | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | text | Yes | Yes | Yes | No |
| SQL Server OLE-DB | timestamp | Yes | Yes | No | No |
| SQL Server OLE-DB | tinyint | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | uniqueidentifier | Yes | Yes | No | No |
| SQL Server OLE-DB | varbinary(n) | Yes | Yes | Yes | Yes |
| SQL Server OLE-DB | varchar(n) | Yes | Yes | Yes | Yes |
| Database | Vendor Datatype | Architect | Cognos Query | Impromptu and IWR | PowerPlay Transformer |
| Sybase ASE via CT-LIB | binary(n) | Yes | Yes | No | No |
| Sybase ASE via CT-LIB | bit | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | char(n) | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | datetime | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | decimal(p,s) | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | double precision | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | float | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | float(n), n<16 | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | float(n), n>=16 | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | identity column | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | Image | Yes | Yes | No | No |
| Sybase ASE via CT-LIB | int | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | money | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | nchar(n) | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | numeric(p,s) | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | nvarchar(n) | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | real | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | smalldatetime | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | smallint | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | smallmoney | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | text | Yes | Yes | Yes | No |
| Sybase ASE via CT-LIB | timestamp | Yes | Yes | No | No |
| Sybase ASE via CT-LIB | tinyint | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | univarchar *new in S7V2 MR2* | Yes | Yes | Yes | Yes |
| Sybase ASE via CT-LIB | varbinary(n) | Yes | Yes | No | No |
| Sybase ASE via CT-LIB | varchar(n) | Yes | Yes | Yes | Yes |
Footnotes
(1)Precision limit of 18.
[{"Product":{"code":"SSTQPQ","label":"IBM Cognos Series 7 PowerPlay"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"7.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27020472