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