Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS forUNIX SQL Reference - NCR

NCR Teradata RDBMS forUNIX SQL Reference - NCR, 1997. - 913 p.
Download (direct link): teradataforunix1997.pdf
Previous << 1 .. 199 200 201 202 203 204 < 205 > 206 207 208 209 210 211 .. 241 >> Next


Data type translations are necessary. For example the DB2 TIME data type translates to INTEGER FORMAT ‘99:99:99’, and DB2 TIMESTAMP translates to ‘CHAR(26)’.

ALTER TABLSPACE

CALL

TABLESPACE object is not supported in Teradata SQL.

Calls a stored procedure. Supported as Macros and EXECUTE in Teradata SQL.

COMMENT ON

In DB2, COMMENT ON adds or replaces comments in the descriptions of tables, views, or columns in the DB2 catalog at the current server. COMMENT ON TABLE, VIEW, or single COLUMN is the same as the Teradata SQL syntax. COMMENT ON COLUMN, where there are more than one columns is translated via TS/API, to one or more Teradata SQL statements.

CREATE ALIAS

CREATE INDEX

There is no equivalent syntax in Teradata SQL.

CREATE INDEX statement in Teradata SQL creates a new secondary index on an existing table. In DB2 CREATE INDEX creates a partitioned or non-partitioned index and an index space at

C-16

Teradata RDBMS for UNIX SQL Reference
CREATE STOGROUP

CREATE SYNONYM

CREATE TABLE

DATE and TIME Functions

DROP DATABASE

DROP SYNONYM

DROP STOGROUP

DROP TABLESPACE

EXPLAIN

FIELDPROC, EDITPROC, and VALIDPROC

GRANT

Comparing Teradata SQL and DB2

DB2 Extensions Not Supported in Teradata SQL

the current server. VSAM-related options and the descending order option are not available in Teradata SQL.

The STOGROUP object of DB2 is not supported in Teradata SQL

DB2 supports a CREATE SYNONYM statement; Teradata SQL does not. (TS/API maps this to the Teradata RDBMS CREATE VIEW statement).

Teradata RDBMS has no physical or logical equivalent to the DB2 DATABASE or TABLESPACE. The Teradata RDBMS user id (DATABASE) is equivalent to the DB2 authorization id.

These functions are not currently supported in Teradata SQL.

Similar syntax to teradata SQL, however Teradata SQL’s DATABASE is analogous to DB2’s authorization id.

Teradata SQL does not support DROP SYNONYM. TS/API translates this to DROP VIEW.

This is not supported by Teradata SQL.

TABLESPACE is not supported by Teradata SQL.

DB2’s EXPLAIN command obtains access path selection information about an explainable statement. A statement is explainable if it is a SELECT or INSERT statement, or the searched form of an UPDATE or DELETE statement. Information obtained is placed in a user-supplied plan table. Teradata SQL’s EXPLAIN ‘modifier’ returns a summary of the steps Teradata RDBMS would perform to resolve a request. Teradata SQL does not support DB2’s EXPLAIN.

These options in DB2 are not currently supported in Teradata SQL.

Differences between the GRANT database privileges commands in DB2 and Teradata SQL are summarized in Table C-1“GRANT Database Privileges: Differences in DB2 and Teradata SQL” Refer to the latest edition of the Transparency Series/Application Program Interface (TS/API) User’s Guide for differences in the following DB2:

Teradata RDBMS for UNIX SQL Reference

C-17
Comparing Teradata SQL and DB2

DB2 Extensions Not Supported in Teradata SQL

• GRANT ‘plan’ privileges,

• GRANT system privileges,

• GRANT table privileges, and

• GRANT use privileges

and the equivalent commands in Teradata SQL.

Table C-1 GRANT Database Privileges: Differences in DB2 and Teradata SQL

Using GRANT in DB2 Using GRANT in Teradata SQL
GRANT DBADM GRANT ALL
GRANT DBCTRL GRANT DATABASE, MACRO, TABLE, USER, or VIEW
GRANT DBMAINT GRANT SELECT
GRANT CREATETAB GRANT CREATE TABLE CREATE VIEW
GRANT CREATETS Not supported
GRANT DISPLAYDB Not Supported
DROP DROP DATABASE
GRANT IMAGCOPY Not Supported
GRANT LOAD RESTORE DUMP
GRANT RECOVERDB Not supported
GRANT REORG Not supported
GRANT REPAIR Not supported
GRANT STARTDB Not supported
GRANT STATS CHECKPOINT
GRANT STOPDB Not supported

INSERT, LOCK TABLE, REVOKE, SELECT, UPDATE

are the same in DB2 and Teradata SQL.

SET CONNECTION

Establishes the application server of the process by identifying one of its existing connections.

C-18

Teradata RDBMS for UNIX SQL Reference
Comparing Teradata SQL and DB2

DB2 Extensions Not Supported in Teradata SQL

SET CURRENT DEGREE

SET CURRENT RULES

WITH

WITH CHECK

Assigns the application server of the process by identifying one of its existing connections.

Assigns a value to the CURRENT RULES special register.

The WITH clause in Teradata SQL causes subtotal rows to be returned with the detail data rows of a SELECT query, which is not expected by DB2.

DB2 supports a WITH CHECK option in a CREATE VIEW statement

Teradata RDBMS for UNIX SQL Reference

C-19
Comparing Teradata SQL and DB2

Teradata SQL Extensions Beyond DB2

Introduction

Keyword Variants

Inserting Comments

Longer Teradata SQL Object Names

Data Types

Teradata SQL Extensions Beyond DB2

This section describes Teradata SQL features and functions that are not supported by DB2 Version2 Release 2.0 or 3.0, Version 3 or 4. These features and functions can be considered as extensions over DB2.
Previous << 1 .. 199 200 201 202 203 204 < 205 > 206 207 208 209 210 211 .. 241 >> Next