Help Center> Data Warehouse Service> Tool Guide> DSC - SQL Syntax Migration Tool> Supported Keywords and Features> DB2 Keyword and Features
View PDF

DB2 Keyword and Features

Table 1 describes the Netezza keywords and features supported by DSC.

  • The Version column lists the earliest version that supports a keyword or feature.
  • The Remarks column describes how to configure the migration of a keyword or feature.
Table 1 DB2 keywords and features

Section

Object and Keyword/Feature

Version

Remarks

Table

Gauss keyword

Data Type (I)

Foreign Key

Sequence

Tablespace

Default

Data Type (II)

LOB Options

Organize By

8.0.1

-

DML

SELECT

WITH AS

Table Function

8.0.1

Index

Reverse Scans

Schema

8.0.1

NICKNAME

NICKNAME

8.0.1

Statement

CURRENT SCHEMA

GET DIAGNOSTICS with ROW_COUNT

8.0.1

System Function

DAYS

MONTH

YEAR

CURRENT DATE

CURRENT TIMESTAMP

POSSTR

VALUE

date

8.0.1