PowerCenter
- PowerCenter 10.4.0
- 所有产品
機能
| IBM DB2
| Microsoft SQL
サーバ
| Oracle
| PostgreSQL
| SAP HANA
| Sybase ASE
|
---|---|---|---|---|---|---|
ABORT()
| -
| -
| -
| -
| -
| -
|
ABS()
| X
| X
| X
| X
| X
| X
|
ADD_TO_DATE()
| X
| S
| X
| X
| X
| S
|
AES_DECRYPT()
| -
| -
| -
| -
| -
| -
|
AES_ENCRYPT()
| -
| -
| -
| -
| -
| -
|
ASCII()
| X
| X
| X
| X
| X
| X
|
AVG()
| X
| X
| X
| X
| SF
| X
|
CEIL()
| X
| X
| X
| X
| X
| X
|
CHOOSE()
| -
| -
| -
| -
| -
| -
|
CHR()
| X
| X
| X
| X
| X
| X
|
CHRCODE()
| -
| -
| -
| -
| -
| -
|
COMPRESS()
| -
| -
| -
| -
| -
| -
|
CONCAT()
| S
| S
| X
| X
| X
| S
|
COS()
| X
| X
| X
| X
| X
| X
|
COSH()
| X
| S
| X
| -
| X
| S
|
COUNT()
| X
| X
| X
| X
| SF
| X
|
CRC32()
| -
| -
| -
| -
| -
| -
|
CUME()
| -
| -
| -
| -
| -
| -
|
DATE_COMPARE()
| S
| S
| S
| -
| SF
| S
|
DATE_DIFF()
| -
| -
| -
| X
| X
| -
|
DECODE()
| X
| X
| X
| X
| X
| X
|
DECODE_BASE64()
| -
| -
| -
| -
| -
| -
|
DECOMPRESS()
| -
| -
| -
| -
| -
| -
|
ENCODE_BASE64()
| -
| -
| -
| -
| -
| -
|
EXP()
| X
| X
| X
| X
| X
| X
|
FIRST()
| -
| -
| -
| -
| -
| -
|
FLOOR()
| X
| X
| X
| X
| X
| X
|
FV()
| -
| -
| -
| -
| -
| -
|
GET_DATE_PART()
| X
| X
| X
| -
| X
| X
|
GREATEST()
| -
| -
| X
| -
| -
| -
|
IIF()
| X
| X
| X
| X
| X
| X
|
IN()
| X
| X
| X
| SF
| SF
| X
|
INDEXOF()
| -
| -
| -
| -
| -
| -
|
INITCAP()
| -
| -
| X
| X
| X
| -
|
INSTR()
| S
| X
| X
| -
| -
| S
|
IS_DATE()
| -
| -
| -
| -
| -
| -
|
IS_NUMBER()
| -
| -
| -
| -
| -
| -
|
IS_SPACES()
| -
| -
| -
| -
| -
| -
|
ISNULL()
| X
| X
| X
| X
| SF
| X
|
LAST()
| -
| -
| -
| -
| -
| -
|
LAST_DAY()
| -
| -
| X
| X
| X
| -
|
LEAST()
| -
| -
| X
| -
| -
| -
|
LENGTH()
| X
| X
| X
| X
| X
| X
|
LN()
| -
| -
| -
| X
| X
| -
|
LOG()
| X
| S
| X
| X
| X
| S
|
LOOKUP
| X
| X
| X
| X
| -
| X
|
LOWER()
| X
| X
| X
| X
| X
| X
|
LPAD()
| -
| -
| X
| X
| X
| -
|
LTRIM()
| X
| X
| X
| X
| X
| X
|
MAKE_DATE_TIME()
| -
| -
| -
| -
| -
| -
|
MAX()
| X
| X
| X
| X
| SF
| X
|
MD5()
| -
| -
| -
| -
| -
| -
|
MEDIAN()
| -
| -
| -
| -
| -
| -
|
METAPHONE()
| -
| -
| -
| -
| -
| -
|
MIN()
| X
| X
| X
| X
| SF
| X
|
MOD()
| X
| X
| X
| X
| SF
| X
|
MOVINGAVG()
| -
| -
| -
| -
| -
| -
|
MOVINGSUM()
| -
| -
| -
| -
| -
| -
|
NPER()
| -
| -
| -
| -
| -
| -
|
PERCENTILE()
| -
| -
| -
| -
| -
| -
|
PMT()
| -
| -
| -
| -
| -
| -
|
POWER()
| X
| X
| X
| X
| X
| X
|
PV()
| -
| -
| -
| -
| -
| -
|
RAND()
| -
| -
| -
| -
| -
| -
|
RATE()
| -
| -
| -
| -
| -
| -
|
REG_EXTRACT()
| -
| -
| -
| -
| -
| -
|
REG_MATCH()
| -
| -
| -
| -
| -
| -
|
REG_REPLACE
| -
| -
| -
| -
| -
| -
|
REPLACECHR()
| -
| -
| -
| -
| -
| -
|
REPLACESTR()
| -
| -
| -
| -
| -
| -
|
REVERSE()
| -
| -
| -
| -
| -
| -
|
ROUND(DATE)
| -
| -
| X
| -
| -
| -
|
ROUND(NUMBER)
| X
| X
| X
| X
| X
| X
|
RPAD()
| -
| -
| X
| X
| X
| -
|
RTRIM()
| X
| X
| X
| X
| X
| X
|
SET_DATE_PART()
| -
| -
| -
| -
| -
| -
|
SIGN()
| X
| X
| X
| X
| X
| X
|
SIN()
| X
| X
| X
| X
| X
| X
|
SINH()
| X
| S
| X
| -
| X
| S
|
SOUNDEX()
| X
| X
| X
| -
| -
| X
|
SQRT()
| X
| X
| X
| X
| X
| X
|
STDDEV()
| X
| X
| X
| X
| -
| -
|
SUBSTR()
| S
| S
| X
| X
| X
| S
|
SUM()
| X
| X
| X
| X
| SF
| X
|
SYSDATE()
| X
| X
| X
| X
| X
| X
|
SYSTIMESTAMP()
| X
| X
| X
| X
| X
| X
|
TAN()
| X
| X
| X
| X
| X
| X
|
TANH()
| X
| S
| X
| -
| X
| S
|
TO_BIGINT
| X
| X
| X
| X
| X
| X
|
TO_CHAR(DATE)
| X
| X
| X
| X
| SF
| X
|
TO_CHAR(NUMBER)
| X
| X
| X
| X
| X
| X
|
TO_DATE()
| X
| X
| X
| X
| X
| X
|
TO_DECIMAL()
| X
| X
| X
| X
| X
| X
|
TO_FLOAT()
| X
| X
| X
| X
| X
| X
|
TO_INTEGER()
| X
| S
| X
| X
| X
| X
|
TRUNC(DATE)
| -
| -
| X
| -
| -
| -
|
TRUNC(NUMBER)
| X
| X
| X
| X
| -
| S
|
UPPER()
| X
| X
| X
| X
| X
| X
|
VARIANCE()
| X
| X
| X
| X
| -
| -
|
関数
| Greenplum
| Netezza
| Teradata
| Vertica
|
---|---|---|---|---|
ABORT()
| -
| -
| -
| -
|
ABS()
| X
| X
| X
| X
|
ADD_TO_DATE()
| X
| X
| X
| X
|
AES_DECRYPT()
| -
| -
| -
| -
|
AES_ENCRYPT()
| -
| -
| -
| -
|
ASCII()
| X
| X
| -
| X
|
AVG()
| S
| X
| X
| X
|
CEIL()
| X
| X
| S
| S
|
CHOOSE()
| -
| -
| -
| -
|
CHR()
| X
| X
| -
| X
|
CHRCODE()
| -
| -
| -
| -
|
COMPRESS()
| -
| -
| -
| -
|
CONCAT()
| X
| -
| S
| X
|
COS()
| X
| X
| X
| X
|
COSH()
| X
| X
| X
| X
|
COUNT()
| S
| X
| X
| X
|
CRC32()
| -
| -
| -
| -
|
CUME()
| -
| -
| -
| -
|
DATE_COMPARE()
| S
| X
| S
| X
|
DATE_DIFF()
| -
| -
| -
| X
|
DECODE()
| X
| X
| X
| X
|
DECODE_BASE64()
| -
| -
| -
| -
|
DECOMPRESS()
| -
| -
| -
| -
|
ENCODE_BASE64()
| -
| -
| -
| -
|
EXP()
| X
| X
| X
| X
|
FIRST()
| -
| -
| -
| -
|
FLOOR()
| X
| X
| S
| X
|
FV()
| -
| -
| -
| -
|
GET_DATE_PART()
| S
| X
| X
| X
|
GREATEST()
| -
| -
| -
| -
|
IIF()
| X
| X
| X
| X
|
IN()
| S
| -
| X
| -
|
INDEXOF()
| -
| -
| -
| -
|
INITCAP()
| X
| -
| -
| X
|
INSTR()
| -
| -
| S
| X
|
IS_DATE()
| -
| -
| -
| -
|
IS_NUMBER()
| -
| -
| -
| -
|
IS_SPACES()
| -
| -
| -
| -
|
ISNULL()
| S
| X
| X
| X
|
LAST()
| -
| -
| -
| -
|
LAST_DAY()
| -
| -
| -
| X
|
LEAST()
| -
| -
| -
| -
|
LENGTH()
| X
| X
| X
| X
|
LN()
| X
| X
| -
| X
|
LOG()
| X
| X
| S
| S
|
LOOKUP
| -
| X
| X
| X
|
LOWER()
| X
| X
| X
| X
|
LPAD()
| X
| X
| -
| X
|
LTRIM()
| X
| X
| X
| X
|
MAKE_DATE_TIME()
| -
| -
| -
| -
|
MAX()
| S
| X
| X
| X
|
MD5()
| -
| -
| -
| -
|
MEDIAN()
| -
| -
| -
| -
|
METAPHONE()
| -
| -
| -
| -
|
MIN()
| S
| X
| X
| X
|
MOD()
| S
| X
| X
| X
|
MOVINGAVG()
| -
| -
| -
| -
|
MOVINGSUM()
| -
| -
| -
| -
|
NPER()
| -
| -
| -
| -
|
PERCENTILE()
| -
| -
| -
| -
|
PMT()
| -
| -
| -
| -
|
POWER()
| X
| X
| X
| X
|
PV()
| -
| -
| -
| -
|
RAND()
| -
| -
| -
| -
|
RATE()
| -
| -
| -
| -
|
REG_EXTRACT()
| -
| -
| -
| -
|
REG_MATCH()
| -
| -
| -
| -
|
REG_REPLACE
| -
| -
| -
| -
|
REPLACECHR()
| -
| -
| -
| -
|
REPLACESTR()
| -
| -
| -
| -
|
REVERSE()
| -
| -
| -
| -
|
ROUND(DATE)
| -
| -
| -
| S
|
ROUND(NUMBER)
| X
| X
| S
| S
|
RPAD()
| X
| X
| -
| X
|
RTRIM()
| X
| X
| X
| X
|
SET_DATE_PART()
| -
| -
| -
| -
|
SIGN()
| X
| X
| S
| S
|
SIN()
| X
| X
| X
| X
|
SINH()
| X
| X
| X
| X
|
SOUNDEX()
| -
| -
| -
| X
|
SQRT()
| X
| X
| X
| X
|
STDDEV()
| S
| -
| X
| X
|
SUBSTR()
| X
| X
| S
| X
|
SUM()
| S
| X
| X
| X
|
SYSDATE()
| X
| X
| X
| X
|
SYSTIMESTAMP()
| X
| X
| X
| X
|
TAN()
| X
| X
| X
| X
|
TANH()
| X
| X
| X
| X
|
TO_BIGINT
| X
| X
| X
| X
|
TO_CHAR(DATE)
| X
| X
| S
| X
|
TO_CHAR(NUMBER)
| X
| X
| X
| X
|
TO_DATE()
| X
| X
| X
| X
|
TO_DECIMAL()
| X
| X
| X
| X
|
TO_FLOAT()
| X
| X
| X
| X
|
TO_INTEGER()
| X
| X
| X
| X
|
TRUNC(DATE)
| X
| X
| -
| S
|
TRUNC(NUMBER)
| X
| X
| S
| S
|
UPPER()
| X
| X
| X
| X
|
VARIANCE()
| S
| -
| X
| X
|
関数
| Amazon Redshift
| Snowflake
|
---|---|---|
ABORT()
| -
| -
|
ABS()
| X
| X
|
ADD_TO_DATE()
| X
| -
|
AES_DECRYPT()
| -
| -
|
AES_ENCRYPT()
| -
| -
|
ASCII()
| -
| X
|
AVG()
| S
| X
|
CEIL()
| X
| X
|
CHOOSE()
| -
| -
|
CHR()
| X
| X
|
CHRCODE()
| -
| -
|
COMPRESS()
| -
| -
|
CONCAT()
| X
| X
|
COS()
| X
| X
|
COSH()
| -
| X
|
COUNT()
| S
| X
|
CRC32()
| -
| -
|
CUME()
| -
| -
|
DATE_COMPARE()
| X
| X
|
DATE_DIFF()
| X
| X
|
DECODE()
| X
| X
|
DECODE_BASE64()
| -
| -
|
DECOMPRESS()
| -
| -
|
ENCODE_BASE64()
| -
| -
|
EXP()
| X
| X
|
FIRST()
| -
| -
|
FLOOR()
| X
| X
|
FV()
| -
| -
|
GET_DATE_PART()
| X
| X
|
GREATEST()
| -
| -
|
IIF()
| X
| X
|
IN()
| S
| X
|
INDEXOF()
| -
| -
|
INITCAP()
| X
| X
|
INSTR()
| X
| X
|
IS_DATE()
| -
| -
|
IS_NUMBER()
| -
| -
|
IS_SPACES()
| -
| -
|
ISNULL()
| S
| X
|
LAST()
| -
| -
|
LAST_DAY()
| X
| X
|
LEAST()
| -
| -
|
LENGTH()
| X
| X
|
LN()
| X
| X
|
LOG()
| -
| X
|
LOOKUP
| -
| -
|
LOWER()
| X
| X
|
LPAD()
| X
| X
|
LTRIM()
| X
| X
|
MAKE_DATE_TIME()
| -
| -
|
MAX()
| S
| X
|
MD5()
| -
| -
|
MEDIAN()
| -
| X
|
METAPHONE()
| -
| -
|
MIN()
| S
| X
|
MOD()
| S
| X
|
MOVINGAVG()
| -
| -
|
MOVINGSUM()
| -
| -
|
NPER()
| -
| -
|
PERCENTILE()
| -
| -
|
PMT()
| -
| -
|
POWER()
| X
| X
|
PV()
| -
| -
|
RAND()
| -
| -
|
RATE()
| -
| -
|
REG_EXTRACT()
| -
| -
|
REG_MATCH()
| -
| -
|
REG_REPLACE
| -
| -
|
REPLACECHR()
| -
| X
|
REPLACESTR()
| -
| X
|
REVERSE()
| -
| -
|
ROUND(DATE)
| -
| -
|
ROUND(NUMBER)
| X
| X
|
RPAD()
| X
| X
|
RTRIM()
| X
| X
|
SET_DATE_PART()
| -
| -
|
SIGN()
| X
| X
|
SIN()
| X
| X
|
SINH()
| -
| X
|
SOUNDEX()
| -
| -
|
SQRT()
| X
| X
|
STDDEV()
| S
| X
|
SUBSTR()
| X
| X
|
SUM()
| S
| X
|
SYSDATE()
| S
| X
|
SYSTIMESTAMP()
| S
| X
|
TAN()
| X
| X
|
TANH()
| -
| X
|
TO_BIGINT
| X
| X
|
TO_CHAR(DATE)
| S
| X
|
TO_CHAR(NUMBER)
| X
| X
|
TO_DATE()
| X
| X
|
TO_DECIMAL()
| X
| X
|
TO_FLOAT()
| X
| X
|
TO_INTEGER()
| X
| X
|
TRUNC(DATE)
| S
| -
|
TRUNC(NUMBER)
| S
| X
|
UPPER()
| X
| X
|
VARIANCE()
| S
| X
|