datastage 函数_DataStage常用函数大全

1

/

38

DataStage

常用函数大全

DATASTAGE

常用函数大全

.

................................................................................................

1

一、

类型转换函数

.

.......................................................................................................................

4

1.

Char

.

.............................................................................................................................................

4

2.

DateToString ................................................................................................................................

4

3.

DateToDecimal

.

............................................................................................................................

4

4.

DecimalToDate

.

............................................................................................................................

5

5.

DecimalToDecimal

....................................................................................................................

6

6.

DecimalToDFloat

.

......................................................................................................................

6

7.

DecimalToString

........................................................................................................................

7

8.

DecimalToTime

..........................................................................................................................

8

9.

DecimalToTimestamp

.

..............................................................................................................

8

10.

DFloatToDecimal

..................................................................................................................

9

11.

DfloatToStringNoExp

.

.........................................................................................................

1

0

12.

IsValidDate

.

..........................................................................................................................

1

0

13.

IsValidTime

..........................................................................................................................

1

1

14.

IsValidTimestamp

.

...............................................................................................................

1

1

15.

RawNumAt

...........................................................................................................................

1

1

16.

RawToString

........................................................................................................................

1

2

17.

Seq

........................................................................................................................................

1

2

18.

SeqAt

....................................................................................................................................

1

2

19.

StringToDate

.

.......................................................................................................................

1

2

20.

StringToDecimal

.

.................................................................................................................

1

3

21.

StringToRaw

........................................................................................................................

1

3

22.

StringToTime

.......................................................................................................................

1

3

23.

StringToTimestamp

.............................................................................................................

1

4

24.

StringToUstring

.

...................................................................................................................

1

4

25.

TimestampToDate

...............................................................................................................

1

4

26.

TimestampToDecimal

.

........................................................................................................

1

4

27.

TimestampToString

.............................................................................................................

1

5

28.

TimestampToTime

..............................................................................................................

1

6

29.

TimeToString

.......................................................................................................................

1

6

30.

TimeToDecimal

...................................................................................................................

1

6

31.

UstringToString

.

...................................................................................................................

1

7

二、

字符串函数

......................................................................................................................... 17

32.

AlNum

...................................................................................................................................

1

7

33.

Alpha

.....................................................................................................................................

1

7

34.

CompactWhiteSpace

.

.........................................................................................................

1

8